Microsoft Access Intermediate
Sponsored links
This course is intended for users who have attended the Introductory Access course and/or who are able to design their own database, produce simple queries and reports. It will enhance their existing knowledge and give them an understanding of the major features and functions within Access.
Course content is listed below, but can be customised to suit your requirements.
Delivered on site at your workplace. Public courses not available at this time.
http://prologtraining.co.uk/access_intermediate.html
| Delivery: |
|
| Category: |
Further Details
• Advantages of forms in access
• Creating an autoform
• Using the form wizard
• Design a form
• Bound and unbound controls
• Text boxes and labels
• Toggle buttons and boxes
• Field list and subforms
• Important steps to designing reports
• Creating reports and report properties
• Sorting and grouping
• Calculations on reports
• Using the chart wizard
• Using the label wizard
• Concepts of a relational database
• Normalisation – splitting tables
• Primary and secondary keys
• Types of relationship
• Creating the relationship
• Referential integrity – data accuracy
• Validation rules and input masks
• Lookup fields
• Creating a combo box
This Training Course is offered "in house" at the following locations:
Leicester
Harlow
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Contents © 1999 - 2012. All rights reserved.
