Training Center
Computer Training courses online, at your pace !

Computer Training Online


Or call 800 639 0160








Access 2007
 Join over 1 million people who learn online, with these complete interactive computer training courses.




See How It Works
This online course includes: Time Needed
Introduction to Access 1 hour   
Creating Tables 2 hours
Working with Tables 2 hours
Creating Forms 2 hours
Creating Reports 1 hour   
Queries and Filters 1 hour   
Estimated time needed to complete entire course 9 hours


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

Buy the Office Value pack, and receive this course plus many more, for only $97
Bonus: Order a value pack NOW, and receive Free unlimited "Instant Mentoring", real time help, so you can chat online,
            with a support person, as needed (24 hours a day, 7 days a week).  You can ask your mentor to clarify
            concepts, fine tune solutions, confirm a process or simply seek assurance that you understand a topic.



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



 

 

Copyright © 2007 TrainingCenter.com