Microsoft Access 2003: Intermediate (2 day)

Course Overview

During this programme, you will gain an understanding of how to join multiple tables in a database and the reasons why you need to do this. You will also learn about designing tables, simple queries, forms, and reports.

We're constantly adding new Microsoft training courses, if you don't see one that suits at present, contact us and we'll source or create one that does.

Related Courses

• Microsoft Access 2002 (XP): Introduction for Beginners (1 day)
• Microsoft Access 2003: Introduction for Beginners (1 day)
• Microsoft Access 2003: Advanced (1 day)
• Microsoft Access 2003: Introduction for Beginners (2 day)
• Microsoft Access 2003: Advanced (2 day)
• Microsoft Access 2003: Visual Basic Applications (VBA)
• Microsoft Access 2002 (XP): Advanced (1 day)
• Microsoft Access 2003: Visual Basic Applications (VBA)
• Microsoft Access 2003: Intermediate (1 day)
• Microsoft Access 2002: Intermediate

Audience

This programme is for you if you use Access in your working life but you now want to take what you know to the next level.

Skills Gained

Delegates will learn how to:

• Perform additional query and report techniques
• Use the Internet features provided by Access
• Use additional table and query design features
• Create forms and reports that display information from two related tables
• Create a visual representation of database information
• Set up and using data access pages
• Export Access data
• Automate Access operations

Prerequisites

Experience in working within the Microsoft Windows environment is essential, as well as some experience in working with Access. In particular, you should be able to:

• Start and exit from Access
• Create a new database and a new table
• Use the autoform wizard to create a form
• Enter and edit records in both datasheet view and form view
• Print the datasheet of a table
• Search through and sort records
• Create and run a query
• Use the autoreport wizard and report wizard to create a report

Course Outline

Additional query techniques

• Creating a query to extract information from multiple tables
• Finding unmatched records in a table

Additional report techniques

• Creating a report of information in multiple tables
• Adding a calculated control to a report
• Adding a cover sheet to a report

Working with a data access page

• What is a data access page?
• Creating a data access page
• Adding a pivot table and chart to a data access page
• Adding a grouping level and hyperlink to a data access page

Additional Access features

• Using a database wizard
• Adding a lookup field to a table
• Defining an input mask for a field
• Exporting an Access datasheet to Excel

Advanced table design techniques

• Validating field entries, creating a lookup field
• Creating a custom input mask

Advanced form techniques

• Creating a master-detail form; adding a picture to a form
• Displaying the current date on a form, modifying form properties

Advanced filter and query techniques

• Creating an advanced filter
• Including multiple conditions in a query
• Creating a parameter query
• Creating a query to generate summary information
• Creating an action queryAdvanced report techniques
• Creating a master-detail report; completing the report
• Modifying report properties

Working with macros and modules

• What is a macro?
• Creating and running a macro
• Creating a command button
• Writing an event procedure

Using tools menu options

• Setting database startup options and a password
• Encrypting, decrypting, compacting and repairing a database
• Using the database splitter wizard and the linked table manager
• Creating a replica of a database

Additional advanced Access features

• Creating a many-to-many relationship between tables
• Creating a switchboard
• Exporting Access data to an XML document
• Importing an XML document into Access
• Saving an Access database in an MDE file
• Creating an Access workgroup