The skills and knowledge covered in this publication 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.

• 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
• add calculated fields to queries
• create action queries to make tables, and update, append, and delete records
• understand table and query relationships and how they affect the integrity of your data
• protect your database files against unauthorised access
• use the Switchboard Manager to create a menu system.

1. Sorting & Filtering Table Data
2. Formatting Table Data
3. Data Validation
4. Exporting Records
5. Exporting To HTML
6. Parameter Queries
7. Calculated Fields
8. Action Queries
9. Table & Query Relationships
10. Database Protection
11. Using The Switchboard