THIS IS
A CAREERS COLLEGE

COURSE ENQUIRIES 0800 622006

WHO IS THIS COURSE FOR?

This course is for students who want to develop a knowledge and understanding of databases using Microsoft Access 2010. The course covers designing, creating, modifying, and querying database tables. It also includes designing and using forms and reports to enter and display information in a professional format. Students will improve their skills in using databases within their employment or learn from scratch how to manipulate them.

PT

Location: Central Campus

Start Date:

FORMAL ENTRY REQUIREMENTS

The course costs £100 for each of the three units, or £250 for students who enrol on all three units before commencing the first.

WHAT DOES THE COURSE INVOLVE?

The whole course will run on a Thursday Evening, from 6pm – 8pm, over 15 weeks

Introduction to Databases, 5 weeks
Students will be able to:
• Understand the principles of database design
• Create a flat file database to meet identified needs
• Create structured tables
• Respond to data entry messages
• Create data entry forms
• Plan and produce reports
• Check accuracy of a database.
Intermediate Databases (part 1), 5 weeks
Students will be able to:
• Create simple queries using selection criteria
• Understand logical operators
• Locate information in a database table
• Create complex queries using selection criteria
• Create navigational forms
• Plan and produce reports.

Intermediate Databases (part 2), 5 weeks
Students will be able to:
• Design a relational database to meet the needs of an organisation
• Construct a database according to a design
• Create an Entity relational diagram
• Interrogate a database using queries
• Plan and produce reports
• Test a database and make recommendations for improvement.

Success Rates on courses for 16-18 year-olds nearly 7% better than national average*