What opportunities will this course give me?
You will be prepared for the Access Advanced course.
What will I be learning?
Course Syllabus:
• Creating relational databases
• Database normalising
• Introducing relating tables
• Adding referential integrity
• Working with related tables
• The lookup wizard
• Changing lookup fields
• Inputting data to related tables
• Defining data entry rules
• Using input masks
• Setting a property
• Setting a validation rule
• Using advanced query features
• How to join a table in queries
• Creating a calculated field
• Using an action query
• Creating advanced queries
• Summarise and group values
• Create a crosstab query
• Using a parameter query
• Creating advanced form design
• Working with graphics
• Working with calculations
• Working with combo boxes
• Working with unbound controls
• Using advanced report features
• Create customised headers and footers
• Add a calculated value
• Work with sub-reports All one-day IT courses are bespoke and not qualification-based. Training formats available:
• 1 day instructor-led at the College
• On-site at your company office UK wide
• Bespoke one-to-one basis
• Tailored training courses to your requirements This course is designed for those users who wish to increase their current knowledge of Access to take advantage of the more complex features. On completion delegates will understand relational databases and be able to work with related tables. They will learn how to generate more complicated queries and create more advanced forms and reports.
Why is this course for me?
Training formats available
• 1 day instructor-led at the College
• On-site at your company office UK wide
• Bespoke one-to-one basis
• Tailored training courses to your requirements
What do I need to sign up?
No formal entry requirements
Is there anything else I need to know?
Our Intermediate Microsoft Access course is suitable for those with a basic working knowledge of Microsoft Access, or those who have completed the Access Introduction course.
Pen and paper.
Application Information
Please note that all courses are subject to minimum numbers and course descriptions may be subject to change. A place on your chosen course is not confirmed until all of the necessary enrolment paperwork is signed and any relevant fees are paid. The team will be in touch to discuss this with you, once your application has been processed.
Course Code
CLBUX0/ACC2
Course Options
Click an option below to see more details and to apply.
- Apply Now
Venue
Eastleigh College
Session code
ACC2A
Day
Time
09:30 – 16:30
Weeks
1
Fees
£106.00
24+: £106.00
Session | Venue | Starts | Days | Time | Weeks | Fees* | 24+ Fees* | |
---|---|---|---|---|---|---|---|---|
ACC2A | Eastleigh College | 09:30 – 16:30 | 1 | £106.00 | £106.00 | Apply now |
Need some further advice?
If you require further advice and guidance about any course costs and/or the funding options available to you, the College has a dedicated Information, Advice and Guidance team who can be contacted on telephone 023 8091 1299.
Latest News
Pay your course fee in manageable monthly instalments with FlexEd
The College is delighted to offer you the chance to spread your fees into monthly instalments over the length of your chosen course if you are unable to pay for the full amount of your course in advance of its start date.
Hampshire Chief Executive paves the way for Women in Business
In a sector which is disproportionately led by males, Chief Executive and Principal of Eastleigh College, Dr Jan Edrich, recently chaired the Women’s Leadership Network (WLN) Annual Conference, speaking of her own journey to senior leadership, and to inspire the leaders of tomorrow.