Part time ECDL Advanced Databases IT332

ECDL - Advanced Databases IT332
QualificationBCS Database Software Level 3
Qualification Level
Level : 3
What do these levels mean?

Duration :12 weeks - 3 hours per session

Times :See below.

Run by : IT, Business and Professional Studies Department.
Tutor : John Reynolds

Awarding Body
British Computer Society (BCS)

Is it right for me?
Building on the knowledge gained at level 2, we begin to explore the Access program in more detail. This course is intended for people who use Access; perhaps are self'taught, and want to use the programme in greater depth. The weekly sessions are an ideal forum for sharing ideas.
This course could be studied as part of an ITQ Advanced ECDL Full Level 3 qualification.

What qualifications will I need?
Previous experience and/or exams at Level 2/3 are desirable before embarking on this course. Students are advised to talk to the tutor, John Reynolds, before enrolling to ascertain if this course is suitable for them.

What will I be learning about?

• Create Tables exploring the advanced features of data types & field properties.
• Create Select Queries with more advanced criteria.
• Create Action Queries to Update, Delete, Append records & Make Table Queries.
• Build summaries of data with Totals Queries & Crosstab Queries.
• Design Forms with multiple pages ' create Subforms ' Option Buttons.
• Create Advanced Reports with cumulative totals and percentages.
• Link Tables in a Relational Database ' change the linking.
• Create Queries from Multiple Linked Tables ' change the Join Properties.
• Edit SQL code to make changes to the working of the database.

A significant amount of homework is required.
Students will be expected to complete the test paper.

What is next?
Further IT courses

How much will it cost?
Total - £135

Money Matters