- Introduction
- Peter Jones Enterprise Academy
- A Levels
- AAT (Association of Accounting Technicians)
- Access Programmes
- Animal Care
- Apprenticeships
- Art & Design
- Beauty & Alternative Therapy
- Business
- CIM (The Chartered Institute of Marketing)
- CIPD (The Chartered Institute of Personnel and Development)
- Community Education
- Computing & IT
- Construction
- Counselling Skills
- Early Years and Childhood Studies
- Education and Teacher Training
- Engineering
- ESOL
- GCSEs
- Hairdressing & Barbering
- Health & Social Care
- Horticulture
- Hospitality & Catering
- ILM (The Institute of Leadership and Management)
- ISMM (The Institute of Sales and Marketing Management)
- Languages
- Management & Professional
- Media
- Mentoring
- Microsoft IT Academy
- Performing Arts
- Public Services
- Retail
- Science
- Social Sciences
- Specialised IT & Technical
- Sports & Leisure
- Sports academies
- Trade Union Studies
- Travel and Tourism
- Unemployed Free Courses
Access Intermediate Full Cost
Part Time
Course Details
Course Code
QBSNTZ03/BCP0
Course Level
N/A
Where will this course lead?
This course is ideal for you if you have mastered the basics of databases at work but need to move on to make more use of your databases.
What will I study?
Validating data entry, drop down lists
Setting up keys and relationships between data tables
Using sub data sheets
Creating a parameter query that finds data according to a value given by the user
Creating a totals query
Using calculations within queries, reports and forms
Importing & exporting data to spreadsheets, text files and Word documents
How will this course be delivered?
The course is very practical and hands on in a computer room. Each skill will be demonstrated on a Smart board to the whole class then each student can try it for themselves. Practice tasks are assigned throughout the day for each student to work at independently but with the teacher's assistance when required. Questions are encouraged. Discussion of each other's work experience and business practice is often useful to everyone.
What qualifications will I get?
Vocational study not leading to a recognised qualification, Information and Communication Technology (SSA 6)
How will I be assessed?
There is no assessment. However certificates of attendance are given.
How do I get a place on the course?
Training Needs Analysis forms are available for each student to complete. This will help you decide which level course is suitable for you.
What are the entry requirements?
There are no specific entry requirements.
What else do I need to know?
This course may also be delivered at another of the college sites or at your workplace.
Solihull College offers full time and part time courses for businesses and residents in Birmingham, Walsall, Wolverhampton, Coventry Warwickshire and the whole of the West Midlands.
What can I do after this course?
this course can lead on to other one day courses
Is there anything else I will have to pay for in order to do this course?
A Microsoft Study book is included in the cost of the course.
Contact
Blossomfield Campus
Solihull College
Blossomfield Road
Solihull
B91 1SB
Tel: 0121 678 7000
Minicom: 0121 628 7005
Email: enquiries@solihull.ac.uk
Internet: www.solihull.ac.uk
Have you got a question about this course?
Please contact Admissions on 0121 678 7000 with any queries.
Course Details
| Location | Start Date | Day | Time | Fees | Duration |
|---|---|---|---|---|---|
| Blossomfield Campus | Various | Various | Various | Course Fee: £165.00 | 1 Year |


