Access 2003 - Level 2

		Book a course:
		State:	Choose a state... QLD WA	Date: What is OLL?
		City:		Time:
		Price:

Duration: 2 Days Overview: In this course, student will extend their knowledge into some of the more specialised and advanced capabilities. Target Audience: Access 2003: Level 2 is designed for the student who wishes to learn intermediate and advanced operations of the Microsoft Access Database program. The Level 3 course is for the individual whose job responsibilities include working with heavily related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance. It is also designed as one in a series of courses for students pursuing the Microsoft MOS Certification for Access 2003, and it is a prerequisite to taking more advanced courses in Access 2003. Pre-requisites: Access 2003 - Level 1 Outline: Expand All Module 1: Structuring Existing Data Import Data Analyze Tables Create a Junction Table Improve Table Structure Module 2: Writing Advanced Queries Create Unmatched and Duplicates Queries Group and Summarize Records Using the Criteria Field Summarize Data with a Crosstab Query Create a PivotTable and a PivotChart Display a Graphical Summary on a Form Module 3: Simplifying Tasks with Macros Create a Macro Attach a Macro to a Command Button Restrict Records Using a Where Condition Module 4: Adding Interaction and Automation with Macros Require Data Entry with a Macro Display a Message Box with a Macro Automate Data Entry Module 5: Making Forms more Effective Change the Display of Data Conditionally Display a Calendar on a Form Organize Information with Tab Pages Module 6: Making Reports More Effective Cancel Printing of a Blank Report Include a Chart in a Report Arrange Data in Columns Create a Report Snapshot Module 7: Maintaining an Access Database Link Tables to External Data Sources Back Up a Database Compact and Repair a Database Protect a Database with a Password Determine Object Dependency Document a Database Analyze the Performance of a Database