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.
Inhoud
Introduction to the Access 2016 Interface, Database Management, and Tables
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 little or no 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
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
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
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 little or no 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
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
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
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
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
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
Laat ons helpen!
| Duur: | |
| Taal: | Engels |
| Certificaat van deelname: | Ja |
| Online toegang: | 365 dagen |
| Voortgangsbewaking: | Ja |
| Award Winning E-learning: | Ja |
| Geschikt voor mobiel: | Ja |
Help ons en andere klanten door het schrijven van een review