|
|
Access 2007
Join over 1 million people who learn
online, with these complete interactive computer training
courses.
Receive your login ID to take the training courses online,
as many times as you wish, for 1 year.
Click
here for group orders.
| Buy this entire
online training course with one easy payment of $37 |
|
OR
|
Benefits |
- Unlimited access for
1 year
- Learn anytime,
anywhere
- You control the pace
- Start & stop
wherever you want
- No books to read
- No software needed
- Value Packs include
Free online tech support
- Double
guarantee
|
- 100% Money back
guarantee
- One time payment No
monthly fee
- Use the course index
for review anytime
- Answer course
questions with at least 70% accuracy and print
your own certificates of
completion to prove that you have mastered each training course.
- Free status reports
for company managers
|
|
|
Requirements |
All you need is a PC with Windows,
the Microsoft Internet Explorer (browser)
and an Internet connection.
Note: The online computer training is designed to
work only with Internet Explorer. Prices shown are per
user. |
|
What
You will Learn |
| This series covers how to use Access 2007 to
create, modify, and access databases. It shows the learner how to
use the Ribbon-based Access 2007 interface, as well as how to
build tables, forms, and reports. Learners will also be able to
use queries and filters to sort through data. |
|
Introduction to Access |
- 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
|
|
|
Creating Tables |
- 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
|
|
|
Working with Tables |
- 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
|
|
|
Creating Forms |
- 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
|
|
|
Creating Reports |
- Create a basic report
- Create a customized report
|
- Create a report using the Report Wizard
|
|
|
Queries and Filters |
- 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
|
|
|