title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.
Microsoft 365 Access: Part 2
Duration
1 Day
Course
VS-mos6009
Available Formats
Classroom Training, Online Training
Course Description
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.
Objectives
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
Implementing 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.
- In this second lesson of the course, the focus switches to data validation. Covered here is field validation along with form and record validation.
- 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.
- 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.
- 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.
- 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.
Related Courses
-
Microsoft 365 Fundamentals
MOC-MS-900T01- Duration: 1 Day
- Delivery Format: Classroom Training, Online Training
- Price: 595.00 USD
-
Microsoft 365 Messaging
MOC-MS-203T00- Duration: 5 Days
- Delivery Format: Classroom Training, Online Training
- Price: 2,975.00 USD
Self-Paced Training Info
Learn at your own pace with anytime, anywhere training
- Same in-demand topics as instructor-led public and private classes.
- Standalone learning or supplemental reinforcement.
- e-Learning content varies by course and technology.
- View the Self-Paced version of this outline and what is included in the SPVC course.
- Learn more about e-Learning
Course Added To Shopping Cart
bla
bla
bla
bla
bla
bla
Self-Paced Training Terms & Conditions
??spvc-wbt-warning??
??group-training-form-area??
??how-can-we-help-you-area??
??personalized-form-area??
??request-quote-area??
Sorry, there are no classes that meet your criteria.
Please contact us to schedule a class.
STOP! Before You Leave
Save 0% on this course!
Take advantage of our online-only offer & save 0% on any course !
Promo Code skip0 will be applied to your registration
Nothing yet
Purchase Information
??elearning-coursenumber?? ??coursename??
View Cart