|
MS ACCESS 2007: EXPERT (INCLUDING PROFICIENT)
|
|||||||||||||||||||||||||||||||||||||
    | |||||||||||||||||||||||||||||||||||||
  |
|||||||||||||||||||||||||||||||||||||
WHAT IS MS ACCESS 2007?MS Access 2007 is designed for students who wish to learn the basic operations of the Microsoft Access database application to perform their day-to-day responsibilities, and to understand the advantages that using a relational database application can bring to their business processes. The Expert-level course is for the individual whose job responsibilities include working with related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance. It is also designed as one in a series of courses for students pursuing the Microsoft® Office Specialist Certification for Microsoft® Office Access™ 2007, and it is a prerequisite to take more advanced courses in Microsoft® Office Access™ 2007. COURSE STRUCTURE SUMMARYMS Access 2007: Expert (including Proficient) includes the following modules: All the modules from the Proficient Level
AND All the modules from the Expert Level
ASSESSMENT AND AWARDYou have to successfully complete and submit assignments in order to pass this course. Once you have successfully completed the assignments prescribed by College SA, you will be awarded a College SA Certificate of completion in MS Access 2007: Proficient. WHY SHOULD I STUDY MS ACCESS 2007?MS Access 2007 is highly recommended for anybody wishing to increase their computer literacy. Microsoft Access is often used for mailing lists, phone lists, and other around-the-office or home tasks for which a database would come in useful. Knowledge of MS Access 2007 will undoubtedly be to your advantage no matter if you are using Access for personal or for professional purposes IS MS ACCESS 2007? THE RIGHT COURSE FOR YOU?Do this quick and easy questionnaire to find out if MS Access 2007: Proficient is the right course for you. Answer either YES or NO. 1. Would you like to increase your knowledge of basic computer skills? 2. Does your current job require you to work with lists or databases? 3. Does your dream job require that you know how to work with lists or databases? 4. Has your boss or manager suggested to you that you learn more about MS Access? 5. Would you like to register for a course that will give you increased computer skills and knowledge in as little as three months? If you answered YES to more than two of these questions, then MS Access 2007: Proficient is the right course for you. We recommend that you register for this course right away! Call the College on 0800 21 23 22 to take the next step. If you did not answer YES to more than two of the questions, then perhaps you should consider one of our other courses or fill in the Form at the bottom of this page and we will contact you. Alternatively, call the College on 0800 21 23 22 to speak to one of our friendly Student Registrars and they can help you determine which is the right course for you. OTHER COURSES YOU MAY BE INTERESTED IN
Call the College on 0800 21 23 22 to find out how you can register for one of these courses. COURSE STRUCTURE: DETAILED OUTCOMESAll the modules from the Proficient LevelTactics for Winning This is the first Module that all students have to complete once they have registered with College SA. This Module is designed to introduce Students to the College. In this Module, you will learn more about how Distance Learning Works and what the best ways are to study to prepare for assessments.
Unit 1: Getting Started
Unit 2: Databases and Tables
Unit 3: Fields and Records
Unit 4: Data Entry Rules
Unit 5: Basic Queries
Unit 6: Using Forms
Unit 7: Working with Reports
AND All the modules from the Expert Level Unit 1: Relational Databases
Unit 2: Related Tables
Unit 3: Complex Queries
Unit 4: Advanced Queries
Unit 5: Querying with SQL
Unit 6: Advanced Form Design
Unit 7: Reports and Printing
Unit 8: Charts
Unit 9: Pivot Tables and Pivot charts
Unit 10: Importing, Exporting and Linking
Unit 11: Database Management
COMPUTER REQUIREMENTSYour personal computer should have:
You will use your personal computer for the following purposes:
IMPORTANT INFORMATIONFor the Expert level, once you have completed your College SA assignments, you have the choice of deciding to take an optional external Microsoft exam so that you can be awarded the internationally-recognised Microsoft Office Specialist Certificate (MOS) in the use of Microsoft Access 2007 as well as with the Windows Vista operating system. MOS meets the demand for the most up-to-date skills using the latest technologies from Microsoft. By earning your MOS credential, you will prove your expertise using the latest Microsoft Office programs. This certification can help you stand out in today’s competitive job market. You must pass one certification exam in order to earn your MOS credential.
To find out more about your MOS credential please go to: http://www.microsoft.com/learning/en/us/certification/mbc.aspx#tab2 INTERESTED? WANT TO FIND OUT MORE?If you would like to find out more about MS Access 2007: Proficient, fill in this short Form and then one of our friendly Student Registrars will respond to your questions and will provide you with all the information you need |
|||||||||||||||||||||||||||||||||||||
Back
