Access Advanced
Aims:
Upon completion, delegates will be able to design a database and enhance functionality with advanced queries and macros.
Prerequisites:Must have attended the Microsoft Access Introduction course, or have a good working knowledge of the product.
Duration:Two Days
Fees:Training course fees for this particular course will depend on your chosen Training solution. Please click on the links below for corresponding course fees:
PDF Course Download
You can download a PDF version of the course.
Download Access Advanced course outline.
If you don't have Adobe Acrobat Reader, this can be downloaded from the www.adobe.com web site.
If you are interested in our Access Advanced course call us on
0113 243 2226
Enquire about
this course Now
Course Dates
| Available dates |
|---|
| 15th - 16th September 2010 |
| 20th - 22nd October 2010 |
| 17th - 18th November 2010 |
| 14th - 15th December 2010 |
| 28th - 31st January 2011 |
| 17th - 18th February 2011 |
Advanced Queries
- Self-joins
- Inner and Outer joins
- Parameter queries
- Derived field queries
- Calculated fields
- Combining fields
- AutoLookup queries
- Advanced query wizards
- Query-by-Form queries
Action queries
- Update queries
- Make table and Append queries
- Delete queries
Advanced Form Design
- Form controls
- Combo- and list boxes
- Tab controls
- Main and subforms
- AutoLookup forms
- Non-table based forms
- Multiple table forms
- Advanced form properties
Database Tools
- Table Analyser
- Database Documentor
- Performance Analyser
Importing and exporting data
- Text files
- Spreadsheet files
- Attaching tables
Database Security
- Encrypting and decrypting
- Database file security
- Object-level security
Compacting and repairing databases
Macros
- Command buttons
- Creating macros
- General macro functions
- Using macros
- Creating filter buttons on forms
- AutoExec macros
- Creating Switchboards
- Database start-up properties
- Custom menus and toolbars
