In this course, you will optimize an Access database.
You will:
Provide input validation features to promote the entry of quality data into a database.
Organize a database for efficiency and performance, and to maintain data integrity.
Improve the usability of Access tables.
Create advanced queries to join and summarize data.
Use advanced formatting and controls to improve form presentation.
Use advanced formatting and calculated fields to improve reports.
This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases and developing tables, queries, forms, and reports in Microsoft Access for Microsoft 365.
Prerequisites
To ensure your success in this course, it is recommended you have completed Microsoft® Access® for Office 365™: Part 1
It is also suggested that you have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites. You can obtain this level of skills and knowledge by taking the following Logical Operations course, or any similar courses in general Microsoft Windows skills:
*Course cost listed does not include the cost of courseware $ 26.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. Exam not included.