|
|
|||
|
|
|||
|
|
|
||
|
|
MS-Access 2007 Level 2 COURSE INTRODUCTION:- The Access 2007 – Level 2 course teaches students advanced-level concepts and features of the Microsoft Access 2007 application. In this course, students work with advanced and complex queries, forms, and reports. Students learn to create PivotCharts and PivotTables, import and export data, use macros, and maintain, optimize, and document a database. |
||
|
Students will accomplish the learning objectives for each lesson through a series of hands-on tasks, for which they will be given step-by-step instructions and desired result checkpoints. The tasks will provide ample opportunity for students to practice, apply, and develop the 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, review, and reinforcement of the topics learned throughout the course, and to help prepare students for the Final Exam. OF INTEREST TO:- Those who are already familiar with Microsoft Access 2007, and who want to learn more advanced techniques for creating, using, and managing relational databases. COURSE AIM:- To provide an understanding of Microsoft Access 2007 that goes beyond the basics, in order to create and manage databases. COURSE CONTENT:- Lesson 1: Understanding Database Relationships; Defining a Database Relationship; Modifying Table Design Lesson 2: Selecting Data from a Single Table; Selecting Data from Multiple Tables; Creating Parameter and Action Queries; Summarizing and Grouping Data; Optimizing a Query Lesson 3: Creating Advanced Forms; Using Advanced Controls; Creating and Modifying a Subform; Creating and Modifying a Switchboard Form Lesson 4: Creating a Complex Report; Working with Subreports and Charting Data; Creating PivotTables and PivotCharts Lesson 5: Importing and Exporting Data; Data Collection; Introducing Microsoft SharePoint Services; Sharing Files on the Web Using Microsoft SharePoint Lesson 6: Creating and Using a Macro; Maintaining a Database; Optimizing and Documenting a Database Lab Exercise COURSE NOTES:- A 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 and the Introduction to Microsoft Access 2002 – Level 1 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. |
|||
