On-Site Microsoft Access Training Courses

If you or your team need on-site Microsoft Access training in Sussex, Kent, Surrey and London, we can help. We offer Access training for all versions, with the most popular ones being 2007, 2010 and 2013. We often visit clients in Croydon, Guildford, Brighton and Crawley. We can train you at your offices to ensure your staff are fully utilizing Access.

The Microsoft Access training courses listed below are our structured 2 day sessions.  We also offer bespoke/custom IT training for Microsoft Access in Sussex, Kent, Surrey and London that will revolutionise the way your employees operate. Please call us on 01892 665 353 to talk through your business requirements or email us.



No knowledge of database creation is necessary to attend this course. Delegates should be familiar with working in a Windows environment.

Download this course information as a PDF file

Introduction to Databases

  • What is a Database
  • Database Terminology
  • Microsoft Access Environment
  • Access Objects and Terminology
  • Using the Navigation Pane

Creating Access Tables

  • Creating a Database
  • Creating a Table
  • Setting a Primary Key
  • Modifying and Customising Tables
  • Using Lookups
  • Field Properties
  • Importing Tables
  • Linking Tables

Data Entry

  • Viewing Data
  • Adding Records
  • Finding Records
  • Editing Data
  • Changing Datasheet Layout

Relationships between Tables

  • Types of Relationship
  • Creating Relationships
  • Relationship Options
  • Saving and Editing Relationships

Sorting & Filtering Data

  • Sorting Records
  • Filtering Records
  • Specifying Criteria
  • Limitations of Filters



Querying a Database

  • What is a Query
  • What is a Dynaset
  • Creating Queries
  • Specifying Criteria
  • Multiple Criteria

Calculations & Summaries

  • Calculated Fields
  • Summarising in Queries

Multiple Table Queries

  • Using the simple Query Wizard

Forms

  • Creating a Form
  • Types of Forms
  • Creating Autoforms
  • Creating Subforms and Linked Forms
  • Using Forms

Reports

  • Types of Reports
  • AutoReports
  • The Report Wizard
  • Understanding the sections of a report
  • Modifying a Report
  • Using Preview
  • Page Setup
  • Printing a Report

Additional Items – Time Permitting

  • Custom Formats
  • Input Masks
  • Expression Builder
  • Parameter Queries




Delegates should have completed an Introductory Access course or have a good working knowledge of Access.

Download this course information as a PDF file

Creating a Relational Model

  • Different Types of Links
  • Primary Keys
  • Foreign (or Secondary) Keys
  • Setting up Indexes
  • Referential Integrity

Advanced Form Design

  • Creating Multi-Table Forms
  • Advantages of using Subforms
  • Add a Subform to a Main Form
  • Modify the Subform from within the Main Form
  • Check the link between the Main and Subforms
  • Calculated Fields
  • Expression Builder
  • Field Display Types
  • List Boxes and Combo Boxes
  • Option Fields
  • Option Groups

Advanced Queries

  • Table joins
  • Parameter Queries
  • Find Duplicates Queries
  • Find Unmatched Query

Advanced Reporting

  • Reports based on Multiple Tables
  • Selecting records to print
  • Grouping and Sorting the Data
  • Adding Calculated Fields
  • Embedding Sub-Reports



Linking Data

  • Mail Merge with Word for Windows
  • Sending data to Excel
  • Linking data with Excel
  • Get External Data (within Excel)

Performance & Database Design

  • Objectives when designing a Database
  • Database Design
  • Indexes and Keys
  • Creating an Index
  • Which Fields should be Indexed?
  • Multiple Field Indexes

Events on Forms

  • Form Window Events
  • Keyboard Events
  • Data Events
  • Error and Timing Events
  • Focus Events
  • Mouse Events
  • Attaching Macros to Events

Macros

  • What is a Macro?
  • Command Buttons
  • Using Macros on Forms
  • Grouping Macros
  • Passing Values between Forms
  • Using Conditions in Macros
  • Explanations of Conditions

Customising the Ribbon

  • Add a Macro to the Quick Access Toolbar
  • Adding a Group to an existing ribbon tab
  • Removing Groups and Tabs
  • Adding a Macro to the Ribbon





All Onsite Courses

Microsoft Access
Access VBA
Microsoft Excel
Excel VBA
Microsoft Outlook
Microsoft PowerPoint
Microsoft Project
Microsoft Publisher
Microsoft Visio
Microsoft Windows
Microsoft Word
Word VBA
Microsoft Office 2013 Upgrade

What Clients Say