Access Training | Chicago and Los Angeles
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.
Access Training deals
Found out more about our Microsoft Access Training deals and our 100% Money Back Guarantee.
Learning 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 |
Mar, 2010 | Apr, 2010 | May, 2010 | Jun, 2010 |
| Access 2003 - Level 1 | Mar 3 ! | Apr 15 ! | May 24 |
Los Angeles |
Mar, 2010 | Apr, 2010 | May, 2010 | Jun, 2010 |
| Access 2003 - Level 1 | Apr 14 | May 25 |
* Class almost full ! Class guaranteed to run † Class is full
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!"
