Courses / Advanced Microsoft Access
Advanced Microsoft Access
- Provider
- P-tek Development Solutions Limited
- Summary
- This one day course focuses on building on and developing delegates’ existing skills and equipping them with a good understanding of the advanced functions of Microsoft Access. The course can be delivered either on a 1:1 or group basis.
About the Course
- Target
- This course is aimed at people who are already competent users of Microsoft Access and wish to develop these skills to an advanced level.
- Entry requirements
- Outcome
- By the end of this course, delegates will be able to;
- Have an advanced understanding of the functions of Microsoft Access
- Implement full use of Access into their working role
- Have an advanced understanding of the functions of Microsoft Access
- Content
- The course can be tailored to meet your specific requirements and deal with any issues you may wish to address. To give you an idea of the course content, we could cover the following areas for you...
- Building a Relational Database
- Normalisation of data
- Primary & 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 & 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 & Append Queries
- Delete & update Queries- Reports
- Applying Sorting & 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 Chat Wizard- Macros
- Useful Macros
- Macro Groups
Each delegate will receive individual feedback and assistance and may be asked to complete a personal action plan / checklist identifying key skills to practice. - Building a Relational Database
- Cost
- Please contact the provider for details
- Enrolment
- Please contact the provider
Availability
- Starts
- Please contact the provider for details
- Duration
- 1 day
- Timetable
- Please contact the provider for details
- Provider
- P-tek Development Solutions Limited
Venues/Contact
Main (View map)
16 Kitchener Way
Shotley Gate
Ipswich
Suffolk
IP9 1RW
UNITED KINGDOM
Telephone 08448 011733
Fax 0709 202 9439
Email bookings@ptekdevelopment.com
Website http://www.ptekdevelopment.com
Venue Notes 0
Contact Notes Telephone: 08448 011 733 Fax: 07092 029 439
Courses
Syndicate
