|
|
|||
|
|
|||
|
|
|
||
|
|
MS-Access 2007 Level 1 COURSE INTRODUCTION:- The Access 2007 – Level 1 course teaches students the fundamentals of the Microsoft Access 2007 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. OF INTEREST TO:- Those who are interested in working with databases. COURSE AIM:- To teach the essentials of database creation and management, and the use of the Access 2007 program COURSE CONTENT:- Lesson 1: Introduction to Microsoft Access 2007; Exploring the Access Application Window; Opening and Closing a Database; Getting Help While you Work Lesson 2: Examining Database Objects; Managing Data; Editing Data in Datasheet View Lesson 3: Creating a Database; Creating a Table; Setting Field Properties; Modifying Tables and Fields Lesson 4: Sorting and Filtering Data; Displaying and Formatting Data; Using Queries to Retrieve Lesson 5: Understanding and Creating Forms; Modifying and Customizing Forms; Formatting and Modifying Form Properties Lesson 6: Understanding and Creating Reports; Modifying and Customizing a Report; Formatting Reports and Modifying Report Properties; Printing a Report Lab Exercise COURSE NOTES:- Course manual is provided as an ongoing reference. Upon successful completion of this course, there is a final exam that is sent to the Academy Head Office for marking. Participants who successfully complete the course and achieve a 75% or higher mark will receive a certificate. Students will also be able to complete NZQA Unit Standard 2787 COURSE PREREQUISITES: It is advised that students first complete the Introduction to Windows course Courses Start every Monday We are open weekdays, one evening and Saturday mornings. Flexi-Time Self-Paced, Pick-'n-Mix Training. Our Exclusive System allows you to learn at your own pace within your own flexible, time commitments. There is no need to keep pace with other students Set your own schedule; You can create a schedule that lets you accommodate your job, your family and other time commitments. Financial arrangements available or use our Time Payment Plan. (WINZ Funding may be available - conditions apply). |
|||
