Microsoft Access Intermediate

MODULE 1: Advanced File Tasks
Learning outcomes: A look at some important administrative features necessary for managing an Access Database file.
Topics covered:

• Using Windows Explorer within Access
• Database Management
• Saving Your Files
• Exporting Files
• Linking Files

MODULE 2: Working with Tables
Learning outcomes: Further developing an understanding of tables, looking deeper into a table's properties fine tuning data types and use data validation.
Topics covered:

• Customising Tables
• Table Properties: Formatting
• More Table Properties
• Data Validation and Lookup Wizard

MODULE 3: Working with Forms
Learning outcomes: Building professional forms to enhance the user experience and improve effective use.
Topics covered:

• Basic Form Controls
• Advanced Form Controls
• Formatting Your Form
• Formatting Controls
• Using Themes

MODULE 4: Working with Reports
Learning outcomes: Organise and format your reports professionally and common report tasks you may need to perform.
Topics covered:

• Organizing Report Data
• Formatting Reports
• Common Report Tasks

MODULE 5: Working with Queries
Learning outcomes: Creating a range of different queries from very basic queries through to management queries with advanced functionality.
Topics covered:

• Basic Queries
• Doing More with Queries
• Creating Advanced Queries
• Creating Management (Action) Queries