Microsoft Access
Intermediate

COURSE OUTLINE

Home   Back   Disclaimer  

Introduction

Modifying the design of a table

• displaying a table in design view
• specifying a required field/ defining a default field value
• setting a primary key for a table
• adding a memo field to a table
• additional table design topics

Working with multiple tables

• displaying multiple tables on the Access desktop
• resizing and repositioning the table window

Relating tables

• creating a relationship between two tables

Working with a custom form

• designing a custom form
• adding a header and footer to a form
• adding a calculated control to a form
• using a custom form to enter data

Intermediate query techniques

• extracting information from multiple tables

Intermediate report techniques

• creating a report of information in multiple tables
• adding a calculated control to a report
• adding a cover sheet to a report
• creating a mailing label report

Using access Internet features

• accessing the world wide web from the Access application window
• linking an Access object to a web page
• exporting an Access object to an HTML file

Additional intermediate Access features

• using a database wizard
• compacting and repairing a database
• backing up and restoring a database
• using the office clipboard

Final case study

Home   Courses   Word   Excel   PowerPoint   Access   Outlook   Windows   Disclaimer