Overview
Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. Microsoft Access stores data in its own format based on the Access Jet Database Engine. It can also import or link directly to data stored in other applications and databases.
Course description
Data is everywhere. Whether you are at the grocery store, office, laboratory, classroom, or ballpark, you are awash in data: prices, schedules, performance measures, lab results, recipes, contact information, quality metrics, market indices, grades, and statistics. This course is for individuals using Access 365, 2019 or 2016 and is taught using Access 2019 software. However, there are very few differences between the 365 and 2016 versions from an end-user’s perspective. Our instructors have used all versions and will be able to quickly highlight the several small changes to the user interface. Users of any of the versions of Access will have no problem learning in the 2019 software environment.
This course is designed for students who wish to establish a foundational understanding of Microsoft Office Access, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.
Benefits
Microsoft Access is an excellent alternative to client-server databases for individuals and small teams — both technical and non-technical. The user-friendly interface enables you to import and export data to other applications, use templates to create and publish data and effortlessly build and publish web databases.
Ready to improve your database skills with Microsoft Access training?
Learning outcomes
- Create and design Access databases.
- Work with Access tables, relationships, keys, and constraints.
Query data. - Manage and design interfaces with Access Forms.
- Create basic to advanced reports.
Automate tasks with Macros and VBA. - And so much more.
Course Features
- Lectures 0
- Quizzes 0
- Duration Lifetime access
- Skill level All levels
- Language English
- Students 298
- Assessments Yes