If you've created working database and want to turn it into a more professional application for others to use, then this is the course for you.

As with all our courses you're welcome to ask questions so you don't need to know everything from our Introduction and Intermediate Access courses, but a good basic knowledge of Access is essential.
 

• Basic Automation - Use command buttons to run queries, open and close forms etc
• Macros - Reuse common automation routines, build in logic and make maintenance easier
• Events - Run macros automatically when opening a form, browsing to the next record or clicking a control
• Queries - More specialist queries for creating summary information and using search forms
• Action Queries - Get queries to delete or update data or make a temporary table for reporting
• Interface - Remove the design interface from Access and automatically display your custom interface
• Multiple users - Record locking, split databases and using the run time environment

Automation

• Command buttons in forms
• Command button properties
• Linking forms with buttons
• Using popup forms
• Finding records by combo box

Macros

• Creating macros
• Macro command categories
• Macro commands & arguments
• Running a macro
• Attaching to command buttons
• Editing a macro
• Macro names/sub-macros
• Conditional macros

Events

• 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
• Database options
• Disabling user access
• Running from a desktop shortcut
• Command line options
• Trusted locations
• Backup and restore databases

Multi-User Databases   

• Shared Databases           
• Record states
• Setting Default Locking Properties
• Encryption and password protection      
• Splitting an Access Database      
• Changing the location of the back-end database
• Making an ACCDE file
• Distributing the application

The course runs from 9:30am through to 4:30pm.

You will learn in a relaxed environment with a small group of people. A specialist tutor will guide and encourage you through all the learning necessary to develop your skills and questions are always welcome.

Included with your course
We provide the following with online and training centre delivered courses.

• Course notes
• Certificate of attendance
• 90 days post course support

Online Delivery
A link to the online training platform will be sent before the course, simply click the link and follow the instructions.

• See Virtual / Remote training information for more details
• Contact us if you'd like to test the platform before the morning of the course
• You can be located anywhere in the world with an internet connection and your computer

Our Training Centres
For training courses run at one of our training centres we include.

• Free onsite parking
• Lunch and refreshments
• Notepad, pen and Polos

Our Norwich on-site parking (NR3 1UB) is free and situated 5 minutes walk along the river to our training centre at St James Mill. If you arrive by train it is about 20 minutes on the Riverside walk or a short taxi ride to get to us. View full directions for Norwich and all our other venues.

• Visual Basic for Access
• SQL Server - Programming and Development
• Excel Advanced Level 2