Microsoft Access Level 3 - OnlineInsight IT Training
Microsoft Access Level 3 - Online
All available course dates
Microsoft Access Level 3 - Online
*We now offer Online IT training remotely to businesses in the UK and in Europe. This course is delivered remotely as a real time face-to-face communication with the trainer. You will be able to see the trainer and the trainer will be able to see you and your screen. All secure and private. No videos, animations or modules to complete online. This is proper hands-on instructor led training for your staff. Just like in a classroom, plus, all the benefits of private training. A Remote solution for effective Virtual training, delivered using either Microsoft Teams or Zoom, which are both free to download. Online IT training can be 1-to-1 or for a group of up to 6 people, plus a Per Hour option.
Delivered by highly knowledgeable trainers with extensive product knowledge, this Microsoft Access Level 3 course provides your database administrators with the advanced skills in using the Access software for effective database management.
The private programme is typically delivered on-site over the course of one day, and includes a large number of practical exercises that enable delegates to practise the skills covered. Using your company PCs or Insight's own high specification equipment, the training covers a range of Access' more complex features, including:
- Advanced form design
- Using macros
- Securing a database
- Managing switchboards
The hands-on nature of the course ensures that delegates develop a high degree of confidence in using the complex techniques covered. Though the standard course has a set outline, organisations can choose to further customise the content in order to meet a specific need.
Insight IT Training can arrange for the training to cover any version of the Microsoft Access software.
Suitability - Who should attend?
This course is suitable for current and prospective database administrators looking to develop advanced skills in Microsoft Access. In order to draw the most benefit from the course, Insight IT Training recommends that users attend the Microsoft Access Level 1 and Level 2 courses prior to attempting the Level 3.
Outcome / Qualification etc.
Each trainee will receive a Certificate of Attendance, signed by the trainer. You will also receive copies of the Evaluation Forms completed by the trainee(s) for your records.
Training Course Content
Standard course content includes:
Implementing Advanced Form Design
- Add Controls to Forms
- Create Subforms
- Organize Information with Tab Pages
- Enhance Navigation of Forms
- Apply Conditional Formatting
Using Data Validation
- Field and Record Validation
- Form Validation
Using Macros to Improve User Interface Design
- Create a Macro
- Restrict Records Using a Condition
- Validate Data Using a Macro
- Automate Data Entry Using a Macro
- Convert a Macro to VBA
Using Advanced Database Management
- Link Tables to External Data Sources
- Manage a Database
- Determine Object Dependency
- Document a Database
- Analyze the Performance of a Database
Distributing and Securing a Database
- Splitting a Database for Multiple User Access
- Implement Security
- Set Passwords
- Convert an Access Database to an ACCDE File
- Package a Database with a Digital Signature
- Create a Database Switchboard
- Modify a Database Switchboard
- Set Startup Options
Levels of Study
Insight IT Training delivers standard Access courses at Introductory, Intermediate, Advanced and VBA levels, either Online, in-house or on-site at your office.
These courses can also be tailored - in content, format and duration - to meet your exact needs.
All the prices quoted are a total fixed cost and are the same for any location in the UK. Each person will receive a Certificate of Attendance, free ongoing post training support (if needed), and a comprehensive and user-friendly reference manual in pdf format.
Be Inspired! Watch the Video
Provider: Insight IT Training
Insight IT Training - Customised IT and Business Skills Training, Tailored to Your Company
*We now offer Online IT training remotely to businesses in the UK and in Europe. This course is delivered remotely as a real time face-to-face communication with the trainer. You will be able to see the trainer and the trainer...
Request information - obligation free
Contact information for Insight IT Training
Find out more about this Microsoft Access Level 3 - Online course - simply fill out your details: