Course Objective

Create and maintain a database in MS Access.

Course Content

• recognize database components, 

• design data tables, 

• design relational databases.  

• You will start the Access Program: 

• create new databases; 

• create tables using Table Wizards by 

  • naming fields, 

  • defining data types, and 

  • describing fields: 

  • save and close tables; 

• use the Help features; 

• close databases; 

• exit the program.  

• You will open existing databases; 

• Work with records by 

  • viewing table datasheets, 

  • moving around table windows, and 

  • adding, 

  • editing, and 

  • saving records; 

  • set primary keys; and 

  • print table records, 

• Format fields

  • Limit field size; 

  • set Text, 

  • Number, 

  • Date/Time, and 

  • Yes/No formats; 

  • set default values; 

  • use validation rules; 

• modify table design by 

  • changing fields and 

  • data types; 

• modify table datasheets by 

  • changing column widths and row heights, 

  • moving, hiding, and showing columns

  • set relationships between tables. 

• Queries 

  • Create select queries by 

    • selecting tables to query, 

    • changing query fields, and 

    • displaying table names; 

  • view dynasets; 

  • specify query criteria by 

    • entering expressions, 

    • specifying sort order, and 

    • excluding fields from dynasets; 

  • add tables to queries; 

  • save and close queries; 

  • use Query Wizards; and 

  • open and print queries.

• Forms

  • create forms using Form Wizards; 

  • preview form; 

  • modify forms by selecting, moving, sizing, and aligning controls; 

  • save, close and open forms; 

  • use forms to add and view records, 

  • print forms; 

  • find data by finding specific values and using wildcards; 

  • replace data; and 

  • create filters by 

    • selecting fields, 

    • specifying sort order, 

    • specifying criteria, and 

    • applying filters.  

• Reports

  • create reports using Report Wizards; 

  • display reports; 

  • modify reports by 

    • selecting, moving, sizing, aligning, and deleting controls; 

    • save, close, open, and print reports; and 

    • import database tables and spreadsheet data into Access tables.  

• Review all concepts and techniques of this class, therefore preparing yourself for an intermediate class.

Course Duration

This course is 8 hours, and is taught in 2 sessions of 4 hours , including lessons and hands-on practice time.

Send mail to ruthgriffithconsulting@yahoo.com with questions or comments about this web site.
Copyright © 2002 Brenda Dwenger Computerized Accounting