Entdecken Sie, was Sie lernen können.

Mit Videokursen für Beruf, Studium und Freizeit.

Access 2016 - Expert (EN)

Von Sonic Performance

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

play symbol Course Overview: Access 2016 - Expert (EN)
02:54
lecture locked Introduction to Adding Controls to Forms
01:52
lecture locked How to Add Controls to Forms
06:47
lecture locked How to Use Subforms
03:03
lecture locked Working with Tab Pages
05:53
lecture locked Navigating Forms
04:30
lecture locked Introduction to Conditional Formatting
00:29
lecture locked How to Apply Conditional Formatting
02:24
Quiz zum Kurs „Implementing Advanced Form Design (EN)“
play symbol Introduction to Sharing Data Across Applications
01:10
lecture locked How to Import CSV Files
05:50
lecture locked How to Import Excel Files
04:43
lecture locked Introduction to Exporting Access Data
01:12
lecture locked Exporting CSV Files
03:36
lecture locked Exporting Excel Files
02:06
lecture locked Linking Tables to External Data Sources
01:21
lecture locked Using Linked Files
07:36
lecture locked Introduction to Creating a Mail Merge
00:42
lecture locked How to Create a Mail Merge
04:03
Quiz zum Kurs „Sharing Data Across Applications (EN)“
play symbol Introduction to Macros
01:07
lecture locked How to Create a Macro
06:28
lecture locked Restricting Records Using a Condition
03:33
lecture locked Validating Data Using a Macro
00:51
lecture locked Working with Data Validation
06:01
lecture locked Introduction to Automating Data Entry
00:34
lecture locked Working with Automated Data Entry
04:44
Quiz zum Kurs „Using Macros to Improve User Interface Design (EN)“
play symbol Introduction to Advanced Database Management
02:12
lecture locked How to Compact and Repair a Database
03:16
lecture locked Working with the Performance Optimizer
03:25
lecture locked Determining Object Dependency
02:33
lecture locked How to Document a Database
03:19
Quiz zum Kurs „Using Advanced Database Management (EN)“
play symbol Introduction to Distributing and Securing a Database
01:50
lecture locked How to Split Databases
03:57
lecture locked Hiding Objects
02:30
lecture locked Working with Trusted Locations
02:52
lecture locked How to Protect Passwords
03:36
lecture locked Working with ACCDE Files
03:32
lecture locked Using Digital Signature
03:58
Quiz zum Kurs „Distributing and Securing a Database (EN)“
play symbol Introduction to Managing Switchboards
01:08
lecture locked How to Create a Database Switchboard
05:37
lecture locked Modifying Database Switchboards
02:21
lecture locked Setting StartUp Options
02:03
lecture locked Follow-Up: Access 2016 - Expert (EN)
01:14
Quiz zum Kurs „Managing Switchboards (EN)“
Quiz zum Kurs „Access 2016 - Expert (EN)“

Details

  • Enthaltene Vorträge: 42
  • Laufzeit: 2:12 h
  • Enthaltene Quizfragen: 23

Dozenten des Kurses Access 2016 - Expert (EN)

 Sonic Performance

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.


Rezensionen

(1)
5,0 von 5 Sternen
5 Sterne
5
4 Sterne
0
3 Sterne
0
2 Sterne
0
1  Stern
0