Access 2007 Training Course - Cambridge, Milton Keynes, Norwich, Luton, Ipswich, Peterborough, London

Microsoft Access 2007 Training Course (Advanced)
You already have a good working knowledge of Access, working with various Access objects, such as tables, queries, forms, and reports. In this course, you will explore some of the more specialist and advanced aspects of Access, including writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database.
Training Course Outline Structuring Existing Data Analyze Tables Create a Junction Table Improve Table Structure Writing Advanced Queries Create Subqueries Create Unmatched and Duplicate Queries Group and Summarize Records Using Criteria Summarize Data Using a Crosstab Query Create a PivotTable and a PivotChart Simplifying Tasks with Macros Create a Macro Attach a Macro Restrict Records Using a Condition Validate Data Using a Macro Automate Data Entry Using a Macro Making Effective Use of Forms Display a Calendar on a Form Organize Information with Tab Pages Display a Summary of Data in a Form Making Reports More Effective Include a Chart in a Report Print Data in Columns Cancel Printing of a Blank Report Create a Report Snapshot Maintaining an Access Database Link Tables to External Data Sources Manage a Database Determine Object Dependency Document a Database Analyze the Performance of a Database
Course Duration: 1 Day

To see more details as to our East Anglian Training Venues click one of the links below: Cambridge \| Milton Keynes \| Norwich \| Peterborough \| Luton \| Ipswich

Microsoft Access 2007 Training Course