Contents:
| Systems Design |
Working with Tables |
| · What is a Database |
· Find and Sort Data |
| · Analysis and Investigation |
· Filter by Selection, Filter by Form |
| · Design and Considerations |
· Show Related Tables |
| · Implementation & Maintenance |
|
|
Creating Forms |
| Understanding Access Objects |
· Auto Forms |
| · Opening a Database |
· Create using Form Wizard |
| · Viewing Database Objects |
· Edit Forms in Design View |
| · Tables |
|
| · Reports |
Creating Reports |
| · Forms |
· Reports Wizard |
| · Queries |
· Single Column and Tabular Reports |
| · Macros |
· Edit Reports in Design View |
|
· Creating Mailing Letters and Labels |
| Creating a Database |
|
| · Access Menus & Toolbars |
Creating Queries |
| · Working with Task Panes |
· Query Concepts |
| · Creating a Table in Design View |
· Creating a New Query |
| · Classifying Data Types |
· Specifying Criteria in a Query |
| · Setting simple Field Properties |
· Parameter Queries |
| · Setting the Primary Key |
· Pattern Matching |
| · Datasheet v Design View |
· Calculated Fields |
| · Entering & Replacing Data |
|
| · Format Table |
Defining Relationships |
|
· Relational vs. Flat File Database |
|
· Identifying Primary Keys |
|
· Creating Relationships |
Target Audience: Individuals who have a need to store and retrieve information using automated procedures.
Assumed Knowledge: No prior knowledge of databases or Access is assumed.
Duration:
1 Day - Click here to see our course calendar.
Suggested follow-up course: MS Access Specifics