Access – Part 1

Improving Table Usability

• Create lookups within a table
• Work with subdatasheets

Creating Advanced Queries

• Create query joins
• Create subqueries
• Summarize data

Improving Form Presentation

• Apply conditional formatting
• Create tab pages with subforms and other controls

Creating Advanced Reports

• Apply advanced formatting to a report
• Add a calculated field to a report
• Control pagination and print quality
• Add a chart to a report

Importing and Exporting Table Data

• Import and link data
• Export data
• Create a mail merge

Using Queries to Manage Data

• Create action queries
• Create unmatched and duplicate queries

Creating Complex Reports and Forms

• Create subreports
• Create a navigation form
• Show details in subforms and popup forms

Creating Access Macros

• Create a standalone macro to automate repetitive tasks
• Create a macro to program a user interface component
• Restrict records by using a condition
• Create a data macro

Using VBA to Extend Database Capabilities

• Getting started with VBA
• Using VBA with form controls

Managing a Database

• Back up a database
• Manage performance issues
• Document a database

Distributing and Securing a Database

• Split a database for multiple-user access
• Implement security
• Convert an Access database to an ACCDE file
• Package a database with a digital signature