Welcome to the second part of our Microsoft Access 365 courseware. Access is Microsoft’s flagship database application that allows you to create and manage databases for all sorts of different purposes. This new version of Access incorporates a few new features and connectivity options to make databases more accessible to the everyday user.
This course is intended to build on foundational knowledge that was gained in Part 1 to impart an intermediate level of knowledge of Access 365. We will cover how to complete advanced form design tasks, add data validation, explore macros, better manage databases, secure databases, and much more.
By the end of this course, users should be comfortable managing existing databases and completing light database development and management work. Users should also know how to find information about databases and use the validation techniques covered to ensure the integrity of the data that is collected.
–
Prerequisites
This manual assumes that the user has completed or understands the materials covered in the first part of the Microsoft Access 365 courseware, including:
Getting started with Access
Working with table data
Querying a database
Creating advanced queries
Generating reports and using advanced reporting tools
Designing a relational database
Joining tables
Importing and exporting data
Topics
Lesson 1: Implementing Advanced Form Design
Lesson 2: Using Data Validation
Lesson 3: Using Macros To Improve User Interface Design
Lesson 4: Using Advanced Database Management
Lesson 5: Distributing and Securing a Database
Lesson 6: Managing Switchboards
Reviews
There are no reviews yet.