About This Training Course

The skills and knowledge covered in this Access - Level 2 (Creating Smarter Databases) Training Course are sufficient to sort, filter, and query data, to validate data prior to data entry, and to build a small menu system to manage a database.

Subjects Covered

This Access - Level 2 (Creating Smarter Databases) Training Course will cover the following subjects:

• Sorting & Filtering Table Data
• Formatting Table Data
• Data Validation
• Exporting Records
• Exporting To HTML
• Parameter Queries
• Calculated Fields
• Action Queries
• Table & Query Relationships
• Database Protection
• Using The Switchboard

Training Course Outcomes

At the end of the Access - Level 2 (Creating Smarter Databases) Training Course, participants will be able to:

• Sort and filter data in a table
• Format data in tables
• Use a range of data validation techniques to protect data integrity
• Export records from Access
• Export records to HTML for use on the Web
• Add parameters to queries to capture criteria data
• Protect your database files against unauthorised access.

Prerequisites

This Access - Level 2 (Creating Smarter Databases) Training Course assumes a basic knowledge of Microsoft Access 2003, especially building a database file and data tables. It would also be beneficial to have a general understanding of personal computers and the Windows operating system as you will be required to start applications, work with and copy files, and locate file folders.

Other Information

Advanced Training provides a range of computer training solutions offering flexible delivery methods, a cost effective approach, smooth implementation and an exceptional level of quality service.

Advanced Training Locations:
• Queen Street, Melbourne - Victoria
• Moore Street, Turner - Canberra
• York Street, Sydney - New South Wales
• Church Street, Parramatta - New South Wales
• Astor Terrace, Spring Hill - Brisbane, Qld
• Innovation House, Mawson Lakes - South Australia
• Patrick Street, Hobart - Tasmania
• St George's Terrace, Perth - Western Australia

If you need further information contact Startnextweek.com.au on 1300 728 102