All Computer Skills ||
Office 2007 Skills ||
Office 2010 Skills ||
Office 2016 Skills ||
Office 2013 Skills ||
Office 2016 Expert ||
Office 2016 Essentials ||
Office 2007 Essentials ||
Office 2007 Advance ||
Office 2010 Advance ||
Office 2010 Essentials ||
Office 2010 Expert ||
Office 2013 Advance ||
Office 2013 Essentials ||
Office 2013 Expert ||
Office 365 Essentials ||
Windows ||
Access 2016 Essentials
Learners will gain a fundamental understanding of this database application’s environment and basic database principles. They will be able to demonstrate the correct use of key features and the ability to create and maintain tables, relationships, forms, reports, and queries.
Objective:
- Create and modify databases
- Manage relationships and keys
- Navigate through a database
- Protect and maintain databases
- Print and export data
- Create and manage tables
- Manage records in tables
- Create and modify fields
- Create a query
- Modify a query
- Create calculated fields and grouping within queries
Introduction :
Getting Started
Welcome to the Access 2016 workshop. In this course, you’ll learn the core database management, manipulation and query skills needed to succeed in Access 2016. We’ll look at how to create and manage a database, how to build tables, and how to create queries, forms, and reports.
Module 1 :
Create and Manage a Database
In this module, you’ll learn how to create a desktop database and import data from Excel spreadsheets. We’ll also cover how to establish and edit relationships within a database, navigate through a database, and how to protect your database from data loss. Finally, we’ll cover how to print and export data from Access.
Module 2 :
Build Tables
Tables are the most important object in Access. Every piece of data entered into the database is stored in a table. We’ll look at how to create and manage tables, as well as how to manage records in tables and create and modify fields.
Module 3 :
Create Queries
Queries are a way to find data within a table. In this module, we’ll cover how to create and modify queries. We’ll also explain how to create calculated fields and grouping within queries.
Module 4 :
Create Forms
Forms allow users to quickly find, enter and edit data. In this module, we’ll cover how to create forms and configure form controls. We’ll also introduce formatting for forms.
Conclusion :
Wrapping Up
Although this workshop is coming to a close, we hope that your journey to improve your Access 2016 skills is just beginning. Please take a moment to review and update your action plan. This will be a key tool to guide your progress in the days, weeks, months, and years to come. We wish you the best of luck on the rest of your travels