Microsoft Access

Microsoft Access is one of the biggest programs in the Microsoft Office suite.  It can be used simply to keep records of clients/customers, or it can be used as a powerful tool to help run a business very effectively providing a range of information to help take decision making forwards.

Data entry can be made in a simple table format, or created using a screen based form style - all designed to suit individual businesses.  

Database reports can be generated to provide key information, or selected information to meet different requirements to help run a business, or provide key information to clients and customers.

Relational databases learnt at Level 3 will show you how different databases can be linked together to provide the backbone support program for a business, enabling information to be linked for different departments to carry out their workload quickly and efficiently.

There are 3 Levels to choose from.  For Level 2 and 3 you will need prior knowledge.  Level 1 is for complete beginners.

Touch typing can be included in any of these courses to help develop your touch typing and speed typing skills. This is a free option for all of our Secretarial Courses.

You will gain either the:

OCR Level 1 in Databases

OCR Level 2 in Databases

OCR Level 3 in Databases

OCR (RSA) is an established exam board providing a range of GCSE, A Level, teaching and vocational qualifications.  

OCR is part of the University of Cambridge which is Europe’s largest assessment board.  They play a leading role in developing and delivering exams/assessments across the world, operating in over 150 countries.

or

LEWIS COLLEGE Certificate in Access at Level 1, 2 or 3

Level 1

At this level you will learn the basics with regards to databases including creating a database, entering data to create records, use simple editing options, create database queries to select certain records.

Level 2

At this level you will develop your knowledge and understanding further to include primary keys, different field characteristics, data validation, use of indexes and key field to organise data, identifying problems with databases, creating, and modifying databases, analyse problems with data.  You will also learn how to create forms to enter data, edit and correct data as well as run database queries using a wider range of options and complexity, create a variety of different types of reports for printing.

Level 3

At this level you will work with relational databases, developing more complex database designs, running more advanced queries, how different relationships are established in a multiple-table database, using logical operators.  You will also design and create forms, check data entry and errors and create complex reports for printing.

You can study this course full-time, or part-time – studying the number of hours per week that suits you and fits in with your other commitments.

We recommend that you study at least 5 hours a week, which can be broken up into one hour study slots perhaps, or 2-3 hours on a Saturday and Sunday if you find that easier.

Some students wish to study as quickly as possible – and complete the course in as short a time as possible.

The choice is yours!

For your guidance, if you study regularly these hours per week, you should complete the course within:

 The maximum duration within which a single Level course needs to be completed is 2 months.

The course is put on hold whilst you or the College are on holiday - enabling you to have holiday breaks whilst studying your course.