| |
|
| |
Microsoft Office Access 2003: Level 2 Training Class
Course ID: 14825
|
|
| |
|
|
| |
|
|
| |
Microsoft Office Access 2003: Level 2 Training Seminar
If you have a working knowledge of Microsoft?? Access, this course will help you build on your existing skills. It will show you how to design and create new databases, tables, and relationships, customize database components, enhance forms and reports, perform queries more efficiently, and expand the reach of your databases by integrating Access 2003 with other MS Office applications such as Word or Excel.
This course is part of a set of courses aimed at helping you master the Microsoft Office Specialist (MOS) skill sets. MOS certification is a globally recognized standard for demonstrating expertise in specific Microsoft products. Certification candidates must pass one or more product proficiency examinations to earn Office Specialist certification.
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
Agenda |
|
| |
Lesson 1: Planning a Database
- Topic 1A: Design a Relational Database
- Topic 1B: Identify Database Purpose
- Topic 1C: Review Existing Data
- Topic 1D: Determine Fields
- Topic 1E: Group Fields into Tables
- Topic 1F: Normalize the Data
- Topic 1G: Designate Primary and Foreign Keys
Lesson 2: Building the Structure of a Database
- Topic 2A: Create a New Database
- Topic 2B: Create a Table Using a Wizard
- Topic 2C: Create Tables in Design View
- Topic 2D: Create Relationships between Tables
Lesson 3: Controlling Data Entry
- Topic 3A: Restrict Data Entry with Field Properties
- Topic 3B: Create an Input Mask
- Topic 3C: Create a Lookup Field
Lesson 4: Finding and Joining Data
- Topic 4A: Find Data with Filters
- Topic 4B: Create Query Joins
- Topic 4C: Join Unrelated Tables
- Topic 4D: Relate Data Within a Table
Lesson 5: Creating Flexible Queries
- Topic 5A: Set Select Query Properties
- Topic 5B: Create Parameter Queries
- Topic 5C: Create Action Queries
Lesson 6: Improving Your Forms
- Topic 6A: Enhance the Appearance of a Form
- Topic 6B: Restrict Data Entry in Forms
- Topic 6C: Add Command Buttons
- Topic 6D: Create a Subform
Lesson 7: Customizing Your Reports
- Topic 7A: Organize Report Information
- Topic 7B: Set Report Control Properties
- Topic 7C: Control Report Pagination
- Topic 7D: Summarize Information
- Topic 7E: Add a Subreport to an Existing Report
- Topic 7F: Create Mailing Labels
Lesson 8: Expanding the Reach of Your Data
- Topic 8A: Publish Access Data as a Word Document
- Topic 8B: Analyze Access Data in Excel
- Topic 8C: Export Data to a Text File
- Topic 8D: Merge Access Data with a Word Document
Wrap-up
- Microsoft Office Specialist Program
- Recap, Q/A, Evaluations |
|
| |
|
|
|
| |
|
|
| |
Audience |
|
| |
Those with some exposure to Access who wish to become more savvy Access users or prepare for the Microsoft Office Specialist Certification for Access 2003.
|
|
|
| |
|
|
| |
Pre-requisites |
|
| |
- Microsoft Office Access 2003: Level 1 (M-ACCESS03L1, 1 day)
|
|
|
|
| |
|
|
|
|
| |
|
|
| |
|
|
|
| |
| |
|
|
| |
Microsoft Office Access 2003: Level 2 Training Course Dates and Locations
|
|
| |
|
|
| |
Course ID: 14825
| Course Duration: 1 Day
|
|
| |
|
|
| |
Locations: |
|
| |
|
|
| |
|
|
| |
|
|
| |
| Start Date |
Price |
|
Location/Event Details |
Register Online |
Request
More Info |
|
Print/Fax
Register |
|
|
| |
|
|
| |
|
|
|
|
| |
|
|
|
| |
|
|
| |
|
|
| |
Select a market segment to view more courses
|
|
| |
|
|
| |
Or, select a category to view more Information Technology courses
|
|
| |
|
|
| |
 Browse By Category
Browse By Location
Browse New Courses
|
|
| |
|
|
|
| |
| |
|
|
|
|