Home » Access 2016 Basis

Opleiding: Access 2016 Basis

Bij: OEM Office Elearning Menu

 

OEM Office Elearning Menu

P.J, Oudweg 4
1314 CH ALMERE
 

Inhoud van de cursus

Introduction to the Access 2016 Interface, Database Management, and Tables
Course: 1 Hour, 7 Minutes
Expertise Level: Beginner
Overview
Microsoft Access 2016 makes it easy to create professional databases for home, and business use. In this course, you'll learn about the new interface and key new features introduced in Access 2016. In addition, you will learn how to structure and construct a database design for a particular purpose. Included in this course is a section on adding, and modifying tables and table fields using different methods and views. This course is one of a series in the SkillSoft learning path that covers Microsoft Access 2016 for beginners.

Prerequisites
None

Target Audience
End users at all levels, including those who have littleno familiarity with Microsoft Access and more experienced Access users who want to learn about the new interface and features to create a database using Access 2016.

Objectives
Introduction to Databases

start the course
describe what a database is and the advantages of using a database for different purposes
distinguish between data and information and outline key considerations when structuring a database
identify new features in Access 2016
describe the Access 2016 interface
Database Organization and Management

distinguish between database objects such as tables, queries, forms, and reports
open, create, and save databases in Access 2016
set various database options using the Access 2016 Backstage
Building Tables

create a table using Datasheet and Design view in Access 2016
switch table views and modify table fields in Access 2016
work with table fields and data using the Design and Datasheet view in Access 2016
modify table field properties in Access 2016
apply sort options and filter types when working with table data in Access 2016
Practice: Creating Databases

create and modify a database in Access 2016
Access 2016: Working with Databases
Course: 27 Minutes
Expertise Level: Beginner
Overview
Access 2016 is the database application in the Microsoft Office 2016 suite. Discover how to open existing databases and create new ones, and learn how you can customize the interface, including the Quick Access Toolbar and ribbon.

Objectives
Creating a database
Using database templates
Understanding the interface
Customizing the interface
Customizing your Quick Access Toolbar
Customizing the ribbon
Access 2016: Saving, Printing & Exporting Databases
Course: 26 Minutes
Expertise Level: Beginner
Overview
Data is key for any database application, and you'll want to be able to save, protect, and share it. Discover how to save data, protect your database, print database items, export a database, and send tables via email in Access 2016.

Objectives
Saving your data
Saving regularly
Protecting your database
Printing items in your database
Exporting your database
Sending your database table via email
Creating Relationships, Queries, Forms and Reports in Access 2016
Course: 1 Hour
Expertise Level: Intermediate
Overview
Queries, being the heart of Access 2016, allows searching and extraction of information from tables for analysis. In this course, you'll learn how to set primary keys, forming relationships between objects in a database. In addition, this course demonstrates how to design forms and reports for data input, and how to present information in a neat and organized format. In addition, you will learn various methods of exporting and importing data using Access 2016. This course is one of a series in the SkillSoft learning path that covers Microsoft Access 2016 for beginners.

Prerequisites
None

Target Audience
End users at all levels, including those who have littleno familiarity with Microsoft Access and more experienced Access users who want to learn about the new interface and features to create a database using Access 2016.

Objectives
Setting Relationships

start the course
outline the different types of relationships and when they should be applied in Access 2016
recognize the rules for creating relationships between tables in an Access 2016 database
choose a primary key from table fields and set relationships between tables in Access 2016
Building Forms

change form views and edit a form using Design View in Access 2016
apply blank forms and quick start templates to an Access 2016 database
modify data in a form in Access 2016
modify data on a form and delete form records in Access 2016
Construct Queries

list the different query types available in Access 2016
create and run queries in Access 2016
create update, make table, and append queries in Access 2016
use the Total Column and the Query Setup features in Access 2016
Designing Reports

modify and preview reports in Access 2016
Import and Export

export and import data in different file formats in Access 2016
Practice: Working with Queries

set a relationship between fields, create a parameter query and report, and import data in Access 2016
Access 2016: Tables, Fields, & Entries
Course: 40 Minutes
Expertise Level: Intermediate
Overview
To get the most out of Access 2016, you need to understand the structure and main elements of a database. Explore tables, primary keys, and relationships, and discover how to format and edit both fields and field properties.

Objectives
Understanding your database
Creating a table
Organizing your database items
Inserting fields in your table
Formatting your database fields
Editing your database field properties
Linking data in different tables
Managing data relationships
Visualizing object dependencies
Access 2016: Inserting, Importing, & Formatting Data
Course: 35 Minutes
Expertise Level: Intermediate
Overview
There is little value in an empty database table. Learn how to enter and import data, change formatting settings, create dropdown menus, enforce data validation, and create labels with your data.

Objectives
Inserting data into your table
Modifying the default editing settings
Using external data in your database
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
Expertise Level: Intermediate
Overview
As your tables get larger, it gets harder to locate specific data. Discover how to sort and filter data, edit indexes, search for data, and locate duplicate values and records.

Objectives
Sorting your data
Filtering your data
Locating a data value
Replacing data values
Editing your database indexes
Finding duplicates in your database
Access 2016: Creating Forms & Queries
Course: 1 Hour, 17 Minutes
Expertise Level: Intermediate
Overview
Forms in Access 2016 are designed to help you visualize records and create new data entries more easily. Discover different ways to create and customize forms, and create and work with queries.

Objectives
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
Expertise Level: Intermediate
Overview
For data to be useful, it must be accurate and presented in a meaningful way. Learn how to use the Access 2016 tools to create and customize reports, and to analyze and clean your data to help ensure data integrity.

Objectives
Creating a quick report
Creating your own database report
Customizing your report
Cleaning up your database
Analyzing your database

Toelatingseisen: wat heb je nodig?

Er is geen specifieke voorkennis vereist.

Duur van de cursus

variable

Bijzonderheden

Microsoft Gold Gecertificeerde E-learning

Plaatsen / leslocaties

Heel Nederland, E-learning, Online

Algemene informatie over de cursus

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.

Duur:
Taal: Engels
Certificaat van deelname: Ja
Online toegang: 365 dagen
Voortgangsbewaking: Ja
Award Winning E-learning: Ja
Geschikt voor mobiel: Ja

Informatie aanvragen

Gegevens aangeduid met een * zijn verplicht in te vullen.
jaar
 
resterend: tekens
 
E6Ff9 Typ de code exact over: (hoofdlettergevoelig)
 
© Copyright 2009-2020 Particuliereopleidingen.nl | Algemene voorwaarden | Overzicht van onze aanbieders | Adverteren