Course List >> Microsoft® Access® Level 2

MICROSOFT® ACCESS ® LEVEL 2

Description:
In this course, you will cover how to normalize the data; create relationships between tables; control data entry; create an input mask; create a lookup field; learn how to find and join data; create query joins; enhance the appearance of a form; restrict data entry into forms; add command buttons onto a form; organize your report; set report control properties; control report pagination; summarize information; add a sub report; create mailing labels; publish Access data as a Word document; analyze Access data into Excel; & merge Access data with a Word document.

Upon successful completion of this course, students will be able to:

• follow the steps required to properly design a simple database.
• create a new database with related tables.
• control data entry by modifying the design of a table to streamline data entry and maintain data integrity.
• find and retrieve desired data by using filters and joins between tables and within a single table.
• create flexible queries to display specified records; allow for user-determined query criteria; and add, update, and delete data with queries.
• enhance the appearance, data entry, and data access capabilities of your forms.
• customize reports to better organize the displayed information and produce specific print layouts such as mailing labels.
• use Access data in other applications, including Microsoft Word and Excel.
• (topics listed are for Access 2003; may vary slightly for Access 2007)

Prerequisite: Access® Level 1 or equivalent knowledge

Training Type: Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities. Max # of students = 6.
**Available for Private or Group Sessions**

Cost: $159

Course Includes:

• Professional Textbook
• Take-home CD or downloadable materials with practice examples
• 1 month of email/phone support
• 1 year for a free re-take of the same course

Class Info: 1 day course | Time: 9:30am-approx 3pm (class times may vary). Several breaks are taken throughout the day. | Class size limited

How to register: Email / Call us to inquire about class availability