Access Intermediate

Sep 11, 2017 09:00am -
Sep 11, 2017 04:30pm
(GMT-6)

 

Event Description

This ILT Series course provides students with additional skills and concepts needed to use Microsoft Access productively and efficiently. They will learn to normalize data, join tables while observing referential integrity, query multiple tables, format forms and reports, insert background images and charts; and create specialized objects such as lookup fields, subforms and subreports, navigation forms, and calculated fields.

This course will help students prepare for the Microsoft Office Specialist exam for Access (exam 77-424). For comprehensive certification training, students should complete the Basic, Intermediate, and Advanced courses for Access .

Course Outline

Unit 1: Relational databases
Topic A: Database normalization
Topic B: Table relationships
Topic C: Referential integrity

Unit 2: Related tables
Topic A: Creating lookup fields
Topic B: Modifying lookup fields
Topic C: Subdatasheets

Unit 3: Complex queries
Topic A: Joining tables in queries
Topic B: Using calculated fields
Topic C: Summarizing and grouping values

Unit 4: Advanced form design
Topic A: Adding unbound controls
Topic B: Graphics
Topic C: Adding calculated values
Topic D: Adding combo boxes
Topic E: Advanced form types

Unit 5: Reports and printing
Topic A: Report formatting
Topic B: Calculated values and subreports
Topic C: Printing
Topic D: Label printing

Unit 6: Charts
Topic A: Charts in forms
Topic B: Charts in reports

Prerequisites: There are no prerequisites for this course.

Advanced Preparation: There is no advanced preparation for this course.

Competencies: Computer Science

Delivery Method: Group-Live

Program Level: Intermediate

CPE Credits: 7

Fields of Study: Computer Science

 

Duration: Full-day – 9:00 am - 4:30 pm

Member Cost:  $175; NonMember Cost: $189

Computer Training Cancellation/Reschedule Policy: If cancellation/reschedule is received 15 or more business days prior to the start of the class, there will be no penalty. If cancellation/reschedule is received 10-14 business days prior to the start of the class, there will be 50% penalty billed. Anything less than 10 business days the full fee for the class will be billed.

For more information regarding refund, complaint and/or program cancelation policies, please contact AAIM’s Research and Solutions Team at 314-968-3600.​


Event Type:Computer Training
Category:Computer Training
Early registration ends on Jun 11, 2017.
Regular registration starts on Jun 12, 2017 and ends on Sep 10, 2017.
Late registration starts on Sep 11, 2017.
(GMT-06:00) Central Time (US & Canada)

Register for this event  

Registration Fees
Fee TypeEarlyRegularLate
 Computer Training
Member Fee: $175.00$175.00$175.00
Non-Member Fee: $189.00$189.00$189.00