|
Provided by: Serebra Learning Corporation MS Access 2003 FundamentalsUnfiled |
 |
Training
Provided by Serebra Learning Corporation
This 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.
|
|
||||||||||
MS Access 2003 Fundamentals
Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC V3W 1K5 Canada
Audience
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.
Objective
Upon completion of this course the student will learn:
- 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.
Topics Include
Unit 1: Table Basics
- 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.
Unit 2: Manipulating Tables
- 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.
Unit 3: Querying Data
- 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.
Duration
3 Hours
Minimum Requirements
The CDROM version of this course requires:
- At least a 486DX 33Mhz CPU.
- Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
- At least 8MB RAM.
- At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
- At least a double speed CDROM drive.
- An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).
- At least a 486DX 33Mhz CPU.
- Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
- At least 8MB RAM and 22MB available hard disk space or file server space.
- At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
Media
CDROM
Web Based Training
Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC V3W 1K5 Canada
About The Training Provider: Serebra Learning Corporation
Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1,825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
