| |
|
| |
ECDL/ICDL - Database Training Class
Course ID: 5381
|
|
| |
|
|
| |
|
|
| |
ECDL/ICDL - Database Training Seminar
Overview:
In this course, students work with Access 2003 tables, create new forms and reports, and customize database operations.
Who Should Attend:
This course is designed for any professional whose goal is to achieve ECDL certification.
At Course Completion:
Upon successful completion of this course, students will be able to: - examine the Microsoft Office?? Access 2003 database application. - create a table, manipulate records in a table, modify the design and layout of tables, and add and delete relationships between tables. - create and navigate within a form, manipulate records in a form, and add and modify headers and footers in a form. - retrieve data from a table and a form by using the Find command and filters, and also by querying a database. - create a report and organize information within a report. - prepare tables, forms, query results, and reports for printing, and preview them before printing.
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
Agenda |
|
| |
Lesson 1: Using the Access Application
Investigate Database Concepts
Identify Primary and Foreign Keys
Examine the Access Environment
Open the Database Environment
Create a New Database
Get Help Using Access
|
|
Lesson 2: Working with Tables
Examine an Access Table
Create a Table
Add a Field to a Table
Add, Modify, and Delete Records
Delete a Table
Sort Records
Modify Table Design
Change the Layout of a Table
Create Relationships Between Tables
Delete Relationships Between Tables
|
Lesson 3: Working with Forms
Examine an Access Form
Create a Form Using AutoForm
Create a Form Using the Form Wizard
Add, Modify, and Delete Records Using a Form
Add and Modify Headers and Footers in a Form
|
Lesson 4: Retrieving Information
Retrieve Data Using the Find Command
Retrieve Data Using Filters
Create a Select Query
Add Criteria to a Query
Modify a Query in Design View
|
Lesson 5: Working with Reports
Create a Report Based on a Table
Create a Report Based on a Query
Modify the Design of a Report
|
|
Lesson 6: Preparing Outputs
Preview and Print a Table
Preview and Print a Form
Preview and Print a Query
Preview and Print a Report
| |
|
| |
|
|
|
| |
|
|
| |
Pre-requisites |
|
| |
Basic computer skills would be helpful, but are not necessary.
|
|
|
|
| |
|
|
|
|
| |
|
|
| |
|
|
|
| |
| |
|
|
| |
ECDL/ICDL - Database Training Course Dates and Locations
|
|
| |
|
|
| |
Course ID: 5381
| Course Duration: 1 Day
|
|
| |
|
|
| |
Locations: |
|
| |
|
|
| |
|
|
| |
|
|
| |
| Start Date |
Price |
|
Location/Event Details |
Register Online |
Request
More Info |
|
Print/Fax
Register |
|
|
| |
|
|
| |
|
|
|
|
| |
|
|
|
| |
|
|
| |
|
|
| |
Select a market segment to view more courses
|
|
| |
|
|
| |
Or, select a category to view more Information Technology courses
|
|
| |
|
|
| |
 Browse By Category
Browse By Location
Browse New Courses
|
|
| |
|
|
|
| |
| |
|
|
|
|