Microsoft Access
Advanced

COURSE OUTLINE

Home   Back   Disclaimer  

Advanced table design techniques

• validating field entries, creating a lookup field
• additional table definition topics

Advanced form techniques

• creating a master-detail form, adding a picture to a form
• displaying the current date on a form, modifying form properties

Representing data in a chart

• creating a chart, modifying a chart

Advanced query techniques

• including multiple conditions in a query, creating a parameter query
• creating a query to generate summary information
• creating an action query, changing the join type in a query
• modifying query properties
• optimizing query performance with indexes

Advanced report techniques

• creating a master-detail report, completing the report
• modifying report properties, adding a picture to a report

Working with data access pages

• what is a data Access page ? creating a data Access page
• adding a grouping level to a data Access page
• adding a hyperlink to a data Access page

Transferring data between Access and other applications

• exporting an Access datasheet to Microsoft Excel
• linking or embedding external data in an Access form or report

Working with macros

• what is a macro ? creating a database macro
• running a database macro
• creating and running a command button macro

Using tools menu options

• using the table analyzer wizard and the performance analyzer
• using the database splitter wizard and the linked table manager
• setting database startup options, setting a database password
• additional tools menu options

Additional advanced Access features

• creating a many-to-many relationship between tables
• creating a one-to-one relationship between tables
• creating a switchboard

Final case study

Home   Courses   Word   Excel   PowerPoint   Access   Outlook   Windows   Disclaimer