Microsoft Access - Intermediate - Advanced
   

Duration:

 Two Days
   

Aim:

 Delegates will link multiple tables and extract information from one or more tables. Set up Advanced Queries. Customise Forms and Reports and gaining an introduction to Macros. Look at Database Management Tools and Security
   

Who Should Attend:

 Users who have attended the Access Introduction Course and familiar with simple action queries.
   

Objectives:
  1. To establish the types of Relationships available
  2. To create Action, Advanced, Cascade and CrossTab Queries
  3. To build up Queries using the Expression Builder
  4. To customise Forms
  5. To customise Reports
  6. To introduce users to Macros
  7. Exporting data
  8. Use of Database Management Tools and Database Security
   

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
    • Viewing Relationships
    • Concatention
  • Cascade Update & Cascade Delete
  • Advanced Select Queries
    • Multiple Table Queries
    • AutoLookup Queries
    • Parameter Queries
  • Action Query Types
    • Make Table Queries
    • Update Queries
    • Append Table Queries
    • Delete Queries
  • Cross tab Queries & Data Analysis
  • The Expression Builder
  • Creating Customised Forms
    • Setting in Controls that enhance User Efficiency
    • Bound and Unbound Controls
    • Adding Command Buttons
    • Main Forms & Sub Forms
    • Switchboard Forms
  • Creating Reports
    • Using Groups, Subtotals, Calculations & Totals
    • Mailing Labels
    • Using Controls & Enhancements
  • Exporting Data from Access
  • Database Management Tools
  • Introduction To….. & Use of Macros
  • Database Security Overview
Related courses - Microsoft Access - Introduction
Tircoed Foelgastell Cross Hands Carmarthenshire SA14 7EL
Tel: 01269 832399 Mobile: 07909 785900 Email: info@ace-training.co.uk www.ace-training.co.uk