In this course, you will manage an Access database and add complex database features to improve its usability, efficiency, performance, and security.
You will:
Share data across applications.
Use action, unmatched, and duplicate queries to manage data.
Create complex reports and forms.
Use macros to improve user interface design.
Use VBA to extend database capabilities.
Perform database management tasks such as backup, compacting, repairing, performance analysis, checking object dependencies, and documenting.
Implement security strategies and distribute a database to multiple users.
Students taking this course are database administrators or prospective database administrators who have experience working with Access for Microsoft 365 and need to learn advanced skills.
Prerequisites
To ensure your success in this course, you should have experience working with Access, including a working knowledge of database design and creation, form design and creation, report design and creation, and a working knowledge of database querying and the various table relationships. You can obtain this level of skills and knowledge by taking the following Logical Operations courses:
Microsoft Access for Office 365™: Part 1
Microsoft Access for Office 365™: Part 2
*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.