Microsoft Access 2003 Advanced (+)

	You will be introduced to the advanced features of the Access application and also the VBA programming language.
	Duration: 1.0 day(s) Price: £218.00 + VAT	Download Course Content   Download Course Files

Locations

Infero Ltd is based in the Lace Market in Nottingham. Training courses take place at the following locations including Nottingham, Derby, Loughborough, Mansfield, Chesterfield, Burton-on-Trent, Lincoln, Leicester, Sheffield, Stoke-on-Trent, Tamworth, Wolverhampton, Walsall, Birmingham, Solihul, Coventry, Nuneaton, Peterborough, Grantham.

Target Students

Access 2003 Advanced (+) is for students who have a thorough understanding of the basic and advanced user features of the Access program, and are interested in learning introductory level administrator skillsets.

The course is also for the student that may be working in a web-based environment and may need to adapt Access applications to the environment. It is also designed for students pursuing the Microsoft MOS Expert Level Certification for Access 2003.

Prerequisites

Before taking this course, students are recommended to take the following courses, or have equivalent knowledge:

• Windows 2000 Introduction
• Windows XP Introduction
• Windows XP Level 1
• Windows XP Level 2
• Microsoft Access 2003 Introduction
• Microsoft Access 2003 Intermediate
• Microsoft Access 2003 Advanced

Delivery Method

Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

Certification

This course is one of a series of courses that addresses Microsoft Certified Application Specialist (Microsoft Business Certification) skill sets. The Microsoft Certified Application Specialist program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Microsoft Certified Application Specialist certification.

Course Objectives

Upon successful completion of this course, students will be able to:

• Develop a data access page.
• Develop a data access page, a PivotTable, and a PivotChart.
• Import XML data and export Access data.
• Use VBA to automate a business process.
• Create and modify a database switchboard, and set and modify your startup options.
• Distribute a database and add security features to it.

Course Content

Lesson 1: Making Your Data Available on the Web

Topic 1A: Create a Data Access Page by Using the Wizard
Topic 1B: Improve the Presentation of the Data Access Page
Topic 1C: Viewing Data Access Pages with the Browser
Topic 1D: Edit Data Using the Data Access Page
Topic 1E: Group Records in the Data Access Page

Lesson 2: Developing a Data Access Page in Design View

Topic 2A: Create a Data Access Page in Design View
Topic 2B: Incorporate a ComboBox in the Data Access Page
Topic 2C: Test the New Record Function of the Data Access Page
Topic 2D: Develop a PivotTable with the Office PivotTable Tool
Topic 2E: Develop a PivotChart

Lesson 3: Integrating Access into Your Business

Topic 3A: Import XML Data into an Access Database
Topic 3B: Export Access Data to XML Format
Topic 3C: Share Data with Other Office Applications

Lesson 4: Automating a Business Process with VBA

Topic 4A: Create a Standard Module
Topic 4B: Develop Code
Topic 4C: Call a Procedure from a Form
Topic 4D: Run the Procedure

Lesson 5: Creating a Switchboard and Setting the Startup Options

Topic 5A: Create a Database Switchboard
Topic 5B: Modify a Database Switchboard
Topic 5C: Set the Startup Options
Topic 5D: Modify the Startup Options

Lesson 6: Distributing and Securing the Database

Topic 6A: Split a Database
Topic 6B: Implement Security
Topic 6C: Set Passwords
Topic 6D: Encode and Decode a Database
Topic 6E: Convert an Access Database to an MDE File