Microsoft Access 2007

Price: $ 595.00 (USD)

Have a question about this course? .

Course Description

The Microsoft Access 2007 program is a comprehensive, performance-based certification preparation program designed to validate business computer skills using Microsoft Access 2007 software. This interactive online program will prepare you to take Microsoft Certification Exam 77-605. Students will not only gain basic knowledge of the software, but also how to link information, automate data entry, and create a Search Form that uses a Combo Box to filter the records. The Microsoft Access 2007 course has continuous assessment for goal-based learning. The course contains three modules with multiple lessons in each. A student needs to achieve 70% of all possible points to be able to continue on to the following module. This course also includes a final project which must be completed and submitted to the instructor. Students will need to have Microsoft Access 2007 installed on their computer prior to taking this course.

Course Objectives

By completing the Microsoft Access 2007 course, students will:
• Know how to use and design tables, forms, and queries.
• Create Queries to find and select records by criteria, and write, test, and update those queries.
• Understand how to create forms with subforms to represent one-to-many relationships.
• Learn to use criteria, parameters, concatenation, and operators in Query designs: calculate with DateDif(),Left(), and IIF(), improve report designs with Sorting and Grouping.
• Know how to link information and automate data entry.
• Create a Search Form that uses a Combo Box to filter the records.
• Know how to use Microsoft Access and Word together in a Mail Merge, as well as publish an Access report to Word, and optimize a database for multiple users.

Course Outline

I. Beginning Guide to Microsoft Access 2007
a. Microsoft Access Database Tables
b. Microsoft Access Database Forms
c. Microsoft Access Database Queries
d. Database Maintenance
e. Microsoft Access Database Reports
f. Databases Come and Databases Go

II. Intermediate Guide to Microsoft Access 2007
a. Better Form Design
b. Form Controls and Switchboards
c. Modifying Form Properties
d. Software Testing
e. Sophisticated Queries
f. The Quest

III. Advanced Guide to Microsoft Access 2007
a. Create a Search Form
b. Synchronized Forms and Controls
c. Office Automation
d. Linked Tables
e. Links to the Internet
f. What a Long, Strange Trip It's Been

More Information

Language	English
Course Length	35.00 hours
Duration of Access	3 months
Instructor	Elizabeth Ann Nofs; Clair E. Dickson, Student Services
Vendor	Gatlin Education
Prerequisites/Audience	A basic understanding of computer skills, Internet connection, and emailing capabilities are required. This course is intended for students who want to learn how to effectively use Microsoft Access 2007.
Requirements/Materials Included	This course cannot be taken on a Mac computer. Technical requirements include but are not limited to having internet access with a 56K modem, but it is highly recommended that you have DSL or High Speed Cable Internet Access; 64 MB system RAM; 200 MB free hard disk space memory or sufficient storage; reliable email account access, CD-ROM/DVD capabilities, and a reliable Internet provider. You will need the following products already be loaded on the computer in order to take this course: Windows Vista Business edition or Windows XP, Microsoft Access 2007, Microsoft Word 2007, Adobe Acrobat Reader (free version), and Flash Player. GES will provide the following materials: • Beginning Guide to Microsoft® Access 2007 • Intermediate Guide to Microsoft® Access 2007 • Advanced Guide to Microsoft® Access 2007

Price: $ 595.00 (USD)

Add to Cart

The eLearning Center for Gatlin Education Services