| Course Name |
Hours |
List Price |
Content |
| Access 2016 Level 1 for Windows |
7.00 |
$279.00 |
|
Description: Most job roles today involve some form of data management. In the case of data workers, it may be their primary job task. For some, such as research scientists and accountants, data management may be a strong component of the job. And for others, such as sales clerks or those in the skilled trades, data management may consist of an incidental job responsibility, for example, time reporting or recording a sale. Virtually everyone is affected in some way by the need to manage data.
A relational database application such as Microsoft Office Access 2016 can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization.
In this course, you will use Access 2016 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data. You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2016.
With the completion of this course, you will be able to:
Navigate within the Microsoft Access application environment, create a simple database, and customize Access configuration options.
Organize 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.
# of Days:
Setting:
|
| Access 2016 Level 2 for Windows |
7.00 |
$289.00 |
|
Description: Your training and experience using Microsoft Access 2016 has given you basic database management skills, such as creating tables, designing forms and reports, and building queries.
In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, validate data entered into a database, and customize reports. Extending your knowledge of Microsoft Access 2016 will result in a robust, functional database for your users. You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2016. Extending your knowledge of Microsoft Access 2016 will result in a robust, functional database for your users.
At the end of this course, you will have experience creating and managing an Access 2016 database, as well as the following:
Design a relational database.
Join tables to retrieve data from unrelated tables.
Validate data entered into a database.
Use advanced queries to manipulate your data.
Organize a database for efficiency and performance, and to maintain data integrity.
Customize reports to organize the displayed information and produce specific print layouts.
# of Days:
Setting:
|
| Access 2016 Level 3 for Windows |
7.00 |
$299.00 |
|
Description: Youve covered many of the basic functions of Microsoft Office Access 2016, and now youre ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access, and more. Knowledge of these features separate database professionals from the casual database users or occasional designers.
This training, added to that which youve gained from the Microsoft Office Access 2016 Level 1 and Microsoft Office Access 2016 Level 2 courses, rounds out your Access education and provides you with marketable job skills.
At the completion of this course, you will have learned how to create and manage a fundamental Access 2016 database, as well as the following:
Customize a form layout to improve usability and efficiency of data entry.
Share data across applications.
Use macros to improve user interface design.
Use VBA to enhance tasks.
Organize data into appropriate tables to ensure data dependency and minimize redundancy.
Lock down and prepare a database for distribution to multiple users.
Create and modify a database switchboard and set the startup options.
# of Days:
Setting:
|
| Access 2019 Level 1 |
7.00 |
$279.00 |
|
Description: Data is everywhere. Most job roles today involve some form of data management. Virtually everyone is affected in some way by the need to manage data. A relational database application such as Microsoft Office Access can help you and your organization with this task. This course is the first part of a three-course series that covers the skills needed to perform database design and development in Access.
# of Days:
Setting:
|