Adobe Training
Acrobat Training
Captivate Training
Dreamweaver Training
Flash Training
Flex Training
Illustrator Training
InDesign Training
Photoshop Training
Web Development
AJAX Training
CSS Training
HTML Training
JavaScript Training
PHP MySQL Training
Ruby on Rails Training
XML Training
Microsoft Office
Access Training
Excel Training
Outlook Training
PowerPoint Training
Project Training
Visio Training
Word Training
Business Skills
Anger Management Class
Business Communication
Business Etiquette Training
Business Writing Class
Change Management
Customer Service Training
Project Management Training
Sales Training
Supervisor Training
Time Management Training
QuickBooks
QuickBooks Training
Access Training | Chicago
Fast Facts
1 day
Max 8 students
9.00am to 4.30pm
One per student
Included
295.00
Access 2003 - Level 1
Course Description
Most organizations maintain and manage large amounts of information. One of the most efficient and powerful methods for storing data is a relational database. In this course, you will be introduced to Microsoft Access 2003 - a powerful relational database application and all its information management tools.
Target Audience
This Access course is ideal for people new to Access who need to manage, sort and view large amounts of data. No prior knowledge of Microsoft Access is required, however a general understanding of computers and Windows is beneficial.
Leaning Objectives
Upon successful completion of this Access training course students will be able to:
- Understand Relational databases.
- Overview of Access 2003 navigation and layout.
- Manage Data in an Access database.
- Examine existing Table relationships.
- Write a Simple Database Query.
- Create and Customize Forms.
- Create and modify Access reports.
Upcoming Classes
Chicago |
Aug, 2008 | Sep, 2008 | Oct, 2008 | Nov, 2008 |
| Access 2003 - Level 1 | Sep 24 | Oct 27 |
Course Outline
Overview of Access 2003
- Understand Relational Databases
- Examine the Access Environment
- Open the Database Environment
- Examine an Access Table
Managing Data
- Examine an Access Form
- Add and Delete Records
- Sort Records
- Display Recordsets
- Update Records
- Run a Report
Establishing Table Relationships
- Identify Table Relationships
- Identify Primary and Foreign Keys in the Relationships Window
- Work with Subdatasheets
Querying the Database
- Create a Select Query
- Add Criteria to a Query
- Add a Calculated Field to a Query
- Perform a Calculation on a Record Grouping
Designing Forms
- Examine Form Design Guidelines
- Create a Form Using AutoForm
- Create a Form Using the Form Wizard
- Modify the Design of a Form
Producing Reports
- Create an AutoReport
- Create a Report by Using the Wizard
- Examine a Report in Design View
- Add a Calculated Field to a Report
- Modify the Format Properties of a Control
- AutoFormat a Report
- Adjust the Width of a Report
Meet the Instructors
Rich
Rich has been creating custom software programs, and delivering tailored training classes for the past 13 years. His passion for instruction and his pursuit of all things technical, combine with his outgoing personality to provide an engaging and enthusiastic exchange of knowledge and ideas with his trainees. Software training for Rich is a labor of love. As he puts it, "When you love what you do, it's really not work after all!"
