Access, Level 2

This course introduces the intermediate Access user to the advanced functions of this popular Windows database management program. Relational database construction, table structure alteration, relational integrity, and efficient information management will be emphasized. Participants will create personal databases and tables, enter data, index records, link tables in queries and reports, and print reports.

Prerequisite: Access, Level 1

Outline:

Database Structure

• Fields
  
• Records
  
• Record data types
  
• Relational database management systems
  
• Field structures and relations
  

  Relational Database Management

• Input masks
  
• Query structures
  
• Report structures
  

  Creating Relational Databases

• Table structure modification
  
• Viewing relationships
  
• Editing relationships
  
• One-to-many relationship
  
• Data entry
  
• Relational integrity
  

  Relational Queries

• Creating
  
• Adding fields to query view
  
• Mathematical expressions
  
• Field captions
  

  Relational Reports

• Creating
  
• Linking tables
  

Return to DGL homepage