Online lernen
Software & Programmieren
Access 2016 - Beginner (EN)

Entdecken Sie, was
Sie lernen können.

Mit Videokursen für Beruf, Studium und Freizeit.

Überall verfügbar
Lernen Sie am PC oder mobil auf Tablet oder Smartphone.

Tempo

Eigenes Lerntempo
Wiederholen Sie, sooft Sie wollen.

Schneller Lernerfolg
Lernvideos, Übungen und Quizfragen bringen Sie ans Ziel.

Access 2016 - Beginner (EN)

Von Sonic Performance

A relational database application such as Microsoft Office Access 2016 can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization. In this course, you will use Access 2016 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data. Using Access is a wise decision when you have to manage a lot of data. Maybe you already tried and found out that especially the first steps can be complicated. In this basic course you will learn how you to create databases, to understand relationships between databases and how to establish them. These first steps will enable you to perform queries on a database and create reports.

Course Prerequisites:

To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites.

Course Objectives:

In this course, you will create and manage an Access 2016 database.

Navigate within the Microsoft Access application environment, create a simple database, and customize Access configuration options.
Organize and manage data stored within Access tables.
Use queries to join, sort, and filter data from different tables.
Use forms to make it easier to view, access, and input data.
Create and format custom reports.

Inhalte

Getting Started with Access (EN)

Course Overview: Access 2016 - Beginner (EN)	03:01
Getting Started with Access 2016	03:04
Orientation to Access	04:28
Differences between Access and Excel	02:20
How to Navigate Tables	03:56
Navigating and Editing Data in Forms	02:05
Understanding Relational Databases	03:42
Create Queries in Access	01:32
Using Queries in Access	01:50
Using Reports in Access	02:28
Creating a New Database	06:56
Getting Help in Creating Queries	05:12
How to Configure Options in Access	06:03
Quiz zum Kurs „Getting Started with Access (EN)“

Working with Table Data (EN)

Introduction to Working with Table Data	00:57
How to Record Modifications	02:45
Using Quick Search to Find and Modify Records	02:30
How to Find and Replace Data in Access	03:05
Introduction to Asking Questions to a Table	00:34
Adding a Totals Row to a Datasheet	01:55
Sorting and Filtering Records	04:27
Quiz zum Kurs „Working with Table Data (EN)“

Querying a Database (EN)

Introduction to Querying a Database	01:25
How to use the Query Wizard	03:41
How to use Query Design	03:28
Using Comparison Operator	03:05
Using a Wildcard	04:03
Using a Date Range	03:00
How to Sort Records in a Query	01:53
Performing Calculations in a Query	03:05
Quiz zum Kurs „Querying a Database (EN)“

Using Forms (EN)

Introduction to Using Forms	01:09
Creating and Testing a Form	04:29
How to View and Change Data in a Form	04:35
Introduction to Working with Properties	01:02
How to Set Form Properties	03:40
Configuring a Form Lookup Field	06:36
Quiz zum Kurs „Using Forms (EN)“

Generating Reports (EN)

Introduction to Creating a Report	01:59
How to Create a Report	02:47
Using the Report Wizard	03:30
Adjusting the Report Control Layout	07:53
How to Enhance the Appearance of a Report	03:29
Preparing a Report for Print	02:20
Reporting Modifications	06:51
How to Format a Report	10:23
Follow-Up: Access 2016 - Beginner (EN)	02:10
Quiz zum Kurs „Generating Reports (EN)“

Quiz zum Kurs „Access 2016 - Beginner (EN)“

Details

Enthaltene Vorträge: 43
Laufzeit: 2:29 h
Enthaltene Quizfragen: 16
Enthaltene Lernmaterialien: 5

Rezensionen

(1)
5,0 von 5 Sternen

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