VALENTINES DAY SPECIAL - 50% off All Courses at Checkout - click here to apply or use code VALENTINE2024 at Checkout!

Access 2016 Expert - eBSI Export Academy
Access 2016 Expert - eBSI Export Academy
Access 2016 Expert - eBSI Export Academy
Access 2016 Expert - eBSI Export Academy

 

Book a Consultation

Access 2016 Expert

Vendor
eBSI Export Academy
Regular price
€40.00
Sale price
€40.00
Tax included. Shipping calculated at checkout.

Access 2016 Expert
Objectives: This two hour course will help learners to design databases at an expert level or improve existing Access databases. Also, advanced conversion of databases made in other applications and spreadsheet (flat file) databases. 

Completing this course will confer 2 CPD Credits towards internationally recognised Continuous Professional Development Requirements within organisations operating this kind of staff development methodology.

 

Unit Contents:


1. Getting Started
In this topic you will cover a basic introduction to the course unit and its objectives.

2. Managing Relational Databases
In this topic you will cover:
Managing Relational Databases
Database Concepts
Database Design
Normalisation
Database Integrity
Types of Relationship
Creating Table Links
Referential Integrity
Self-test Quiz

3. Customising Forms
In this topic you will cover:
Customising Forms
List And Combo Boxes
Check Boxes, Option & Toggle Buttons.
Option Groups
Command Buttons
Calculated Fields
Using Form’s Input Values
Create A Form With Multiple Pages Or Tabs
Tab Order
Inserting Graphics in Forms or Reports
AutoFormat
Self-test Quiz

4. Optimise and Administer Access
In this topic you will cover:
Optimise and Administer Access
Optimising Performance
The Performance Analyzer
The Add in Manager
Compacting Your Database
The Database Documentor
The Database Splitter
Recovering Damaged Databases
Importing and Linking Tables
Self-test Quiz

5. Introduction to SQL
In this topic you will cover:
Introduction to SQL
Introduction
Data Definition Language
Data Manipulation Language
Self-test Quiz

6. Wrapping Up / Assessment Result
In this topic you will cover:
Course Conclusion
Wrapping up
Test Results Summary