Microsoft Access 2007 Advanced

Requirements:
Experience in working within the Microsoft Windows environment is essential as well as some experience in working with Access. Ideally, you should be familiar with the topics covered at Level 1 standard.-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
-Link a report to Access tables/query
-Print a report
Additional query techniques
-Creating a query to extract information from multiple tables
-Finding unmatched records in a table
Advanced query techniques
-Including multiple conditions in a query
-Creating a parameter query
-Creating a query to generate summary information
Using the query wizards
-Cross-tab
-Find duplicates wizard
-Unmatched query wizard
Using action queries
-Delete query
-Update query
-Make table query
-Append query
Advanced form techniques
-Creating a master-detail form
-Enhancing the appearance of a form
-Using form properties
-Adding ne- fields to an existing form
-Understanding bound and unbound objects
Adding form objects
-Option groups
-Tab control
-Command buttons
-Text boxes (with calculations)Advanced report techniques
-Creating a master-detail report; completing the report
-Modifying report properties
Additional report techniques
-Creating a report using report wizard
-Creating a report of information in multiple tables
-Adding a calculated control to a report
-Applying an auto-format to a report
-Adding a cover sheet to a report
-Setting the report properties
-Adding a sub-report to an existing report
-Controlling report pagination
Using database tools
-Encrypt with a password
-Access database tool
-Using object dependencies
-Database documenter
-Analyse tables
Working with macros and modules
-What is a macro?
-Creating and running a macro
-Creating a command button
Revie- of Programme