Microsoft Access Intermediate Course Overview

• 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

Specific Topics: Microsoft Access Intermediate Course

Sorting & Filtering Table Data

1. Simple Sorting
2. Sorting on Several Fields
3. Creating a Simple Filter
4. Clearing a Filter
5. Filtering by Exception
6. Filtering by Form

Formatting Table Data

1. Changing Column Widths
2. Changing Column Headings
3. Formatting the Data Sheet
4. Changing Fonts
5. Moving Columns
6. Freezing Columns
7. Hiding Columns
8. Unhiding Columns

Data Validation

1. Assigning Default Values
2. Marking a Required Field
3. Validation Rules and Text
4. Creating a Lookup Field
5. Working with Validations
6. Exporting Records
7. Copying a Table
8. Exporting a Table to Microsoft Excel
9. Exporting a Table to Text File
10. Exporting a Filtered Table
11. Exporting Selected Records
12. Creating an Export Query
13. Exporting From a Query

Exporting To HTML

1. Exporting a Table to HTML
2. Viewing an HTML Document
3. Exporting a Report to HTML
4. Creating Hyperlinks

Parameter Queries

1. Creating a Parameter Query
2. Displaying All Records
3. Using Parameters to Display a Record Range
4. Nominating Specific Data Types
5. Using Parameters in Expressions

Calculated Fields

1. Creating a Calculated Field
2. Formatting Calculations
3. Calculating Across Two Tables
4. Calculating Dates
5. Using Criteria in Calculations
6. Concatenating String Fields

Action Queries

1. Creating a Make Table Query
2. Viewing a Table Created By a Make Table Query
3. Expressions & Update Queries
4. Preparing an Update Query
5. Running an Update Query
6. Creating a Saved Update Query
7. Running a Saved Query
8. Creating a Delete Query
9. Creating an Append Query

Table & Query Relationships

1. Understanding Join Types
2. Using Default Joins
3. Orphan Records
4. Viewing Orphan Records
5. Deleting Orphan Records
6. Creating an Exception Query
7. Viewing a Query in SQL

Database Protection

1. Setting a Password
2. Opening a File with a Password
3. Removing a Password
4. Encoding a Database File
5. Decoding a Database File
6. Hiding Database Objects
7. Viewing & Unhiding an Object

Using the Switchboard

1. Creating a Switchboard
2. Creating Subsidiary Menus
3. Creating a Menu Item
4. Returning to Another Menu
5. Creating a Number of Menu Items
6. Linking the Menus
7. Modifying the Menu Forms
8. Changing the Startup

Printable Brochure
Self-Assessment Checklist
Request More Information