18 and older
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 comprehensive certification training, students should complete the Level 1, 2 and 3 courses for Access.Access Versions That Can Attend:
Access 2019, 365, 2016, & 2013 (Microsoft Windows PC)Course Taught With:
Access version 2013 (Microsoft Windows PC) Software and CoursewareNot Appropriate For:
Macintosh versions of AccessPrerequisite:
Access: Level 1Course 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
Headsets for free, Guaranteed to Run, Re-Takes for free (Up to 6 months), Interactive Classroom environment.Registration Note:
- Topic A: Charts in forms
- Topic B: Charts in reports
We can only accept students into our classes whose tuition is being paid by an employer or sponsoring organization. Self-paying individuals cannot enroll.
Courseware (if a course has a Courseware) will be shipped to the address provided two weeks before the class starts. Make sure that the additional info field is properly and correctly filled out to avoid Courseware being lost in transit. Please also note that P.O. Box addresses are not allowed.
The classes are instructor-led live training you attend in a local classroom or from your home/office. Our instructors teach from a remote location while being able to interact with students as in a traditional classroom setting.
Instructors can view student progress and take control of their PC to provide direct assistance. Students can see the instructor's presentation as well as voice questions directly to the instructor and participate in class discussions.