Access 2003 - Level 3

DESCRIPTION
You learn about some maintenance features in Access, along with getting an introduction to SQL (Structured Query Language), a look at some other Query types and options, and create forms from scratch. You also look at exporting Reports.

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


TABLES

• Backing up tables
  
• Copying tables
  
• Fixing a table without a Primary Key
  

Introduction to SQL

• Understanding the SQL behind queries
  
• The SQL Structure
  
• Creating a Union Query
  

Queries

• Crosstab Queries
  
• Select Top 5 Records
  
• Using Date/Time functions
  
• Using Maths Functions
  
• Using Text Functions
  

Forms

• Creating from scratch
  
• Using Combo Boxes and List Boxes
  
• Changing the source of a text box
  
• Adding in a company logo
  
• Creating a SubForm
  
• Creating a form with two Subforms
  
• Creating nested Subforms
  
• Deleing a Subform
  

Reports

• Creating a SubReport
  
• Exporting a report to Snapshot
  
• Exporting a report to Excel
  

Database Maintenance

• Compacting a database
  
• Converting to a different Access version
  
• Setting a database password