Access Advanced

G Com Solutions
Course summary
Length: 1 day
Location: Nationwide
Next available date: Variable depending on group number - Nationwide

Access Advanced

In-house computer training courses

GCom Solutions  - On-Site Computer Training Courses in the UK - One-to-one and group training

Suitable for delegates with little or no experience of using Acrobat. Delegates will learn how to create PDF documents both for printing and for online delivery. They will then learn how to enhance PDF files by adding navigation elements such as bookmarks and links as well as comments and annotations. The course also teaches tecnhiques for manipulating PDF pages and content, and how to prepare PDF documents for different forms of distribution.

Suitability - Who should attend?

This course requires familiarity with the fundamental features of MS Access. The ability to carry out basic computing tasks, such as saving or copying a file, is also assumed.

Outcome / Qualification etc.

A G Com Solutions Certificate of Attendance is issued on course completion.

Training Course Content

This course is suitable only for those with considerable prior experience and covers: working with macros; action queries; importing and exporting data; creating a menu system; working with forms and reports; and database tools and maintenance.

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


£450 for one-to-one training

£550 for groups of up to 6 people

£650 for groups of up to 12 people

Provider: G Com Solutions

G Com Computer Training Solutions

G COM Solutions Limited - On-Site Computer Training Courses

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. Perhaps you need software training to get into...

Read more and show all courses with Provider: G Com Solutions

Request information - obligation free

Fill out your details to find out more about Access Advanced.

  Contact the provider

  Get more information

  Register your interest


Contact information for G Com Solutions

G Com Solutions

Kemp House, City Road
EC1V 2NX London

 Show phone number
Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Request information

Find out more about this Access Advanced course - simply fill out your details:

Find more courses here

Have your say: