Microsoft Access Training User

Duration: 2 days
Objectives:

This course is designed for either the database Administrator or the person who has a familiarity with Microsoft Access and now wishes to move to the next level. The person attending would have a working knowledge of Access in general. All topics will be demonstrated using working examples. A large part of the course is devoted to”hands-on” experience of the package and the student is led through a series of exercises.
Course Topics:
Topics: Planning a Multi Table Application
Database Design / Analysing an Existing System
Importing Data from other applications – Data Cleansing / Verification
The Principles of Linking Databases
Review of Basics
Advanced Queries
Multiple Parameter Queries
Update / Append / Delete / Make Table / Calculating Queries – Running with Macros
Find Duplicate / Find Unmatched / Crosstab Queries
Forms with Sub Forms Form Views / Calculating Fields / Linked calculation fields
SUM COUNT AVERAGE IIF Multiple IIF etc
Field & Form Locking
Finding records by Selecting Values / Pop Up forms / Display Specific Data
Using Active X ControlsReports
Reports with Sub Reports etc
Working with Macros
Creating / Actions & Arguments / Macro Commands
Autoexec Macros / Macro Buttons / Running from Menus and Toolbars
Reports
Reports with Sub Reports etc
Working with Macros
Creating / Actions & Arguments / Macro Commands
Autoexec Macros / Macro Buttons / Running from Menus and Toolbars
Building a Switchboard
Designing a Multi Level Switchboard system
Macro Buttons / Command Controls
Changing and Editing the Start Up Options
Menus & Toolbars
Creating a Custom Toolbar / Macro Menus / Customised Macro Buttons
Using Hyperlinks in Menus
Security Issues
Planning the Requirement
Database Passwords – Changing Security Levels
Understanding Access Security & How It Works
Workgroup Files – Creating / Joining
Groups and Users / Setting Permissions / Object Ownership
Assigning a New Administrator / Testing Security
Splitting the Database
Back end / Front end files – .mbd / .mde and back end files
Using Link refresh
Working with Multiple Front Ends
Linking to Other Applications
Importing to other Access Databases / ..from Excel and other Sources / Overview of MSQuery
Questions and Answers
Venues and Delivery:

We offer this course on a regular basis at our training venue in at The Travelodge, Cumbernauld- located on the A80 Cumbernauld Road, 10 minutes north of Glasgow, as well as offering in-house or bespoke training for HR departments or companies.

Please visit our schedule to find out when when our Access User training is running.

For more info on how Insight provide some of Scotland’s and Europe’s leading companies and what we can do for you.

Booking:

To book this course, please complete our on-line booking form or contact us on 01236 873498 or
email: workshopbookings@uk-insight.org.uk.