Course Overview
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.
What you’ll learn
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.
Requirements
- 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
Curriculum
- 1 Section
- 6 Lessons
- 1 Day
- Topics6
- 1.1Implementing Advanced Form Design This lesson takes a look at several topics to increase your students’ knowledge of Access 365. Here, students will learn how to add controls to forms, set form controls, create subforms, organize information with tab pages, enhance database navigation with forms, format a form, and apply conditional formatting.
- 1.2Using Data Validation In this second lesson of the course, the focus switches to data validation. Covered here is field validation along with form and record validation.
- 1.3Using Macros to Improve User Interface Design The next lesson turns to macros and using them to improve user interface design. Students will learn to create basic macros that use actions, conditions, arguments, and events to complete a task. They should also be able to create macros that complete basic validation and automation tasks, as well as convert existing macros to VBA.
- 1.4Using Advanced Database Management Some advanced database management skills come under scrutiny in this lesson. Topics in this lesson teach students how to: link tables to external data sources, manage a database, determine object dependency, document a database, and analyze the performance of a database.
- 1.5Distributing and Securing a Database In this lesson, students will learn about the many ways that you can distribute and secure a database. Topics covered are splitting a database, as well as implementing many of the security strategies that are available in Access. Students should feel comfortable converting a database into the ACCDE format and be able to package and digitally sign a database for distribution.
- 1.6Managing Switchboards The final lesson of Microsoft Access 365: Part 2, is all about switchboards. Students are taught how to create a database switchboard, how to modify a database switchboard, and how to set startup options.
Instructor
