Pc Classes


BACK


Beginning Databases

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;

  1. Start, Open and Close Microsoft Access
  2. The Access Window
  3. Menu Bar, Toolbars, Formula Bar, Status Bar
  4. Creating, Closing and Saving a Table
  5. Adding Records to a Table
  6. Previewing and Printing a Table
  7. Creating Additional Tables
  8. Using Form View
  9. Using a Form to View Data
  10. Creating a Report
  11. Help in Access

When completed return to this page.

Quering a Database and the Select Query Window

Complete Project 2, which includes;

  1. Creating , Running and Saving Queries
  2. Displaying selected fields in a Query
  3. Printing the Results of a Query
  4. Entering Criteria
  5. Using Text Data and Wildcards in a Query
  6. Using a Saved Query
  7. Using Compound Criteria
  8. Sorting Data in a Query
  9. Ommiting Duplicates
  10. Joining Tables
  11. Calculations
  12. Crosstab Queries

When completed return to this page.

Maintaining a Database

Complete Project 2, which includes;

  1. Updating Records
  2. Filtering Records
  3. Deleting Records
  4. Changing the Structure
  5. Changing the Appearance
  6. Mass Changes - The Update and Delete Query
  7. Validation Rules
  8. Formatting
  9. Lookup Queries
  10. Referential Integrity
  11. Ordering Records
  12. When to and How to Create an Index
  13. Special Database Operations: Backup, Compacting and Repair

Congratulations!!

You have completed the Spreadsheets Basics course

Turn in your assignments to the computer lab instructor for your certificate.



Email me: arcon4@frontier.com