Training Program Details
Unit 1 : Database concepts
Topic A: 0 Database concepts and terminology
A-1: Using database terminology
Topic B: 0 Exploring the Access environment
B-1: Starting and examining the Access window
B-2: Opening a database
B-3: Examining the database window
B-4: Examining a database table
Topic C: 0 Planning and designing databases
C-1: Planning a database
C-2: Exploring database relationships
Topic D: 0 Getting help
D-1: Using the Ask a Question box
D-2: Using the Office Assistant
Topic E: 0 Closing a database and Access
E-1: Closing a database and Access
Unit 2 : Access basics
Topic A: 0 Exploring tables and forms
A-1: Discussing views
A-2: Examining a table in Datasheet view
A-3: Navigating in a table in Datasheet view
A-4: Examining a table in Design view
A-5: Identifying the primary key
A-6: Navigating in a form
A-7: Examining a form in Design view
Topic B: 0 Examining queries
B-1: Planning a query
B-2: Examining a query in Design view
B-3: Running the query and viewing the results
Topic C: 0 Exploring reports
C-1: Examining a report
C-2: Examining a report in Design view
Unit 3 : Creating databases
Topic A: 0 Creating a database
A-1: Verifying object names
A-2: Creating a database by using the Database Wizard
A-3: Creating a blank database
Topic B: 0 Using the Table Wizard
B-1: Creating a table and setting a primary key using the Table Wizard
Topic C: 0 Working in Design View
C-1: Creating a table in Design view
C-2: Adding text fields to a table
C-3: Adding fields of other data types
C-4: Entering field descriptions
C-5: Adding a Memo field
C-6: Setting the primary key
C-7: Saving the design and viewing the table
C-8: Adding a record
Unit 4 : Working with fields and records
Topic A: 0 Changing the design of a table
A-1: Examining field names
A-2: Changing the name of a field
A-3: Deleting and inserting fields
A-4: Moving a field
A-5: Setting field properties
Topic B: 0 Adding and deleting records
B-1: Adding a new record
B-2: Deleting a record
Topic C: 0 Finding and editing records
C-1: Finding and replacing a value
C-2: Undoing changes
C-3: Using spelling checker
Topic D: 0 Sorting and filtering records
D-1: Sorting records by a single field
D-2: Sorting records by multiple fields
D-3: Filtering records
Unit 5 : Querying tables
Topic A: 0 Creating and using queries
A-1: Creating a simple query by using the Simple Query Wizard
A-2: Creating a simple query in Design view
A-3: Sorting query results
A-4: Filtering query results
A-5: Saving a query
Topic B: 0 Modifying query results and queries
B-1: Editing query results
B-2: Modifying a query by adding more fields
B-3: Modifying a query by removing fields
B-4: Using comparison operators
B-5: Using the OR condition
B-6: Using the AND condition
B-7: Using the * wildcard
B-8: Finding records with empty fields
Topic C: 0 Using calculations in queries
C-1: Using calculations in a query
C-2: Totaling a group of records
C-3: Calculating values with the Avg and Count functions
Unit 6 : Creating and using forms
Topic A: 0 Creating forms by using AutoForm
A-1: Creating a form by using AutoForm
A-2: Navigating in a form by using the navigation bar
A-3: Using a form for data entry
Topic B: 0 Using the Form Wizard
B-1: Creating a form by using the Form Wizard
Topic C: 0 Using Design view
C-1: Creating a form in Design view
C-2: Adding a title to a form
C-3: Adding controls
C-4: Modifying properties
Topic D: 0 Finding, sorting, and filtering records
D-1: Using a form to find records
D-2: Using a form to sort records
D-3: Using a form to filter records
Unit 7 : Creating and using reports
Topic A: 0 Using the Report Wizard and queries
A-1: Using the Report Wizard to create a report
A-2: Create a report by using a query
Topic B: 0 Creating, modifying, and printing reports
B-1: Modifying the appearance of a report by using Design view
B-2: Grouping information in a report
B-3: Adding summary fields by using the Report Wizard
B-4: Modifying the layout and style of a report
B-5: Changing field properties
B-6: Printing a report
Unit 8 : Importing, exporting, and linking objects
Topic A: 0 Importing Access objects
A-1: Importing an object from a database
A-2: Importing multiple objects
Topic B: 0 Exporting Access objects
B-1: Exporting objects
Topic C: 0 Exporting and importing XML documents
C-1: Exporting and importing XML documents
Topic D: 0 Linking Access objects
D-1: Linking objects
D-2: Updating a link
Appendix A : MOUS exam objectives map
Topic A: 0 Core exam objectives
Topic B: 0 Expert exam objectives
