Microsoft Office Access 2007 Level 2 Course
Course DescriptionIn this course, you will consider how to maintain data consistency, how to customize database components, and how to share Access data with other applications. You will maintain data consistency and integrity; improve queries, forms, and reports; and also integrate Microsoft Office Access 2007 with other applications.This course is designed for students who would like to learn intermediate-level operations of the Microsoft Office Access program. The Level 2 course is for individuals whose job responsibilities include maintaining data integrity; handling complex queries, forms, and reports; and sharing data between Access and other applications. This course is also a prerequisite to taking more advanced courses in Access 2007.
Upon successful completion of this course, students will be able to:
|
£235 1 day course Scheduled Dates: 17 January 2012 14 February 2012 13 March 2012 10 April 2012 08 May 2012 06 June 2012 Location: PTR's Training Centre Wokingham, Berkshire. |
Course pre-requisites:
Topics covered on the 1 day Microsoft Office Access 2007 Level 2 course
Controlling Data Entry
- Restrict Data Entry Using Field Properties
- Establish a Pattern for Entering Field Values
- Create a List of Values for a Field
Joining Tables
- Create Query Joins
- Join Unrelated Tables
- Relate Data Within a Table
Creating Flexible Queries
- Set Select Query Properties
- Create Parameter Queries
- Create Action Queries
Improving Forms
- Design a Form Layout
- Enhance the Appearance of a Form
- Restrict Data Entry in Forms
- Add a Command Button to a Form
- Create a Subform
Customizing Reports
- Organize Report Information
- Format the Report
- Set Report Control Properties
- Control Report Pagination
- Summarize Report Information
- Add a Subreport to an Existing Report
- Create a Mailing Label Report
Sharing Data Across Applications
- Import Data into Access
- Export Data
- Analyze Access Data in Excel
- Export Data to a Text File
- Merge Access Data with a Word Document
Appendix A: Microsoft Office Specialist Program
Course Classification:
Applications Training Course
This is an instructor led training course taught in a classroom based environment.
Scheduled course dates
17 January 2012 to 17 January 2012
14 February 2012 to 14 February 2012
13 March 2012 to 13 March 2012
10 April 2012 to 10 April 2012
08 May 2012 to 08 May 2012
06 June 2012 to 06 June 2012
View full schedule of Microsoft Access courses
View full schedule of Microsoft Access 2007 courses
Print / Download PDF Version of full course schedule
If you would prefer to run this course at your premises as you have several employees to place on the course perhaps, then we are also able to offer onsite Microsoft Access Training and bespoke Microsoft Access courses