Microsoft Access Introduction
Training
Online
Description
-
Type
Training
-
Level
Beginner
-
Methodology
Online
-
Duration
2 Days
-
Start date
Different dates available
A comprehensive 2-day Microsoft Access training course suitable for complete beginners to Microsoft Access. After the training you will able to create a database from scratch. You will understand and be able to build tables, fields and records, set the rules for entering data and create forms for input.
Also, you'll learn how to extract information in the form of simple queries and reports and export to Excel, PDF and mail merge. Our course also covers database design - essential knowledge when learning to build databases and understanding how they work.
Important information
Documents
- microsoft-access-introduction.pdf
Facilities
Location
Start date
Start date
About this course
Getting Started and Table Design
Create a new database
Overview of the Microsoft Access Environment
Create new tables
Set field names
Choose data types
Consider and set field properties
Create a drop down list
Understanding Relationships
Create One to Many Relationships
Create One to One Relationships
Change Relationship Properties
Understand Referential Integrity
Work with Forms
Create a standard Form
Create a Form using the Wizard
Re-design a Form
Create a Form with a sub-form
Input data using Forms
Work with Queries
Create and save standard Queries
Sort data within a Query
Set criteria for Queries
Concatenate data within a Query
Create calculations in a Query
Use Parameter Query
Work with Reports
Create a report from Table data
Create a report from Query data
Group Information in a Report
Re-design Report elements
Create Mailing Labels
Export data from Microsoft Access
Export information to Microsoft Excel
Export information to Microsoft Word
Export information to a PDF file
Use the Mail Merge feature
Any person who wants to learn how to build a database. Our courses are generally aimed at business users.
A desire to learn how to build databases
Certificate of attendance
Engaging trainers delivering Live Online
Up to 4 delegates only on a public course
We post your course materials to you and send a link to join the course
1 year's after course support included
Enroll on our course via our website.
We will then send your course information on enrollment
Reviews
Subjects
- Microsoft Access
- Access Databases
- Access
- Microsoft Access 2010
- Microsoft Access 2013
- Microsoft Access 2016
- Database Design
- Database training
- Office IT
- MS Access
Teachers and trainers (1)
Qualified Trainer
Senior trainer
Course programme
comprehensive 2-day Introduction to Microsoft Access - course suitable for complete beginners to Microsoft Access. After the training you will able to create a database from scratch. You will understand and be able to build tables, fields and records, set the rules for entering data and create forms for input.
Also, you'll learn how to extract information in the form of simple queries and reports and export to Excel, PDF and mail merge. Our course also covers database design - essential knowledge when learning to build databases and understanding how they work.
Additional information
Microsoft Access Introduction