Access 2003 - Level 2

DESCRIPTION
This course takes you deeper into each of the Access objects. You learn about table relationships, queries that perform an action, and look a little more closely at some of the form and report functionalities.

PREREQUISITES
Must have attended Access Level 1, or be confident with what tables, queries, forms and reports are, as well as using wizards to create each object.



TABLE RELATIONSHIPS

• Multi-table concepts
  
• Relating Tables
  
• Join Types
  
• Deleting Relationships
  
• Enforcing Relationships
  

QUERIES

• Querying multiple tables
  
• Parameter Queries
  
• Totals Queries
  
• Delete Queries
  
• Append Queries
  
• Make Table Queries
  
• Update Queries
  

IMPORT / EXPORT

• Importing / Exporting from Excel
  
• Importing / Exporting from Access
  
• Importing / Exporting from Text
  
• Linking vs Importing
  

FORMS

• Using Option Groups and Check Boxes
  
• Using Page Tabs
  
• Changing the data source of the form
  
• Adding lines and boxes
  
• Using Conditional formatting
  
• Creating multi-table forms
  

REPORTS

• Using the wizard to create grouped reports
  
• Understanding the design
  
• Manually changing grouping settings
  
• Resizing and moving objects
  
• Adding subtotals and averages
  
• Making cosmetic changes to a report