|
Microsoft Access 365: Part 2
Code:
MS Access 365 P2
Duration:
1 Day
|
$295
USD
|
Welcome to the second part of our Microsoft Access 365 courseware. Access is Microsofts 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.
This course is available in the following formats:
Duration: 1 Day
Duration: 1 Day
|
Delivery Format: Virtual Classroom
|
$ 295 |
|
|
Delivery Format: Virtual Classroom
|
$ 295 |
- 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
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
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
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.
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