|
Provided by: 123-CBT Computer Based Training Access 2003 Fundamentals |
 |
Training
Provided by 123-CBT Computer Based Training
This course, along with the Proficient User course, maps to the Microsoft Office Specialist certification objectives for the Access 2003 Specialist exam. It presents the learner with the fundamentals of Microsoft Access 2003. The student learns how to create tables and relationships, how to manipulate tables, and how to create simple and advanced queries.
Learn To
The target audience will range from new users to power users, although the vast majority will have had some exposure to previous versions of Access. Fundamental PC and Windows skills are assumed.
Deployment Options
e-Learning
Accreditation
NASBA credits: 4 CPE Credits
CEU credits: 0.70 CEUs
Language Options
French, German, US English
Total Learning Time
3 to 4 hours
Objectives
Unit 1: Table Basics (1 hour)
Learn To
- To identify options in the New File task pane.
- To identify functions of database object views.
- To identify options in the Table Wizard.
- To identify table field properties.
- To create an input mask for a table field.
- To identify options in the Lookup Wizard.
- To identify options in the Simple Query Wizard.
- To create a multiple-table query.
- To identify elements in Select Query Design view.
The target audience will range from new users to power users, although the vast majority will have had some exposure to previous versions of Access. Fundamental PC and Windows skills are assumed.
Deployment Options
e-Learning
Accreditation
NASBA credits: 4 CPE Credits
CEU credits: 0.70 CEUs
Language Options
French, German, US English
Total Learning Time
3 to 4 hours
Objectives
Unit 1: Table Basics (1 hour)
- Identify options in the New File task pane.
- Identify functions of database object views.
- Identify options in the Table Wizard.
- Create a table in Design view.
- Identify options in the Table Properties dialog box.
- Identify methods of managing data in Datasheet view.
- Create a one-to-many relationship.
- Create an input mask for a table field.
- Identify options in the Lookup Wizard.
- Identify options in the Find and Replace dialog box.
- Filter records by form.
- Identify options on the Formatting (Datasheet) toolbar.
- Sort records in a table.
- Filter records by selection.
- Identify the options for navigating records.
- Identify table field properties.
- Identify options in the Simple Query Wizard.
- Identify elements in Select Query Design view.
- Apply an aggregate function to a query.
- Identify components of a calculated field.
- Identify options in the Crosstab Query Wizard.
- Identify options in the Find Unmatched Query Wizard.
- Create a multiple-table query.
- Identify options in the Find Duplicates Query Wizard.
|
|
||||||||||
Access 2003 Fundamentals
--
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6.10
- Access 2003
- Acrobat 6.0
- ASP
- ASP.NET
- C
- Captivate 1.0
- Crystal Reports 8.5
- Crystal Reports v10
- Dreamweaver MX
-...
