HOME
 

Intermediate Microsoft Access

Eastleigh College
Course summary
1 hour
100 GBP
Eastleigh
Next available date: Contact for dates - Eastleigh
Open / Scheduled

Course description

Intermediate Microsoft Access:

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.

Course Syllabus: Creating relational databases; Database normalizing; 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; and Add a calculated value.

Assessment:

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

Career Opportunities:

On completion you will be prepared for the Access Advanced course.

Outcome / Qualification etc.

No Qualification

About provider

Eastleigh College

Eastleigh College Apprenticeships

Eastleigh College is a General FE College based in Eastleigh, Hampshire specialising in Apprenticeships for 10 years. We have recently launched 'The Apprenticeship Experts' team based at the College in response to our growing success in this area. We offer...


Read more and show all courses with this provider

Contact info

Eastleigh College

Eastleigh College, Chestnut Avenue, Eastleigh
SO50 5FS Hampshire


U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!

uk-ld-report-2019

Learn more

 
Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

 
Find more courses here