Microsoft Access Masterclass
The Microsoft Access course gives an overview of Microsoft Access's functionality and features. The Microsoft Access training course teaches delegates how to create and run databases. Delegates will learn how to design and construct tables for a new database, as well as how to create a relationship between the tables.
Overview
Microsoft Access is a database construction and management tool that enables users to professionally manage, record, and report data. The Access Masterclass training course covers the fundamentals of creating and designing databases, querying tables, and creating forms and reports to obtain the desired results. The training exposes delegates to database terminology, components, ideas, and basic to advanced Access functionalities. Delegates will be able to develop and design Access databases, manage and design interfaces using Access Forms, work with Access tables and relationships, and automate processes with Macros and VBA after completing this course.
Why should I complete the Microsoft Access Masterclass ?
Microsoft Access training teaches you how to manage and develop an interface using Access forms. Delegates will learn how to conduct a SQL query, produce reports and forms, and traverse an Access database during the session. Delegates will save time by managing, storing, and editing thousands of records. Delegates will have a solid knowledge of database design ideas during the Microsoft Access course. Delegates learn how to export and import data from a wide range of applications and data sources. The delegate also learns how to run more complicated queries in Access utilising a variety of querying strategies. Delegates will be able to establish and maintain their databases by the end of the Microsoft Access course.
Modules
Understand User Interface
- Access Ribbon
- Overview of FILE
- Save a Database as a Template
- HOME
- Learn CREATE
- EXTERNAL DATA
- Understand DATABASE TOOLS
- Contextual Tabs
- Quick Access Toolbar
- Define Tables
- Queries
- Forms
- Reports
- Macros and Modules
Object Navigation Pane
- Work Surface
- Access Options Dialog Box
- Object Overview
- Build a Database using Wizard
- Process Overview
Fundamentals
- Basic queries
- Purpose and users of the database
- Kind of output we need
- Methods to Database Design
- Top-Down
- Bottom-Up
- Collect Information
- Data Mapping
- Sample Data Map
- Normalization
- 1st NF
- 2nd NF
- 3rd NF
- Naming Conventions
- Table Relationships
- Different Types of Relationships
- Normalizing Data
Handling Queries
- Building Simple Queries
- Sorting and Filtering of Data in a Query
- Performing Calculations
- Learn Dynaset
- Enter Criteria: Exact Match and Range Operators
- Understand the difference between AND versus OR
- Use of Wild Cards
- Learn about use Keywords
- Sort and Hide Fields
- Create Multi-Table Queries
- Additional Tips
Handle Forms
- Build Basic Access Forms
- Work with Data on Access Forms
Generate Reports
- Build a Report
- Add Controls to a Report
- Improve an Appearance of a Report
- Preparing a Report for Print
- Organise Report Information
- Format Reports
Tables
- Building an Access Database
- Build a New Database
- Different Data Types
- Determine Data Types
- Create a Table in Design View
- Deleting a Field
- Renaming of a Table
- Create a Table in Design View
Forms
- Forms
- Definition and Purpose
- Views
- Alter a Form
- Add Data Records in Form View
- Form Record Navigation
- View of layout
- Designing of a View
- One-Click Forms
- Primary Data Entry Form
- Primary Multi-Record Form
- Datasheet Form
- Split Form
- Form Wizard
- Create a Form with the Form Wizard
Reports
- Overview of Reports
- Define
- Use
- Views
- One-Click Report
- Reporting Wizard
- Build a Report using the Report Wizard
Macros
- Macro Basics
- Opening a Table, Form, and Report
- Run a Query
- Print a Report
- Run a Macro
- Create Simple Macros
Organising a Database for Efficiency
- Data Normalization
- Create a Junction Table
- Improve Table Structure
Entry Requirements
Don't worry, no prior familiarity with Microsoft Access is required to take this session.
How to Apply
Each of our courses has different entry requirements and a different admission process. We encourage you to look at our course pages and the How to apply section for detailed information.
This course is currently only available online in instructor-led format. Classes will take place via GoTo Webinar and Microsoft Teams. For more information please contact us.
FEE
For information regarding fees please scroll down to the pricing section.
Please consider that we are currently not offering in-class lessons due to Covid restrictions.
TIMETABLE
For information regarding the timetable for this course, please scroll down to review the full dates and availability
DURATION
1-5 days
WHATS INCLUDED
Course Material
Case Study
Experienced Lecturer
Refreshments
Certificate
Package Deals
For package deals please enquire now and speak to a member of our team.
Understand User Interface
- Access Ribbon
o Overview of FILE
o Save a Database as a Template
o HOME
o Learn CREATE
o EXTERNAL DATA
o Understand DATABASE TOOLS
o Contextual Tabs
- Quick Access Toolbar
o Define Tables
o Queries
o Forms
o Reports
o Macros and Modules
Object Navigation Pane
- Work Surface
- Access Options Dialog Box
- Object Overview
o Build a Database using Wizard
o Process Overview
Fundamentals
Basic queries
o Purpose and users of the database
o Kind of output we need
Methods to Database Design
o Top-Down
o Bottom-Up
Collect Information
o Data Mapping
o Sample Data Map
Normalization
o 1st NF
o 2nd NF
o 3rd NF
Naming Conventions
Table Relationships
o Different types of Relationships
Normalizing Data
Handling Queries
- Building Simple Queries
- Sorting and Filtering of Data in a Query
- Performing Calculations
- Learn Dynaset
- Enter Criteria: Exact Match and Range Operators
- Understand difference between AND versus OR
- Use of Wild Cards
- Learn about use Keywords
- Sort and Hide Fields
- Create Multi-Table Queries
- Additional Tips
Handle Forms
- Build Basic Access Forms
- Work with Data on Access Forms
Generate Reports
- Build a Report
- Add Controls to a Report
- Improve an Appearance of a Report
- Preparing a Report for Print
- Organise Report Information
- Format Reports
Tables
- Building an Access Database
- Build a New Database
- Different Data Types
- Determine Data Types
- Create a Table in Design View
o Deleting a Field
o Renaming of a Table - Create a Table in Design View
Forms
Forms
Forms
o Definition and Purpose
o Views
Alter a Form
Add Data Records in Form View
Form Record Navigation
View of layout
Designing of a View
One-Click Forms
o Primary Data Entry Form
o Primary Multi-Record Form
o Datasheet Form
o Split Form
Form Wizard
o Create a Form with the Form Wizard
Reports
Overview of Reports
o Define
o Use
o Views
o One-Click Report
Reporting Wizard
o Build a Report using the Report Wizard
Macros
Macro Basics
o Opening a Table, Form, and Report
o Run a Query
o Print a Report
Run a Macro
Create Simple Macros
Organising a Database for Efficiency
Data Normalization
Create a Junction Table
Improve Table Structure
DELIVERY METHOD
- More events & information
- More events & information
Enter your requirements below :
Submit your onsite requirements and a member of our team will be in contact with you to discuss them further.
The course is intended for anybody wishing to improve their skills with Access.
Course Material
Case Study
Experienced Lecturer
Refreshments
Certificate