Back

MS ACCESS 2007: PROFICIENT
PDFPrintE-mail

 
Course Title:
MS Access 2007:Proficient
College:
College SA
School:
Computer Studies
Programme Type:
College SA Certificate Programme
Partner Institute:

Not Applicable

Award Type:
Certificate
Award Issued by:
College SA
SAQA NQF Level:
Not Applicable
Membership:
Not Applicable
Course Duration:
3 – 6 months
Entrance Criteria:
Access to a computer
Fees:
Click Here to request the Course Fee


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 Proficient-level course is for the individual whose job responsibilities include designing and creating new databases, tables, and relationships; creating and maintaining records; locating records; and producing reports based on the information in the database.

COURSE STRUCTURE SUMMARY


MS Access 2007: Proficient includes the following modules:

  • Tactics for Winning
  • 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

ASSESSMENT AND AWARD


You 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


  • MS Word 2007 Proficient
  • MS Word 2007 Proficient and Expert
  • MS Excel 2007 Proficient and Expert
  • MS PowerPoint 2007 Proficient
  • MS PowerPoint 2007 Proficient and Expert
  • MS Vista Proficient
  • MS Vista Proficient and Expert

Call the College on 0800 21 23 22 to find out how you can register for one of these courses.

COURSE STRUCTURE: DETAILED OUTCOMES


Tactics 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.

  • What is Distance Learning
  • Some important things you should know about learning
  • Parcel Tracking on the Internet
  • Student Card
  • Forms
  • Calendar
  • Progress Poster
  • Studying
  • Further Works
  • Some Advice
  • Study Tips and Methods
  • What should I do if I get behind in my work?
  • Account information
  • Assignments
  • Preparing for a Exam
  • Writing a Examination
  • Checklist for students
  • Tactics for Winning

Unit 1: Getting Started

  • Topic A: Database concepts
  • Topic B: Exploring the Access environment
  • Topic C: Getting help

Unit 2: Databases and Tables


  • Topic A: Planning and designing databases
  • Topic B: Exploring tables
  • Topic C: Creating tables
Unit 3: Fields and Records

  • Topic A: Changing the design of a table
  • Topic B: Finding and Editing records
  • Topic C: Organising records

Unit 4: Data Entry Rules

  • Topic A: Setting field properties
  • Topic B: Working with input masks
  • Topic C: Setting Validation rules
Unit 5: Basic Queries

  • Topic A: Creating and using queries
  • Topic B: Modifying query results and queries
  • Topic C: Performing operations in queries

Unit 6: Using  Forms


  • Topic A: Creating Forms
  • Topic B: Using Design view
  • Topic C: Sorting and Filtering records

Unit 7: Working with Reports


  • Topic A: Reports
  • Topic B: Modifying and printing reports

COMPUTER REQUIREMENTS

Your personal computer should have:

  • Windows Vista Operating System
  • Microsoft Office 2007 (Word, Excel, PowerPoint, Access and Outlook)
  • Windows Explorer (5 or later) or any compatible Web Browser
  • A keyboard and a mouse
  • A Pentium 233 MHz or higher processor
  • 128MB of RAM
  • 260 MB of free hard-disk space to install Windows
  • A CD-ROM drive or network connection to install (register) the software
  • A super-VGA monitor, resolution 1 024 X 768, 32 bit
  • An Internet connection so that you can e-mail your tutor.

You will use your personal computer for the following purposes:

  • To complete the ‘Do It!’ activities in your student manual
  • To communicate with your tutor via e-mail
  • To access supplementary material on the World Wide Web

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.



Call now


Frequently Asked Questions

Where are the Classes?
College SA is a home study college. This means that you do not have to go to class. You study at home, on the train, at work, after hours, on your lunch break, or over weekends! This means that you save a lot of costs that classroom students have to pay. Things like travel costs and accommodation are expensive for classroom students. Obviously it is also safer to study in your own home. It also means that you can work while you study, so you can earn a salary and get your qualification at the same time.
Do I get study material from the College?
College SA includes all your books, course items and study material with your course. So unlike other colleges, we shall not give you a list of books to buy. One you have paid for the course, you are entitled to recieve all the study material you need from us. In some cases there might be recommended reading materials which the college does not provide. But this will only be materials that are not essentials to passing your course.
What is the cost of the study material?
Your study material is included in your course fees, so the college does not charge you for study material.