Microsoft Access Level 1
The Microsoft Access Level 1 course teaches students the fundamentals of the Microsoft Access application. In this course, students examine database objects and learn to manage data in a database. They learn to sort and filter data, display and format data, and use simple queries to retrieve data. Students learn to create and modify databases and tables, and work with simple forms and reports.
Students accomplish the learning objectives for each lesson through a series of hands-on tasks, for which they are given step-by-step instructions and desired result checkpoints. The tasks provide ample opportunity for students to practice, apply, and develop the Microsoft Access skills covered in the lesson.
A practice exercise and review questions are included at the end of each lesson to measure progress and reinforce the skills learned. There is also a lab exercise at the end of the course to provide further practice and review, to reinforce the topics learned throughout the course, and to help prepare students for the final exam.
Introduction to Windows course, or equivalent.
METHOD OF DELIVERY
Integrated Learning™ System training facilitated by Academy of Learning Career College facilitators.
Course manual provided for on-going reference. There is a final exam upon completion of the course. Participants who receive 75% or higher on their exam will receive a certificate.
Introduction to Microsoft Access; Exploring the Access Application Window; Opening and Closing a Database; Getting Help While you Work
Examining Database Objects; Managing Data; Editing Data in Datasheet View
Creating a Database; Creating a Table; Setting Field Properties; Modifying Tables and Fields
Sorting and Filtering Data; Displaying and Formatting Data; Using Queries to Retrieve
Understanding and Creating Forms; Modifying and Customizing Forms; Formatting and Modifying Form Properties
Understanding and Creating Reports; Modifying and Customizing a Report; Formatting Reports and Modifying Report Properties; Printing a Report