In this lesson, you will learn:
Use the Shelley Cashman Book for Microsoft Access, Comprehensive Concepts and Techniques to complete this section. It is in the Black file cabinet in the front of the room.
Creating a Database
Complete Project 1, which includes;
- Start, Open and Close Microsoft Access
- the Access Window
- Menu Bar, Toolbars, Formula Bar, Status Bar
- Creating, Closing and Saving a Table
- Adding Records to a Table
- Previewing and Printing a Table
- Creating Additional Tables
- Using Form View
- Using a Form to View Data
- Creating a Report
- Help in Access
When completed return to this page.
Querying a Database and the Select Query Window
Complete Project 2, which includes;
- Creating , Running and Saving Queries
- Displaying selected fields in a Query
- Printing the Results of a Query
- Entering Criteria
- Using Text Data and Wildcards in a Query
- Using a Saved Query
- Using Compound Criteria
- Sorting Data in a Query
- Omitting Duplicates
- Joining Tables
- Calculations
- Cross tab Queries
When completed return to this page.
Maintaining a Database
Complete Project 2, which includes:
- Updating Records
- Filtering Records
- Deleting Records
- Changing the Structure
- Changing the Appearance
- Mass Changes - the Update and Delete Query
- Validation Rules
- Formatting
- Lookup Queries
- Referential Integrity
- Ordering Records
- When to and How to Create an Index
- Special Database Operations: Backup, Compacting and Repair
|
