Entdecken Sie, was Sie lernen können.

Mit Videokursen für Beruf, Studium und Freizeit.

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

play symbol Course Overview: Access 2016 - Beginner (EN)
03:01
lecture locked Getting Started with Access 2016
03:04
lecture locked Orientation to Access
04:28
lecture locked Differences between Access and Excel
02:20
lecture locked How to Navigate Tables
03:56
lecture locked Navigating and Editing Data in Forms
02:05
lecture locked Understanding Relational Databases
03:42
lecture locked Create Queries in Access
01:32
lecture locked Using Queries in Access
01:50
lecture locked Using Reports in Access
02:28
lecture locked Creating a New Database
06:56
lecture locked Getting Help in Creating Queries
05:12
lecture locked How to Configure Options in Access
06:03
Quiz zum Kurs „Getting Started with Access (EN)“
play symbol Introduction to Working with Table Data
00:57
lecture locked How to Record Modifications
02:45
lecture locked Using Quick Search to Find and Modify Records
02:30
lecture locked How to Find and Replace Data in Access
03:05
lecture locked Introduction to Asking Questions to a Table
00:34
lecture locked Adding a Totals Row to a Datasheet
01:55
lecture locked Sorting and Filtering Records
04:27
Quiz zum Kurs „Working with Table Data (EN)“
play symbol Introduction to Querying a Database
01:25
lecture locked How to use the Query Wizard
03:41
lecture locked How to use Query Design
03:28
lecture locked Using Comparison Operator
03:05
lecture locked Using a Wildcard
04:03
lecture locked Using a Date Range
03:00
lecture locked How to Sort Records in a Query
01:53
lecture locked Performing Calculations in a Query
03:05
Quiz zum Kurs „Querying a Database (EN)“
play symbol Introduction to Using Forms
01:09
lecture locked Creating and Testing a Form
04:29
lecture locked How to View and Change Data in a Form
04:35
lecture locked Introduction to Working with Properties
01:02
lecture locked How to Set Form Properties
03:40
lecture locked Configuring a Form Lookup Field
06:36
Quiz zum Kurs „Using Forms (EN)“
play symbol Introduction to Creating a Report
01:59
lecture locked How to Create a Report
02:47
lecture locked Using the Report Wizard
03:30
lecture locked Adjusting the Report Control Layout
07:53
lecture locked How to Enhance the Appearance of a Report
03:29
lecture locked Preparing a Report for Print
02:20
lecture locked Reporting Modifications
06:51
lecture locked How to Format a Report
10:23
lecture locked 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


Dozenten des Kurses Access 2016 - Beginner (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