|
Your Satisfaction
is Guaranteed! If
you are not completely satisfied after your first
week (7 days) of training, we will refund your money
- No questions asked!
-------------------------------------
|
All of our computer training courses
are approved for CEU's (Continuing Education Units Credit)
through Otterbein College.
--------------------------------
|
|
Expert
Mentoring -
Live Chat 24 hours a day, 7 days a week |
|
Instant Mentoring provides 24/7 support while you are
enrolled in our online courses.
Our experts can clarify concepts, fine-tune solutions,
confirm a process, or simply provide assurance that
you are on the right track.
Instant Mentoring helps to ensure understanding and
synthesis of any of our online courses.
--------------------------------
|
 |
Certificate of
Completion |
When you have scored 80% or better
on the actual course, you will have the opportunity
to print out a certificate of completion.
If you would like to become a Microsoft Office Specialist
(MOS), our courses will help you prepare for the MOS
exams.
--------------------------------
|
 |
Smart-Tips
Weekly
e-Newsletter |
When you enroll,
you will also receive our weekly "Smart Tips"
E-Newsletter, which is designed
to update your skills even faster!
It's jam-packed with quick tips, short-cuts,
and timesaving guide-lines so you'll become more efficient
and more productive faster than you would have imagined!
--------------------------------
|
|
"I am trying the on-line
training program, and my impressions so far is that
it is well designed and thought out."
- Steve V.
|
| |
|
 |
|
 |
Microsoft Access 2007
|
| Home
> Online Courses >
Business
Skills Package >
Microsoft Access 2007 |
|
|
Estimated time to Complete:
9 hours
Continuing Education Units:
Yes
Self Assessment Tests:
Yes
24 / 7 Mentoring Service:
Optional
Training Method:
Online, Self-Paced
Subscription Term:
3/6 Months
This course is included
in the Business Office Skills Package
Cost: $99 for 3 Months Access or $149 for 6 Months Access
Summary:
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. Students
will also be able to use queries and filters to sort
through data.
Audience:
This series is for anyone who wants to get the most
out of using Access 2007.
Features:
- Exercises that allow users to practice the application
- Files containing the text of the exercises
- Simulations that allow users to practice course
skills, even if they don't have access to the application
- Glossary
- Skill Assessment Tests
Course Outline and Objectives: |
|
 |
| 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 |
|
| •
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
|
|
| •
Build relationships between tables |
|
| •
View and modify the relationships
between tables |
|
| •
Using Advanced Features |
|
|
|
|
|
|
| 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 report using the Report Wizard
|
|
| •
Create a customized report |
|
| •
Change fonts on the datasheet |
|
| •
Add and remove table fields |
|
•
Change field names
|
|
|
|
|
|
|
| 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
|
|
|
|
|
|
|
| Searches
and Queries |
|
| •
Sort and filter records in a database
|
|
| •
Build a simple query |
|
| •
Set up multiple-table queries |
|
| •
Build a multiple-table query by hand |
|
|
|
|
|
|
|
|
|
|
 |
|
| And, with all our online courses, your Satisfaction
is Guaranteed! If you are not completely satisfied after
your first week (7 days) of training, we will refund your
money - No questions asked! |
|
|
|
