Access 2016 Basis E-Learning

Access 2016 Basis E-Learning

Bestel deze geweldige E-Learning cursus Access 2016 online, 1 jaar 24/ 7 toegang tot rijke interactieve video’s, spraak, praktijkopdrachten, voortgangsbewaking door rapportages en testen per onderwerp om de kennis direct te toetsen. Deze E-Learning bereid u ook voor op het Microsoft Office Specialist MOS examen dankzij de hoge kwaliteit. Door ontwikkelt door MOS docenten met méér dan 27 jaar ervaring en de uitgever is een Microsoft Gold Partner. In het Leerportaal LMS o.a. rapportages en na 70% van de cursus een certificaat van deelname.

Cursusinhoud

Introduction to the Access 2016 Interface, DataBasics Management, and Tables

Course: 1 Hour, 7 Minutes

Course Introduction
Overview of DataBasicss
Planning a DataBasics
Access 2016 Enhancements

Orientation to the Access Environment Creating Relationships, Queries, Forms and Reports in Access 2016

Course: 1 Hour

Course Introduction
Overview of Relationship Types
Rules for Creating Relationships

Defining Primary Keys and Setting Relationships Access 2016: Working with DataBasicss

Course: 27 Minutes

Creating a dataBasics
Using dataBasics templates
Understanding the interface
Customizing the interface
Customizing your Quick Access Toolbar

Customizing the ribbon Access 2016: Saving, Printing & Exporting DataBasicss

Course: 26 Minutes

Saving your data
Saving regularly
Protecting your dataBasics
Printing items in your dataBasics
Exporting your dataBasics

Sending your dataBasics table via email Access 2016: Tables, Fields, & Entries

Course: 40 Minutes

Understanding your dataBasics
Creating a table
Organizing your dataBasics items
Inserting fields in your table
Formatting your dataBasics fields
Editing your dataBasics field properties
Linking data in different tables
Managing data relationships

Visualizing object dependencies Access 2016: Inserting, Importing, & Formatting Data

Course: 35 Minutes

Inserting data into your table
Modifying the default editing settings
Using external data in your dataBasics
Importing your address book from Outlook
Formatting your data
Creating dropdown menus
Creating data validation rules

Creating labels Access 2016: Finding & Organizing Data

Course: 25 Minutes

Sorting your data
Filtering your data
Locating a data value
Replacing data values
Editing your dataBasics indexes

Finding duplicates in your dataBasics Access 2016: Creating Forms & Queries

Course: 1 Hour, 17 Minutes

Creating a data entry form using the wizard
Using different form types
Creating a data entry form from scratch
Inserting text in a form
Inserting data entry fields in a form
Inserting a list box in a form
Inserting check boxes in a form
Inserting buttons in a form
Reorganizing your form
Adding information to your form
Customizing the appearance of your form
Editing your form's properties
Creating a simple query
Creating a crosstab query
Performing a simple calculation

Creating a calculated field Access 2016: Using the Report & Analysis Tools

Course: 28 Minutes

Creating a quick report
Creating your own dataBasics report
Customizing your report
Cleaning up your dataBasics
Analyzing your data Basics