Hello, Optima Training has detected that you are using an outdated version of Internet Explorer. If possible we strongly urge you to update your browser or switch over to Chrome or Firefox so you can enjoy the full user experience of our website and avail of all the features!
Close This Message'

Microsoft Access Intermediate

This Microsoft Access Intermediate training course is a 1 Day public programme, designed for anyone who wants to get the most out of Microsoft Access and is an entirely ‘hands on’ course which will give participants experience in producing database applications and the ability to create a variety of data views, queries and reports to more of an Intermediate Level.

Product Code:
1 Day
Cost Includes:
Training course materials and after-training support
Contact Name:
Sinead Landers
X €190.00
Make an Enquiry
Attendee(s), if more than one seperate with a comma
Course Content
Intended Audience
Method Of Delivery

Microsoft Access Intermediate Course Outline

• Creating a Query
• Adding Criteria to a Query
• Running a Query
• Editing Criteria In a Query
• Saving a Query
• Creating a Two Table Query and Sorting the results
• Refining a Query
• Wildcards
• Deleting a Query
• Hiding and Un-Hiding Query Fields

• Creating a Report
• Using the Report Wizard
• Modifying the Layout of a Report
• Widening a Report Column
• Modifying the Report Title
• Adding a Logo to a Report
• Formatting a Form using Themes
• Modifying Field Names within a Report
• Inserting and Formatting the Date & Time
• Adding Existing Fields to a Report
• Resizing Reports For Printing
• Totals
• Closing a Report
• Deleting a Report

• Exporting a Table As an Excel File
• Exporting a Table As a Text File
• Exporting a Table As a Text CSV File
• Exporting a Table As a PDF File
• Exporting a Table As an XML File

• Print Previewing
• Portrait and Landscape
• Adjusting Layout In Print Preview
• Margins
• Printing a Complete Table
• Printing Selected Records
• Printing a Query or Reports
• Printing Forms

Reference: the Access Interface
• Opening a Database
• Opening a Table
• The Ribbon (Toolbar)
• Ribbon Tabs
• Groups
• Dialog Box Launcher
• Navigating
• Contextual Tabs
• Minimising the Ribbon
• The File Tab
• Microsoft Access Help
• Closing Access 2010

Database Terminology & Theory
• Database
• Table
• Record
• Field
• Field Data Types
• Field Properties
• Primary Key
• Types of Database

Trusted Locations
• Setting a trusted location

• Creating a Lookup within a Field
• Modifying a Lookup within a Field
• Deleting a Lookup within a Field
• Creating an Input Mask
• Modifying an Input Mask
• Deleting an Input Mask
• Modifying a Field to Require Data Entry
• Modifying a Field So That It Does Not Require Data Entry

• Creating and modifying a One-To-One Relationship
• Creating and modifying a One-To-Many Relationship
• Creating and modifying a Many-To-Many Relationship using a Junction Table
• Enforcing Referential Integrity
• Automatic Updating of Related Fields
• Automatic Deletion of Related Records

• Inner Join
• Outer Join
• Subtract Join
• Self Join



This Microsoft Access Intermediate training programme may be of interest to personnel who wish to gain a comprehensive overview of the Intermediate features of Microsoft Access.

Knowledge of Microsoft Access Basic is required.

Classroom based, instructor lead, practical hands on course with Computer / Laptop per person during the session

There are no reviews yet.

Be the first to review “Microsoft Access Intermediate”