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 will:
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.
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.
Prerequisites
To ensure your success in this course, you should have end-user skills with any current version of Windows, including:
*Course cost listed does not include the cost of courseware $ 25.65. Please contact us at learn@vtec.org or 207-775-0244 for additional pricing information, or if you have any questions. Course is subject to a minimum enrollment. Course may run as a virtual instructor led course if minimum enrollment is not met.
You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2016. Exam cost not included in course cost.