Microsoft Access Developer

Course Objectives

After completing this course the delegate will be able to produce a database which could be used by people with no Microsoft Access knowledge.

Prerequisites

Some experience in using/creating a database would be beneficial.

Course Duration

2 days

Course Content

  • Introduction
    • Basic Concepts
    • The Training Database Project.
  • Tables
    • Normalising the Data
    • Naming Conventions
    • Creating the Tables
    • Relationships between Tables
  • Forms
    • Using the Form Wizard
    • Setting Form Properties
    • Setting Control Properties
    • Importing Microsoft Excel data
    • Creating a Main Form/Sub Form
  • Creating a Menu System
    • Designing a Menu Form
    • Writing a Macro for the Menu
    • Returning to the Menu
    • The Start-up dialog box
  • Database Utilities
    • Compact and Repair
    • Database Splitter
    • Linked Table Manager
    • Converting a Database
  • Queries and Reports
    • Multi-Table Queries
    • Using the Report Wizard
    • Working in Design View
    • Adding Reports to the Menu
  • Macros
    • Basic Features
    • The AutoExec Macro
    • List of Actions
  • Modules
    • Some Definitions
    • List of Events
    • Creating a Function Procedure
  • Events
    • When Events Occur
    • List of Events
    • Creating an Event Procedure
  • Expressions
    • About Expressions
    • Generating Custom Codes
  • Dynamic Queries
    • Develop the Query
    • Link to a Main Form/Sub Form
    • Automate with simple Visual Basic code
  • Action Queries
    • Make Table Queries
    • Append Queries
    • Update Queries
    • Delete Queries
  • Final Steps
    • Calculations in Queries

Download Course Content PDF

Acrobat-PDF

Download Full Course Schedule PDF

Acrobat-PDF

Ask a question

Please contact us to make a booking or book now on-line.

All courses are available for both scheduled (open) and dedicated (bespoke) delivery. Please contact us for details and pricing.

If you can’t see the course you are looking for – contact info@base2.co.uk