About this courseMicrosoft Access 365 | Complete Training 2022
Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Access Database Engine (ACE) with a graphical user interface and software-development tools. It is a member of the Microsoft 365 suite of applications, included in the Professional and higher editions or sold separately. Software developers, data architects and power users can use Microsoft Access to develop application software. Like other Microsoft Office applications, Access is supported by Visual Basic for Applications (VBA), an object-based programming language that can reference a variety of objects including the legacy DAO (Data Access Objects), ActiveX Data Objects, and many other ActiveX components. Visual objects used in forms and reports expose their methods and properties in the VBA programming environment, and VBA code modules may declare and call Windows operating system operations.
This course covers the following topics:
- All about importing data and the datasheet view
- How tables work in Access and how to create relationships between them
- Creating forms and sub-forms that feed data into your tables
- How to run queries in Access
- Setting up validations and calculations using expressions in Access
- Printing from Access
- To start to use macros and Modal Dialog
- The basics of the Access web app
- Exporting and reporting in Access
- About Primary Keys and Indexes in Access
- About customizing and filtering on the Datasheet View
- How to link to other databases
- All about Macros in Access
- More advanced techniques around creating forms in Access
- Advanced queries
- Generating reports
This course includes:
schedule2 hours on-demand video
signal_cellular_altAdvanced level
task_altPreparation required
calendar_todayPublished At Jan 11, 2022
workspace_premiumCertificate of completion
errorNo advanced preparation is required.
calendar_todayUpdated At Jan 22, 2025