Microsoft® Office Access® 2010: Level 3
Course Specifications
Course number: 084589
Course length: 1.0 day(s)
Course Description
Course Objective: You will create complex Access databases by structuring existing
data, writing advanced queries, working with macros, and performing database
maintenance.
Target Student: This 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.
Prerequisites: To ensure your success, knowledge of basic and intermediate
features of Access tables, relationships, and queries, forms, and reports
is recommended. The following Element K courses or equivalent knowledge is
recommended:
- Microsoft® Office Access® 2010: Level 1
- Microsoft® Office Access® 2010: Level 2
Hardware Requirements
For this course, you will need one computer for each student
and one for the instructor. Each computer will need the following minimum
hardware components:
- A 1 GHz Pentium-class processor or faster.
- A minimum of 256 MB of RAM. 512 MB of RAM is recommended.
- A 10 GB hard disk or larger. You should have at least 1 GB
of free hard disk space available for the Office installation.
- A CD-ROM drive.
- A keyboard and mouse or other pointing device.
- A 1024 x 768 resolution monitor is recommended.
- Network cards and cabling for local network access.
- Internet access (see your local network administrator).
- A printer (optional) or an installed printer driver.
- A projection system to display the instructor’s computer
screen.
Software Requirements
Each computer requires the following software:
- Microsoft® Office Professional Edition 2010
- Microsoft Office Suite Service Pack 1
- Windows XP Professional with Service Pack 2
Course Objectives
Upon successful completion of this course, students will be able to:
- restructure data into appropriate tables to ensure data
dependency and minimize redundancy.
- write advanced queries to analyze and summarize data.
- create and revise Microsoft® Office Access® 2010
macros.
- customize reports by using various Microsoft® Office
Access® 2010 features.
- maintain their databases using Microsoft® Office Access®
2010 tools.
Course Content
- Lesson 1: Structuring Existing Data
- Topic 1A: Restructure the Data in a Table
- Topic 1B: Create a Junction Table
- Topic 1C: Improve the Table Structure
- Lesson 2: Writing Advanced Queries
- Topic 2A: Create SubQueries
- Topic 2B: Create Unmatched and Duplicate Queries
- Topic 2C: Group and Summarize Records Using Criteria
- Topic 2D: Summarize Data Using a Crosstab Query
- Topic 2E: Create a PivotTable and a PivotChart
- Lesson 3: Simplifying Tasks with Macros
- Topic 3A: Create a Macro
- Topic 3B: Attach a Macro
- Topic 3C: Restrict Records Using a Condition
- Topic 3D: Validate Data Using a Macro
- Topic 3E: Automate Data Entry Using a Macro
- Lesson 4: Creating Effective Reports
- Topic 4A: Include a Chart in a Report
- Topic 4B: Print Data in Columns
- Topic 4C: Cancel Printing of a Blank Report
- Topic 4D: Publish Reports as PDF
- Lesson 5: Maintaining an Access Database
- Topic 5A: Link Tables to External Data Sources
- Topic 5B: Manage a Database
- Topic 5C: Determine Object Dependency
- Topic 5D: Document a Database
- Topic 5E: Analyze the Performance of a Database