 |
|
|
"It was the people...at the end of the day we have to feel comfortable with those we are working with. Datamann people...
... read more
|
|
|
|
|
|
Back to Class List |
|
|
|
Microsoft Access 2007 - Beginner |
|
|
Levels:
Beginner
Intermediate
Advanced
Class length: 1 day
Class Objectives
Modify a table's design; use the Find feature and the spelling checker; and sort, filter, and delete records.
Set field properties; create input masks; set validation rules; and create single- and multiple-field indexes.
Create queries, and sort and filter the results; modify queries; and perform operations in queries.
Create, modify, and work with forms; and use them to find, sort, and filter records.
Class Outline
Unit 1: Getting started
Topic A: Database concepts
Topic B: Exploring the Access environment
Topic C: Getting help
Topic D: Closing a database and Access
Unit 2: Databases and tables
Topic A: Planning and designing databases
Topic B: Exploring tables
Topic C: Creating tables
Unit 3: Fields and records
Topic A: Changing the design of a table
Topic B: Finding and editing records
Topic C: Organizing records
Unit 4: Data entry rules
Topic A: Setting field properties
Topic B: Working with input masks
Topic C: Setting validation rules
Topic D: Using indexes
Unit 5: Simple queries
Topic A: Creating and using queries
Topic B: Modifying query results and queries
Topic C: Performing operations in queries
Unit 6: Using forms
Topic A: Creating forms
Topic B: Using the Form Wizard
Topic C: Using Design view
Topic D: Finding, sorting, and filtering records
Unit 7: Working with reports
Topic A: Creating reports
Topic B: Modifying and printing reports |
|
