Access, Level 1

This course introduces the new Access user to the functions of this popular Windows database management program. Database construction, structure modification, and information management will be presented. Participants will create personal databases and tables, enter data, index records, and print reports.

Prerequisite: Windows, Level 1

Outline:

Database Management

• Database examples
  
• Record
  
• Field
  
• Field types
  

  Getting Started

• Starting Access
  
• Creating a database
  
• Creating a table
  
• Using a table
  
• Viewing records
  
• Record numbers
  
• Displaying all records
  
• Closing the database
  

  Entering & Deleting Data

• Appending records
  
• Saving the database
  
• Editing records
  
• Moving to the ends
  
• Deleting records
  

  Creating A Database

• Planning the structure
  
• Creating the structure
  
• Modifying the structure
  

  Querying A Database

• Using criteria
  

  Formal Reports

• Creating
  
• Printing
  

Return to DGL homepage