Remote/Online Microsoft Access Training Courses
Learn how to create Desktop databases for business solutions

Microsoft Access Introduction Course

A comprehensive 2-day Microsoft Access training course suitable for complete beginners to Microsoft Access. After the training you will able to create a database from scratch. You will understand and be able to build tables, fields and records, set the rules for entering data and create forms for input.

Also, you'll learn how to extract information in the form of simple queries and reports and export to Excel, PDF and mail merge. Our course also covers database design - essential knowledge when learning to build databases and understanding how they work.

Pre-requisite for attending this course: Must be comfortable with using a computer.

Read More

Microsoft Access Introduction training course outline Two Day Course

Getting Started and Table Design
Create a new database
Overview of the Microsoft Access Environment
Create new tables
Set field names
Choose data types
Consider and set field properties
Create a drop down list

Understanding Relationships
Create One to Many Relationships
Create One to One Relationships
Change Relationship Properties
Understand Referential Integrity

Work with Forms
Create a standard Form
Create a Form using the Wizard
Re-design a Form
Create a Form with a sub-form
Input data using Forms

Work with Queries
Create and save standard Queries
Sort data within a Query
Set criteria for Queries
Concatenate data within a Query
Create calculations in a Query
Use Parameter Query

Work with Reports
Create a report from Table data
Create a report from Query data
Group Information in a Report
Re-design Report elements
Create Mailing Labels

Export data from Microsoft Access
Export information to Microsoft Excel
Export information to Microsoft Word
Export information to a PDF file
Use the Mail Merge feature

Training Dates Delivered Live Online

Thu 3rd & Fri 4th June 2021

Dates are not always set in stone, so if you can't make a date above, or would prefer something sooner, contact us anyway and we'll see what we can do for you.
Training is delivered live online or at your company offices.

Price

£395

Download Course Details

Book this course

Microsoft Access Intermediate Course

A full day designed for those users who wish to step up their current knowledge of Microsoft Access to take advantage of the more complex features.  
Learn to build a database application in a multi-user environment. Create advanced queries and reporting, working with interaction between Microsoft Access objects. Understand the power of macros for automation on this in-depth one day training course.

Pre-requisite for attending this course: Delegates must have either attended our Introduction to Microsoft Access training course, or be confortable with those topics covered at Introduction level.

Read More

Microsoft Access Intermediate training course outline One Day Course

Design a Database
Understand and perform Normalisation
Create a new database
Understand relationship types
Know how to resolve a many to many relationship

Import Data
Import data from Excel
Import data from a text file
Analyse imported data

Create an Interface
Create navigation forms
Use command buttons
Display a form at database start up

Work with Forms
Insert Sub-Forms
Create Combo-boxes
Work with Attachment data types

Work with Queries and Reports
Create Action Queries
Use Functions in Queries
Supply parameters to a form from a Query
Use the Expression Builder
Change Query Joins Types
Create Crosstab Queries
Create Total Queries
Build reports and summarise data

Manage a Database
Back up a Database
Compact and Repair a Database
Password protect a database

Training Dates - Delivered Live Online

Fri 7th May 2021

Thu 1st July 2021

Price

£195

Download Course Details

Book this course

Teams for Live Events

You have built databases to store and retrieve data. Now you may want to plan, design and administer your own database as a working system. A well-designed database allows easy maintenance and quick access of data. In this course, you will plan, design, create and administer a functional and efficient relational database which includes taking bookings, generating invoices and producing reports. You will learn to lock down the database and split into back end and front end. Our Microsoft Access Advanced course also includes function and macro design.

This course is suitable for those who have either attended our Microsoft Access Intermediate level training course or have a sound knowledge of database design and Microsoft Access.

Read More

Microsoft Access Advanced training course outline Two Day Course

Design a Database
Perform Normalisation of data
Create a new database
Set relationships
Resolve a Many to Many and work with a junction table
Import data

Work with Forms
Create a Combo Box Control
Create a List Box Control
Create an Option Group Control
Create a Tabbed Control and manage elements
Insert sub-forms on tabbed control with links
Identify and understand Form Properties

Create Documents from a system
Work with reports
Use unbound controls
Use bound controls
Write functions

Work with Macros
Create Macros to manage behaviour
Create Macros to Export
Use Macros to provide system messages
Assign Macros to database events

Work with Queries
Use Date Functions
Work with other Functions within Queries
Use Queries to generate data for Forms
Write Queries to generate data for Reports

Database Management and Security
Set a database password
Discuss database security
Set Start-up options
Split a database for use as a backend and front end databases
Save a database as ACCDE

Training Dates

Please contact us and we'll arrange a course date to suit you

Price

£445

Download Course Details

Book this course