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 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.
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:
- 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 |
Mar, 2010 | Apr, 2010 | May, 2010 | Jun, 2010 |
| Access 2007 - Level 1 | Mar 9 * | Apr 19 ! | May 17 | Jun 14 |
Los Angeles |
Mar, 2010 | Apr, 2010 | May, 2010 | Jun, 2010 |
| Access 2007 - Level 1 | Mar 29 | Apr 26 | Jun 1 Jun 28 |
* Class almost full ! Class guaranteed to run † Class is full
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!"
