Access 2016: Expert – Online Office Course

Access 2016: Expert (EN)

You've covered many of the basic functions of Microsoft Office Access 2016, and now you're ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access, and more. Knowledge of these features separate database professionals from the casual database users or occasional designers.

Often databases are not restricted to personal use. Collaborative work plays an important role, too. In this expert course you will learn how to prepare a database before rolling it out to others. Learn how to avoid unintended changes in design or more dangerous, the database itself.

Course Prerequisites:

To ensure your success in your course you should have experience working with Microsoft Access 2016, including a working knowledge of database design and creation, form design and creation, report design and creation, a working knowledge of database querying and the various table relationships.

Course Objectives:

In this course, you will learn to create and manage a fundamental Access 2016 database.

Customize a form layout to improve usability and efficiency of data entry.
Share data across applications.
Use macros to improve user interface design.
Organize data into appropriate tables to ensure data dependency and minimize redundancy.
Lock down and prepare a database for distribution to multiple users.
Create and modify a database switchboard and set the start-up options.

Inhalte

Implementing Advanced Form Design (EN)

Course Overview: Access 2016 - Expert (EN)	02:54
Introduction to Adding Controls to Forms	01:52
How to Add Controls to Forms	06:47
How to Use Subforms	03:03
Working with Tab Pages	05:53
Navigating Forms	04:30
Introduction to Conditional Formatting	00:29
How to Apply Conditional Formatting	02:24
Quiz zum Kurs „Implementing Advanced Form Design (EN)“

Sharing Data Across Applications (EN)

Introduction to Sharing Data Across Applications	01:10
How to Import CSV Files	05:50
How to Import Excel Files	04:43
Introduction to Exporting Access Data	01:12
Exporting CSV Files	03:36
Exporting Excel Files	02:06
Linking Tables to External Data Sources	01:21
Using Linked Files	07:36
Introduction to Creating a Mail Merge	00:42
How to Create a Mail Merge	04:03
Quiz zum Kurs „Sharing Data Across Applications (EN)“

Using Macros to Improve User Interface Design (EN)

Introduction to Macros	01:07
How to Create a Macro	06:28
Restricting Records Using a Condition	03:33
Validating Data Using a Macro	00:51
Working with Data Validation	06:01
Introduction to Automating Data Entry	00:34
Working with Automated Data Entry	04:44
Quiz zum Kurs „Using Macros to Improve User Interface Design (EN)“

Using Advanced Database Management (EN)

Introduction to Advanced Database Management	02:12
How to Compact and Repair a Database	03:16
Working with the Performance Optimizer	03:25
Determining Object Dependency	02:33
How to Document a Database	03:19
Quiz zum Kurs „Using Advanced Database Management (EN)“

Distributing and Securing a Database (EN)

Introduction to Distributing and Securing a Database	01:50
How to Split Databases	03:57
Hiding Objects	02:30
Working with Trusted Locations	02:52
How to Protect Passwords	03:36
Working with ACCDE Files	03:32
Using Digital Signature	03:58
Quiz zum Kurs „Distributing and Securing a Database (EN)“

Managing Switchboards (EN)

Introduction to Managing Switchboards	01:08
How to Create a Database Switchboard	05:37
Modifying Database Switchboards	02:21
Setting StartUp Options	02:03
Follow-Up: Access 2016 - Expert (EN)	01:14
Quiz zum Kurs „Managing Switchboards (EN)“

Quiz zum Kurs „Access 2016: Expert (EN)“

Dozenten des Kurses Access 2016: Expert (EN)

Sonic Performance

Sonic Performance Support is a provider of web-based video learning solutions in multiple languages for consumers, corporations of every size, associations and educational institutions.

All videos can be accessed instantly from any computer or mobile device via any browser and come with a human touch. Experienced trainers guide you step-by-step through the software features.

5 Sterne		5
4 Sterne		0
3 Sterne		0
2 Sterne		0
1 Stern		0

5 Sterne		5
4 Sterne		0
3 Sterne		0
2 Sterne		0
1 Stern		0