| |
|
| |
Microsoft Office Access 2003: Level 1 Training Class
Course ID: 14824
|
|
| |
|
|
| |
|
|
| |
Microsoft Office Access 2003: Level 1 Training Seminar
Relational databases are among the most powerful and efficient tools for managing large amounts of information that is necessary for the function of any organization. This course will introduce you to the relational database concepts using Microsoft?? Office Access 2003.
This is the first in a series of four courses on Access. After discussing the basics of relational databases, we will show you how to create, maintain, and locate records as well as produce reports based on the information in the database. You will then learn how to perform more complex tasks such as creating and maintaining new databases and using programming techniques that add power to you Access applications.
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: An Overview of Access 2003
- Topic 1A: Understand Relational Databases
- Topic 1B: Examine the Access Environment
- Topic 1C: Open the Database Environment
- Topic 1D: Examine an Access Table
Lesson 2: Managing Data
- Topic 2A: Examine an Access Form
- Topic 2B: Add and Delete Records
- Topic 2C: Sort Records
- Topic 2D: Display Recordsets
- Topic 2E: Update Records
- Topic 2F: Run a Report
Lesson 3: Establishing Table Relationships
- Topic 3A: Identify Table Relationships
- Topic 3B: Identify Primary and Foreign Keys in the Relationships Window
- Topic 3C: Work with Subdatasheets
Lesson 4: Querying the Database
- Topic 4A: Create a Select Query
- Topic 4B: Add Criteria to a Query
- Topic 4C: Add a Calculated Field to a Query
- Topic 4D: Perform a Calculation on a Record Grouping
Lesson 5: Designing Forms
- Topic 5A: Examine Form Design Guidelines
- Topic 5B: Create a Form Using AutoForm
- Topic 5C: Create a Form Using the Form Wizard
- Topic 5D: Modify the Design of a Form
Lesson 6: Producing Reports
- Topic 6A: Create an AutoReport
- Topic 6B: Create a Report by Using the Wizard
- Topic 6C: Examine a Report in Design View
- Topic 6D: Add a Calculated Field to a Report
- Topic 6E: Modify the Format Properties of a Control
- Topic 6F: AutoFormat a Report
- Topic 6G: Adjust the Width of a Report
Wrap-up:
- Microsoft Office Specialist Program
- Recap, Q/A, Evaluations
|
|
| |
|
|
|
| |
|
|
| |
Audience |
|
| |
Those who wish to learn how to use Access 2003 in their day-to-day job or to understand how a relational database system such as Access can help streamline their business processes.
|
|
|
| |
|
|
| |
Pre-requisites |
|
| |
- Windows XP Professional: Level 2 ( M-WINXPL2, 1 day)
|
|
|
|
| |
|
|
|
|
| |
|
|
| |
|
|
|
| |
| |
|
|
| |
Microsoft Office Access 2003: Level 1 Training Course Dates and Locations
|
|
| |
|
|
| |
Course ID: 14824
| 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
|
|
| |
|
|
|
| |
| |
|
|
|
|