Microsoft Access Intermediate
   

Duration:

 One Day
   

Aim:

 Delegates will be introduced to the concept of Relational databases linking multiple tables and extracting information from one or more tables. Customising Forms and Reports and gaining an introduction to Macros
   

Who Should Attend:

 Users who have attended the Access Introduction Course or who have experience of designing a flat-file database.
   

Objectives:
  1. To define a Relational Database using multiple tables
  2. To establish the types of Relationships available
  3. To create Action and CrossTab Queries
  4. To build up Queries using the Expression Builder
  5. To customise Forms
  6. To customise Reports
  7. To introduce users to Macro
   

Course Topics
  • Importing Other Databases into Access
  • Linking/ Attaching External Databases into Access
  • Relational Database Concepts
    • Creating a Relational Database
    • Defining Relationships
    • Adding Tables to a Relationship
    • One to One Relationships
    • One to Many Relationships
  • Action Query Types
    • Make Table Queries
    • Update Queries
    • Append Table Queries
    • Delete Queries
  • Cross tab Queries
  • The Expression Builder
  • Creating Customised Forms
    • Setting in Controls that enhance User Efficiency
    • Adding Command Buttons
    • Switchboard Forms
  • Creating Reports
    • Report Wizard
    • Using Groups, Subtotals, Calculations & Totals
  • Introduction to & Use of Macros
Related courses - Microsoft Access - Introduction | Microsoft Access - Advanced
Tircoed Foelgastell Cross Hands Carmarthenshire SA14 7EL
Tel: 01269 832399 Mobile: 07909 785900 Email: info@ace-training.co.uk www.ace-training.co.uk