Microsoft Access Advanced

Training

In Norwich

£ 175 + VAT

Description

  • Type

    Training

  • Location

    Norwich

  • Duration

    1 Day

This course is designed to provide delegates with the knowledge and skills needed to handle the advanced features of Access. In particular, delegates will learn how to customise and automate their database application through the use of command buttons, macros, events and Switchboard Manager. Suitable for: Those with a good knowledge of Access who wish to develop their skills further.

Facilities

Location

Start date

Norwich (Norfolk)
See map
St James Mill, Whitefriars, NR3 1SH

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Microsoft Access Advanced

One Day Course

Course Aims:
This course is designed to provide delegates with the knowledge and skills needed to handle the advanced features of Access.
In particular, delegates will learn how to customise and automate their database application through the use of command buttons, macros, events and Switchboard Manager.

Assumed Knowledge:

Delegates must have a good working knowledge of Access. They must be regular users who have built Access databases. They must be able to create and maintain tables, forms, queries and reports. It is an advantage to have attended the Jarrold Training Access Intermediate course.

Course Outline:

Automation
· Command buttons in forms
· Command button properties
· Linking forms with buttons
· Using PopUp forms
· Finding records by combo box
Macros
· Creating macros
· Macro commands & arguments
· Running a macro
· Attaching to command buttons
· Editing a macro
· Macro groups
· Conditional macros
Events
· The stages of a record
· Event properties of a form
· Event properties of a control
· Attaching macros to events
· Using events to set properties
· Using Expression Builder
Other Queries
· Unique values
· Re-query to update a combo box
· Query by form
· Top values queries
· Summary & grouping queries
Action Queries
· Make table queries
· Append, delete & update queries
· Hide/show queries
The Finished Application
· Using Switchboard Manager to build a Switchboard
· The Autoexec macro
· Access Startup options
· Disabling user access
· Running from a desktop shortcut
Multi-User Databases
· Shared Databases
· Setting Default Locking Properties
· Creating Groups and Users
· Setting User Permissions
· Assigning Ownership
· Splitting an Access Database
· Changing the Location of the Back-end Database

Microsoft Access Advanced

£ 175 + VAT