Start Dates: TBC
Duration: 1 Day
Full Fee: €100
Network Members Fee: €60
Programme overview
In this course, students will use Access 2016 to manage their data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.
Learning outcomes
In this course, you will create and manage an Access 2016 database.
You will learn how to:
- Navigate within the Microsoft Access application environment, create a simple database, and customize Access configuration options.
- Organise and manage data stored within Access tables.
- Use queries to join, sort, and filter data from different tables.
- Use forms to make it easier to view, access, and input data.
- Create and format custom reports.
Who is the course for?
This course is designed for students who wish to establish a foundational understanding of Microsoft Office Access 2016, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.
Modules
1 – Getting Started with Access
Orientation to Microsoft Access
Create a Simple Access Database
Get Help and Configure Options in Microsoft Access
2 – Working with Table Data
Modify Table Data
Sort and Filter Records
3 – Querying a Database
Create Basic Queries
Sort and Filter Data in a Query
Perform Calculations in a Query
4 – Using Forms
Create Basic Access Forms
Work with Data on Access Forms
5 – Generating Reports
Create a Report
Add Controls to a Report
Enhance the Appearance of a Report
Prepare a Report for Print
Organize Report Information
Format Reports
6 – Designing a Relational Database
Relational Database Design
Create a Table
Create Table Relationships
7 – Joining Tables
Create Query Joins
Relate Data Within a Table
Work with Subdatasheets
8 – Using Data Validation
Use Field Validation
Use Form and Record Validation
9 – Creating Advanced Queries
Create Parameter Queries
Summarize Data
Create Subqueries
Create Action Queries
Create Unmatched and Duplicate Queries
10 – Organizing a Database for Efficiency
Data Normalization
Create a Junction Table
Improve Table Structure
11 – Using Advanced Reporting Techniques
Include Control Formatting in a Report
Add a Calculated Field to a Report
Add a Subreport to an Existing Report
Trainer Profile:
For more information on training providers, please contact info@ifsskillnet.ie.