Course Overview
This eLearning bundle includes three courses:
- Microsoft Access 365: Beginner
- Microsoft Access 365: Intermediate
- Microsoft Access 365: Advanced
Course Topics
Access 365: Beginner – 4 hrs 40 min
This course is an introduction to Microsoft Access 365. In this course, students will become familiar with various database components, concepts, and terminology. Students will tour the user interface, create databases, create objects, perform calculations, navigate and work with tables, understand and work with queries, review and work with various reports and reporting features, and review forms and the various tools that go along with them. This course will give the student the required knowledge to complete the Access 365 Intermediate course.
• Understand databases and database terminology
• Work with various data types
• Create queries, databases and database objects
• Create and modify reports and forms
Access 365: Intermediate – 4 hrs 15 min
This course is designed to teach students intermediate level skills in Microsoft Access 365. In this course, students will learn to design tables for improved accuracy in data entry, review the various options to share data with other applications, learn about action queries, and review various advanced query techniques. Students will also learn how to automate processes with Macros, advanced form techniques, and advanced report techniques. This course prepares students for the Access 365 Advanced course.
• Design tables for better data entry
• Share data with other applications
• Work with action queries and learn advanced query techniques
• Automate processes with macros
• Create advanced forms and learn advanced reporting techniques
Access 365: Advanced – 1 hr 43 min
Access 365 Advanced will further build upon the topics covered in the Access 365 Introduction and Intermediate courses. Students will review how to improve the structure of an Access database, maintain an Access database, create and modify Switchboards, configure security and multi-user environments, automate processes with VBA (Visual Basic for Applications), and use Table Events.
• Improve the structure of a database
• Maintain a database
• Work with navigation forms and startup options
• Automate processes with VBA
• Use table events
• Configure Access for multiple users
