Course Outline
Pre-Requisites
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
Microsoft Access 365: Part 1
Lessons
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.
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.
Most of the features Microsoft incorporated in Office 2019 already exist in Office 365. Office 365 is a great solution for those looking for Office 2019 Training.
IS THIS THE RIGHT COURSE?
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
WHO SHOULD ATTEND?
Users who have experience working with table data, querying a database, creating advanced queries, creating advanced queries, generating reports and using advanced reporting tools, designing a relational database, joining tables and importing and exporting data.
WHAT YOU'LL LEARN
- Implementing Advanced Form Design
- Using Data Validation
- Using Macros to Improve Use Interface Design
- Using Advanced Database Management
- Distributing and Securing a Database
- Managing Switchboards
COURSE OUTLINE
Lesson 1: Implementing Advanced Form Design
- Topic A: Add Controls to Forms
- Topic B: Set Form Controls
- Topic C: Create Subforms
- Topic D: Organize Information with Tab Pages
- Topic E: Enhance Navigation with Forms
- Topic F: Format a Form
- Topic G: Apply Conditional Formatting
Lesson 2: Using Data Validation
- Topic A: Form and Field Validation
- Topic B: Data Validation Using Controls
Lesson 3: Using Macros to Improve User Interface Design
- Topic A: Create a Macro
- Topic B: Restrict Records Using a Condition
- Topic C: Validate Data Using a Macro
- Topic D: Automate Data Entry Using a Macro
- Topic E: Convert a Macro to VBA
Lesson 4: Using Advanced Database Management
- Topic A: Link Tables to External Data Sources
- Topic B: Manage a Database
- Topic C: Determine Object Dependency
- Topic D: Document a Database
- Topic E: Analyze the Performance of a Database
Lesson 5: Distributing and Securing a Database
- Topic A: Split a Database for Multiple User Access
- Topic B: Implement Security
- Topic C: Passwords
- Topic D: Convert an Access Database to an ACCDE File
- Topic E: Package a Database with a Digital Signature
Lesson 6: Managing Switchboards
- Topic A: Create a Database Switchboard
- Topic B: Modify a Database Switchboard
- Topic C: Set Startup Options
Cancellation Policy
We require 16 calendar days notice to reschedule or cancel any registration. Failure to provide the required notification will result in 100% charge of the course. If a student does not attend a scheduled course without prior notification it will result in full forfeiture of the funds and no reschedule will be allowed. Within the required notification period, only student substitutions will be permitted. Reschedules are permitted at anytime with 16 or more calendar days notice. Enrollments must be rescheduled within six months of the cancel date or funds on account will be forfeited.
Training Location
Online Classroom
your office
your city,
your province
your country
I would never take another course that starts at 11AM and goes to 9PM again. The way the course was laid out really took away from the capturing of what was presented as it was 5-6 hours of watching a screen before getting to the actual labs. There has to be a better way to lay out this particular course. In my previous course, the lectures were broken up by labs which worked out fantastic and kept you engaged in the course. There were days when in order to actually complete the labs, would go over the 9PM day end time frame. Was able to get the primary labs done, but if you want to get all the content completed, you cannot complete it in the window of this course, you will need to come back on your own time.