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.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 requirementsYou will be prepared ...more on College website
Name: Intermediate Microsoft Access Qualification title: - Qualification type: No qualification Assessment Awarding - Created 20161010 19:36:12 Updated 20161010 19:36:12
Pen and paper. Equipment required Pen and paper.
Eastleigh College
Further Education
experts@eastleigh.ac.uk
023 8091 1000
https://www.eastleigh.ac.uk/
Chestnut Avenue Town: Eastleigh County:Hampshire