◊ ACCESS 2007 ONLINE TRAINING SERIES
Online Access 2007 Training
Database » Access
Only $99.95
Access 2007 Series (9 hours)
ONLINE Access 2007 TRAINING FEATURES
- Learn Access 2007 online with these interactive online Access 2007 courses.
- Affordable Pricing (Only $99.95 for the complete series)
- A full year to complete the Access 2007 courses
- Retake the Access 2007 courses as many times as you like
- Measure your progress with assessment tests after each course
- Earn completion certificates after passing each assessment test
1. Introduction to Access
Time: 1 hours
This course provides information on the Access 2007 interface, creating a database using templates, and the available database views.
Objectives
- Use the Ribbon to access command buttons and groups
- Use the Office menu to access commands dealing with the whole application or database
- Use the Navigation Pane to view and open database objects
- Start a new database by using templates provided by Microsoft Office Online
Topics
- The interface
- Creating a database
- Views
2. Creating Tables
Time: 2 hours
This course provides details about creating tables in Access 2007, as well as how to add and delete records and tables from a database. It also covers basic database terminology, data types, primary keys, flat files, and relational databases.
Objectives
- Recognize data types and basic database terminology
- Add and delete fields from a table
- Set the primary key for a table
- Identify flat files and relational databases
- Create simple tables
- Add, modify, and delete records from a table
Topics
- Database terminology
- Data types
- Adding and deleting fields
- Primary keys
- Flat files and relational databases
- Creating tables
- Adding, modifying, and deleting records
3. Working with Tables
Time: 2 hours
This course provides information on creating tables in Access 2007, including advanced features such as input masks, validation rules, and table relationships.
Objectives
- Apply basic formatting to a database table
- Create input masks for table fields
- Create validation rules for table fields
- View and modify the relationships between tables
Topics
- Formatting
- Input masks
- Validating data
- Table relationships
4. Creating Forms
Time: 2 hours
This course provides information on creating forms in Access 2007, including simple forms, more complex multiple items forms, and split forms. It also shows how to create customized forms using the Form Wizard.
Objectives
- Create simple forms using the Form button
- Create split and multiple items forms
- Use the Form Wizard to create customized forms
- Edit and customize a form using Form Design view
Topics
- Creating and Modifying Simple Forms
- Creating Complex Forms
- Using the Form Wizard
- Form Design
5. Creating Reports
Time: 1 hours
This course provides information on creating reports using Access 2007.
Objectives
- Create a basic report
- Create a report using the Report Wizard
- Create a customized report
Topics
- Creating Basic Reports
- Using the Report Wizard
- Report Design
6. Creating Queries and Filters
Time: 1 hours
This course provides information on how to use queries and filters to search and sort your database tables. It shows how to filter using the Sort and Filter feature and how to build queries using the Query Wizard.
Objectives
- Explain the difference between a query and a filter
- Apply sorts and filters to your tables
- Build a query using the Query Wizard
- Add query criteria to narrow the focus of your queries
Topics
- Defining queries and filters
- Sorting and filtering
- Simple queries
- Using query criteria
Resources for Access 2007
