Access Advanced - duration 1 day


This day is for profient users who want to interact with other programs,such as Word and Excel. You will also learn how to set up a multi-userdatabase across the network. Delegates are invited to bring along their own database designs.

- Update Queries to perform blanket changes to data
- Make-Table Query to create tables from the results of a query
- Append Query to add the results of a query to the end of an existing table
- Delete Query to perform blanket deletions to data
- Exporting data to Microsoft Word and Excel
- Transferring Tables, Forms, Reports and results of Queries
- Linking a Worksheet and working with linked data
- Giving your database a Password
- Creating and Running a Macro
- Using Combo boxes and Group Option boxes
- Creating a Main Menu for a user-friendly database
- Looking after your database
- Compacting the database and repairing a corrupt database
- Splitting your database to allow for proper multi-user capabilities


Home ¦ Training ¦ Database Development ¦ Website Design ¦ Network Installs ¦ Site Menu