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 2007 - Level 1
Course Description
Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing data is by using relational databases. In this Access Training course, you will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft Access 2007 database application.
Target Audience
This Access Training class is designed for students who wish to learn the basic operations of the Microsoft Access database application. It is suitable for individuals whose job responsibilities include designing and creating new databases, tables, and relationships; creating and maintaining records; locating records; and producing reports based on the information in the database. No prior experience of Access is required.
Leaning Objectives
Upon successful completion of this Access training course students will be able to:
- Examine the Basic Database Concepts and Explore the Microsoft Access 2007 Environment.
- Design a Simple Database.
- Build a New Database with Related Tables.
- Manage Data in a Table.
- Query a Database using Different Methods.
- Design Forms.
- Generate Reports.
Upcoming Classes
Chicago |
Aug, 2008 | Sep, 2008 | Oct, 2008 | Nov, 2008 |
| Access 2007 - Level 1 | Sep 3 | Oct 6 | Nov 19 |
Course Outline
Exploring the Microsoft Access 2007 Environment
- Examine Database Concepts
- Explore the User Interface
- Use an Existing Access Database
- Customize the Access Environment
- Obtain Help
Designing a Database
- Describe the Relational Database Design Process
- Define Database Purpose
- Review Existing Data
- Determine Fields
- Group Fields into Tables
- Normalize Data
- Designate Primary and Foreign Keys
- Determine Table Relationships
Building a Database
- Create a New Database
- Create a Table
- Manage Tables
- Create a Table Relationship
- Save a Database as a Previous Version
Managing Data in a Table
- Modify Table Data
- Sort Records
- Work with Subdatasheets
Querying a Database
- Filter Records
- Create a Query
- Add Criteria to a Query
- Add a Calculated Field to a Query
- Perform Calculations on a Record Grouping
Designing Forms
- View Data Using an Access Form
- Create a Form
- Modify the Design of a Form
Generating Reports
- View an Access Report
- Create a Report
- Add a Custom Calculated Field to a Report
- Format the Controls in a Report
- Apply an AutoFormat Style to a Report
- Prepare a Report for Print
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!"
