Microsoft Access Training - Advanced

Microsoft Access Advanced – 2 Days

Exporting Records

• Exporting a table to Excel
• Exporting a table to a text file
• Exporting a filtered table
• Exporting selected records
• Creating an export query

Importing Records

• Importing from a spreadsheet
• Importing from a text file
• Importing and key violations
• Data integrity and importing

Parameter Queries

• Creating a parameter query
• Displaying all records
• Displaying a range with parameters
• Nominating specific data types
• Using parameters in expressions

Crosstab Queries

• Crosstab query theory
• Using the crosstab query wizard
• Modifying a crosstab query
• Formatting crosstab query values
• Creating a query as a data source
• Basing a crosstab query on a query
• Using criteria in crosstab queries
• Adding parameters to a crosstab query 

Action Queries

• Make table queries
• Update queries
• Delete queries
• Append queries

Table & Query Relationships

• Understanding join types
• Using default joins
• Orphan records
• Viewing orphan records
• Deleting orphan records
• Creating an exception query

Building a Form

• Form controls
• Form and control properties
• Add controls to a form
• Attaching tables and fields
• Naming controls
• Using a tab control
• Subforms
• Calculated controls

Building a Report

• Creating a report design
• Laying out a report
• Formatting and aligning objects
• Creating groups in a report
• Creating report totals and subtotals
• Creating a summary report
• Interacting with the user
• Documenting macros

Macro Basics

• Macros versus VBA
• Creating a macro
• Running a macro
• Modifying an existing macro

Macro Techniques

• Creating a print macro
• Using conditions to enhance a macro
• Creating a sequence of conditions
• Using MsgBox
• Using InputBox

Macros on Forms

• Creating an event macro
• Group macros
• Attaching macros to form events
• Setting form properties

Switchboards

• Creating a switchboard
• Creating menu items
• Linking menus
• Modifying the switchboard form
• Changing Access startup

Database Security

• Understanding database security
• Creating a workgroup
• Workgroup administrator
• Securing a database
• Adding groups
• Adding users
• Assigning permissions

Splitting a database

• Using the database splitter
• Working with a split database
• Updating database links

VBA Introduction

• Introductory VBA Terminology
• Writing A Simple Form Procedure
• Examining A Simple Sub Procedure
• Editing An Existing Procedure
• Creating A Standard Module