Microsoft Access 2007/2010 Level 1
Class timetable | Course outline
Course DescriptionIn this Access Training course, you will learn to design and create new databases, tables, and relationships; create and maintain records; locate records; and produce reports based on the information in the database.
Target Audience
This Access Training class is designed for students who need to learn the basic operations of the Microsoft Access database application. No prior experience of Access is required.
For added peace of mind, Training Connection’s Microsoft Access training comes with a 100% Money Back Guarantee.
If by lunchtime you don't feel that the program is for you, then you can leave the course at this point and receive a full refund of your course fees.
Access Level 1 Class Timetable
| Chicago | Feb 27 ! | Register |
| Los Angeles | Mar 5 ! | Register |
| Chicago | Mar 28 | Register |
| Los Angeles | Apr 18 | Register |
| Chicago | Apr 30 | Register |
| Chicago | May 30 | Register |
| Los Angeles | Jun 4 | Register |
| Chicago | Jul 2 | Register |
* Class almost full ! Class guaranteed to run † Class is full
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 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.
Exploring the Microsoft Access 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
What's included
Microsoft Access Training Manual
Certificate of Course Completion
6 Months FREE Repeat Policy
2 AMC Movie Vouchers
Related Courses
