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 .
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.