Skip Main Navigation
Page Content

Save This Event

Event Saved

Available Dates

Ticket Information

Ticket Type Sales End Price Fee VAT Quantity
Microsoft Access Advanced 1 hour before event starts £187.93 £7.07 £39.00

Share Microsoft Access Advanced

Event Details

This course is designed for delegates who have been trained in using Microsoft Access and self-taught users who have been working with Access for several years.

Delegates will learn techniques required when creating complex Access database solutions; such as creating macros, writing advanced queries, building complex forms and reports and advanced database maintenance.

The course is held in Peterborough at the following address:

Pinnacle House
4-5 Newark Rd
PE1 5WS.

The training centre can be reached by car or by a short taxi ride from Peterborough station. If you travel by car, free parking is available at the centre; or, if you take a taxi from the station, we will reimburse your fare. Lunch and refreshments are also provided.

Course Outline

Working With Macros

Creating A Macro, Adding Additional Macro Actions, Running A Macro Step-­‐By-­‐Step, Assigning A Macro To A Command Button, Creating A Macro Group, Using A Macro Group, Using Macro Conditions, The Autoexec Macro, Creating An Autokeys Macro, Creating A Data MacroOn Your Own

Action Queries

About Action Queries, Creating A Make-­‐Table Query, Creating An Append Query, Creating An Update Query, Creating A Delete Query

Importing And Exporting Data

Importing Data From A Text File, Importing Data From Excel, Importing Data From Another Access Database, Linking Data, Exporting Data To Other Formats, Exporting Data To A Pdf File, Exporting Data To Another Access Database, Exporting Data To Excel, Exporting Data To Microsoft Word

Creating A Menu System

Creating A Switchboard, Adding Switchboard Items, Using The Switchboard, Editing A Switchboard, Setting Startup Options

Working With Forms And Reports

Adding A Subform Using The Subform/Subreport Tool, Modifying A Subform, Aligning Controls To Each Other, Creating An Option Group, Edit Sorting And Grouping Levels, Inserting Total Fields, Using Rectangles, Lines And Borders

Database Tools And Maintenance

Using Compact And Repair, Changing Database Properties, Documenting A Database, Analyzing A Database, Viewing Object Dependencies, Backing Up A Database, Splitting A Database, Setting A Database PassWord

Do you have questions about Microsoft Access Advanced? Contact G Com Solutions Limited

Save This Event

Event Saved

When & Where

Pinnacle House
4-5 Newark Rd
PE1 5WS Peterborough
United Kingdom


G Com Solutions Limited

G Com Solutions specialise in providing Microsoft Power BI training, as well as IT training on a variety of web technologies and computer software packages, especially those by Microsoft and Adobe. These software environments have become the standard for business, web and multimedia development since they empower companies to develop web solutions more quickly than ever.

Whether you need IT training as an IT specialist or as one of the many people who need computer training to improve their skills for career advancement, G Com Solutions courses can help you. 

  Contact the Organiser

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.