Access 2016: database essentials

Course Dates: 14/09/20 - 12/10/20
Time: 18:00 - 21:00
Location: KS - Keeley Street

Learn the essential components of this information management tool to enable you to handle large amounts of complex data, including: setting up the database, creating data tables and forms, entering and editing data, using queries for data analyis, producing reports and establishing relationships between different parts of the database. You need basic computer literacy and competence to achieve on this course.

This course is FREE if one of the following applies:

a) You are employed and earn less than £20,962. You need to have lived in the UK or EU for the last 3 years and be a citizen of the UK or a country within the EU. You may also be eligible for this funding in other circumstances. When you come for assessment or enrolment, bring a pay slip dated within 3 months of the course start date, or a current employment contract that shows your gross salary. OR

b) You are either on Jobseekers' Allowance or Employment & Support Allowance. Please bring proof of income to your assessment or enrolment. OR

c) You receive other state benefits (including Universal Credit), earn less than £338 a month (individual claims) or £541 a month (household claims) and are doing the course to become employed or move into more sustainable employment.

Call 020 7831 7831 for more information.

This course takes place in the classroom, please follow this link to find out what we are doing to keep you safe: Staying COVID-19 secure at City Lit

Description

What is the course about?

This course will take you through the most essential components of the Microsoft Access 2016 database program. It will give you the foundational skills needed to create, edit and exploit your database for your personal use or for work. You will learn how to use Microsoft Access to analyze large amounts of information, and manage related data more efficiently than Microsoft Excel or other spreadsheet application.

What will we cover?

•identifying key terminology used within Access
• identifying the basic elements and objects of an Access database.
• identifying the factors you need to consider when planning a database.
• creating database objects (tables, forms, queries and reports).
• using queries to search and manipulate data.
• creating forms to capture data.
• developing reports to extract data.

What will I achieve?
By the end of this course you should be able to...

• confidently create and edit an Access database using the correct tools
• identify the concepts needed to successfully plan, design and implement a basic database for home and a workplace.
• identify the main objects of a database enabling you to be able to create a basic database that can be used in a small working environment.
• create tables for inputting generic data
• create different types of forms that will display the records in an attractive style
• interrogate your data by creating queries that will filter your required information.
• develop reports to summarise and extract data from your table.

What level is the course and do I need any particular skills?

This is a beginner's course in Access databases. You should be able to use the keyboard and mouse and understand the principles of file management. You should also be able to follow spoken and written instructions.

How will I be taught, and will there be any work outside the class?

Each student will have there own computer to work with and perform tasks in class, which reflect office and work-based activities and be encouraged to practise as much as possible. You will receive regular handouts You will have lots of opportunities to ask questions and address areas you need help in.
You will need your own computer to practice at home with MS Office version which include Access on it. Your tutor will discuss the concepts of all the tools used and will demonstrate their uses. The course will challenge you to become more independent in your learning and less dependent on your notes/hand –outs and work colleagues.

Are there any other costs? Is there anything I need to bring?

There are no additional costs for doing this course, but, you will need to bring a USB flash drive, your own pens, paper and folder to make your notes.
It is possible to sit a BCS Access Level 1 exam. If you wish to do so, you will need to pay for the BCS registration, the Test and a proportion of the cost of an invigilator. An online sample test is also available at a small cost if you want to check you are ready to take the exam . Please ask your tutor for more information if you are interested in taking the exam.

When I've finished, what course can I do next?

There are a number of courses you can do at the same time or after this course. These include:
• Word 2016 for the workplace (intermediate)
• Excel 2016 for the workplace (intermediate)
* An Introduction to PowerPoint 2016 Presentation in a Day
• Outlook 2016 for the workplace: managing your emails, tasks and priorities (intermediate)
*Essential Digital Skills for Work Level 1 (assessment needed)
• ECDL Level 1 or 2 qualification (assessment needed)
• IT Skills for the Office: an introduction or intermediate.


We have many other digital skills courses. Your tutor will advise you on the best course. You can also call our administrator on 0207 492 2511 or email: universal.skills@citylit.ac.uk to arrange an assessment with one of our course advisors.

Reviews

Book your place

Course Code: CDB01

Mon, eve, 14 Sep - 12 Oct '20

Duration: 5 sessions (over 5 weeks)

Full fee: £169.00
Senior fee: £135.00
Concession: £85.00

Or call to enrol: 020 7831 7831

Any questions? skills@citylit.ac.uk
or call 020 7492 2511

Please note: we offer a wide variety of financial support to make courses affordable. For more information visit our online Help Center. You can also visit the Information, Advice and Guidance drop-in service, open from 12 – 6.45, Monday to Friday.