Courses / Access Advanced
Access Advanced
- Provider
- Corazon Training
- Summary
- 1 day course covering all aspects of database entry and operation.
About the Course
- Target
- Those who have a reasonable understanding of Microsoft's database application, Access.
- Entry requirements
- A good knowledge of working in the Windows environment would be useful.
- Outcome
- Participants will improve their knowledge of Access
- Content
- Building a Relational Database � Normalisation of data � Primary and secondary keys � Field Types � Multiple field indexes � Naming Conventions � Data Validation � Table Level Validation � Relationships and Referential Integrity � Join Types � Using Lookups for Referential Integrity � Multi-Table Datasheet View Forms � Using Advanced Forms Features � Creating a Calculated Control � Multi Table Forms. � Using the Sub form Control � Adding a Graphic to a Form � Switchboard Forms � The toolbox; bound and unbound controls � Using Hyperlinks in Forms Queries � Filtering Query Results � Parameter Queries � Creating Summary Queries � Formatting Query Output � Relationships � Query Join Types � Planning an Action Query. � Make Table and Append Queries � Delete and Update Queries Reports � Applying Sorting and Grouping to Reports � Performing Calculations on Reports. � Adding a Graphic to a Report � Using the Sub report Control � Modifying Section Properties. � Concatenating data � Using Hyperlinks � Using the Chart Wizard Macros � Useful macros � Macro groups Course outlines are for guidance only as training is provided on a consultancy basis to ensure relevant work related topics are covered.
- Cost
- Training rates are available on request
- Enrolment
- .
Availability
- Starts
- All training is delivered on clients site and can be either one to one or in groups.
- Duration
- 1 day course
- Timetable
- By mutual agreement
- Provider
- Corazon Training
Venue and Contact details
Main
146 Woodbridge Road
IPSWICH
Suffolk
IP4 2NS
UNITED KINGDOM
Telephone 01473 219593 m: 07702911223
Fax 01473 219593
Email info@corazonit.com
Website http://www.corazonIT.com
Venue Notes At Client's site:
Contact Elene Marsden
Courses
Syndicate
