Better in Access: Become a become a data hero

Language: German

Access course: Learn the basics & create a database - become a data pro!

Become a data manager with the Access system! In this course you will learn the basics and create your own database. In 7.5 hours, trainer René Fürst will show you the basic operation of Access, how to design databases and create reports and forms.

66 lessons in over 7.5 hours of video training on how to use Microsoft Access, including sample files
Basics: What is the program suitable for, how do you use it, what options does it offer?
Details explained in a practical way, including: Database design, using Excel tables, creating reports and forms
From IT professional René Fürst, who lets you keep track of even large databases

Smooth operations through smooth data management: Master Microsoft Access. This course is a plus for your CV and for working more efficiently in your company.

Details

Usable with:
content: 8 h Video training
Licence: private and commercial Rights of use
Bonus: including working material

Examples of use

Open gallery

Get to know Access and create your own databases.

Course introduction

free of charge

Better in Access: Become a data hero - 1.1 Intro

Welcome to the training course on database management with Microsoft Access.

download project file

free of charge

Better in Access: Become a data hero - 1.2 Access 2016 training: Agenda

An overview of the areas we cover in this course.

Better in Access: Become a data hero - 1.3 Access 2016: License

What licenses do you need to install Access on your PC?

Microsoft Access: Introduction

Better in Access: Become a data hero - 2.1 Access 2016: Examples

What can you do with Access 2016?

Better in Access: Become a data hero - 2.2 Access 2016: Interface

Familiarize yourself with the Access 2016 interface. Learn what is in which place.

Better in Access: Become a data hero - 2.3 My first database

We create our first own database in Access.

Better in Access: Become a data hero - 2.4 Create a sample table

We create our own employee list/address book.

Better in Access: Become a data hero - 2.5 data records for the employee list

We fill our employee list with data records.

Better in Access: Become a data hero - 2.6 Duplicating and deleting data records

How to duplicate and delete data records.

Better in Access: Become a data hero - 2.7 Searching, sorting and filtering data records

Search and sort data records and filter out specific information.

Better in Access: Become a data hero - 2.8 The first data set query

A small preview of what you can expect in Access. We also take a look at your first database query.

Database design

Better in Access: Become a data hero - 3.1 Normalization

What is "normalization" and what is it for?

Better in Access: Become a data hero - 3.2 Practical example: Sources of error in a table

Examples: Why a database design is important.

Better in Access: Become a data hero - 3.3 Brainstorming

We are working on the creation of a new database project and collecting ideas.

Better in Access: Become a data hero - 3.4 Relationship types

Learn how to create the links that are necessary in a database between the different task areas.

Better in Access: Become a data hero - 3.5 Hungarian notation - Prefix

What are prefixes used for and what types of prefixes are standard?

Better in Access: Become a data hero - 3.6 Camel and Pascal case (Camel and Pascal notation)

Get to know the different spellings for naming tables, queries, forms etc.

Better in Access: Become a data hero - 3.7 The primary key

What is the primary key used for and where is it used?

Better in Access: Become a data hero - 3.8 Indexing

Indexing the data records increases the speed of the database. Where does indexing make sense?

Working with tables

Better in Access: Become a data hero - 4.1 Create our limousine database

Let's create a new database for our limousine service.

Better in Access: Become a data hero - 4.2 Lookup reference table - Create zip code and city

To avoid mistakes as much as possible, we can use a look-up table.

Better in Access: Become a data hero - 4.3 Look up zip code and city

Learn to look up zip codes and places and display them beautifully.

Better in Access: Become a data hero - 4.4 Calculate VAT and concatenate calculated fields

Calculating VAT directly in Access is possible without much effort. Calculated fields can also be linked together nicely.

Better in Access: Become a data hero - 4.5 Unique car values with IDs

Learn what an auto-value is all about and why you should definitely use IDs.

Better in Access: Become a data hero - 4.6 Saving photos and documents in the database

Images and documents can also be saved in Access. Let's take a look inside.

Better in Access: Become a data hero - 4.7 Table relationships

We establish relationships and also the referential integrity between tables.

Importing Excel data

Better in Access: Become a data hero - 5.1 Importing zip codes from Austria

We import Excel data into our Access database. For this we have an Excel file with all zip codes from Austria.

Better in Access: Become a data hero - 5.2 Database re-modeling for German zip codes

When importing Excel data of German postal codes, we run into several problems. Learn how to fix problems to choose referential integrity.

Multiple choice questions

Better in Access: Become a data hero - 6.1 What is a query?

What is the purpose of queries in Access and why is it important to use them?

Better in Access: Become a data hero - 6.2 Creating the first query

We create our first query and read data from our new project.

Better in Access: Become a data hero - 6.3 Query criteria

Let's use queries with specific criteria to display only some of the data records.

Better in Access: Become a data hero - 6.4 Query with table relationships

Let's create a query that uses table relationships.

Better in Access: Become a data hero - 6.5 The OR criterion of a query

Use the OR criterion to display different data records.

Better in Access: Become a data hero - 6.6 Number criteria of a query

Criteria that deal with numbers can be displayed and filtered wonderfully. Let's take a look at some examples.

Better in Access: Become a data hero - 6.7 Prompt for a query

A query sometimes requires specific values. These can be queried via a prompt before the data records are displayed.

Better in Access: Become a data hero - 6.8 Query across multiple tables

Learn how to display queries across multiple tables.

Better in Access: Become a data hero - 6.9 Calculate customers with the most sales

Query sales and display only the peak values.

Better in Access: Become a data hero - 6.10 How many zip codes does a city have?

Grouping and summarizing values via a query.

Adjust properties

Better in Access: Become a data hero - 7.1 Access: Display options

What other options does Access offer us? We take a look at the settings for the display options.

Better in Access: Become a data hero - 7.2 Table properties

In addition to their columns and rows, tables also have general properties. We will now take a look at the options these offer.

Better in Access: Become a data hero - 7.3 Validity rules for table fields

We can also use Access to validate fields and assign special properties to them.

Better in Access: Become a data hero - 7.4 Query properties

In addition to the classic values, queries also have special properties that offer you further options.

Reports

Better in Access: Become a data hero - 8.1 What are reports? - Our first report

We create our first report and look at what reports do for us.

Better in Access: Become a data hero - 8.2 Modifying the report

In order to present the report attractively, we have to edit and modify it a little.

Better in Access: Become a data hero - 8.3 Finishing a report

We are working on the final details of the report and finalizing the report.

Better in Access: Become a data hero - 8.4 Report properties

To get to know all the functions of the reports, let's also take a look at the associated properties.

Forms

Better in Access: Become a data hero - 9.1 Create your first form with the wizard

We create our first form and take a look at what we can do with it.

Better in Access: Become a data hero - 9.2 Editing and customizing forms

We adapt our first form to our needs.

Better in Access: Become a data hero - 9.3 Formatting forms and adding rectangles

We design our form and clearly separate the individual areas.

Better in Access: Become a data hero - 9.4 Editing and finalizing headers and details

We take a look at the header and details of the forms.

Better in Access: Become a data hero - 9.5 Create combo box for lookup

We create a combo box in which we can look up values from other tables.

Better in Access: Become a data hero - 9.6 Arrange tab order

For keyboard input, it makes sense to adjust the order of the individual fields. This means we can simply jump to the next field using the tabulator.

Better in Access: Become a data hero - 9.7 Tabs in forms to save space

Extensive forms need good formatting that is also clear. We can achieve this with tabs. To do this, we create a new field and add a few tabs.

Better in Access: Become a data hero - 9.8 Calculate total amount

In forms, we can also perform calculations to actively see what happens when you enter data.

Better in Access: Become a data hero - 9.9 Continuous data records in the form

We look at the properties for consecutive data records so that we can display them clearly in a form.

Better in Access: Become a data hero - 9.10 Include subforms

Additional subforms can be integrated into a form. Here we take a look at this option and also pull data from the tables.

Better in Access: Become a data hero - 9.11 Task: Create customer list with booked seats

This is a task that you have to solve yourself. Based on the two previous lessons, you can now master this task and adapt the form accordingly.

Action queries

Better in Access: Become a data hero - 10.1 Update query

Our employees are assigned a salary. We change this salary via an update query and add a 5% salary increase.

Better in Access: Become a data hero - 10.2 Append query

Our customers become employees. We can read data from the customer table and add it to our personnel table.

Better in Access: Become a data hero - 10.3 Create a table with a query for analysis

With the "Create table" option of a query, we can create new tables for an analysis that we can save for a later time.

Better in Access: Become a data hero - 10.4 Delete query

As we have added our customers to the employees as a test, we can undo this again with a delete query.

Better in Access: Become a data hero - 10.5 Calculating queries and converting them with ZCurrency

Learn how to use functions. Using a calculation example with the ZCurrency function, we convert the output at the same time.

Conclusion

Better in Access: Become a data hero - 11.1 Linking Access tables

Access is also intended for a company's network. We also have the option of linking tables from the network.

Better in Access: Become a data hero - 11.2 Sensitization: Securing your data

I will sensitize you to back up your databases regularly to avoid data loss.

Better in Access: Become a data hero - 11.3 What's new in Access 2016?

It's not much, but we'll take a look at what's new in this short lesson.

Better in Access: Become a data hero - 11.4 Farewell

Thank you very much for attending this course. A few final words to say goodbye.

Details of the content

Learn Access and how to use it to create your own databases

Companies, whether small or large, generate a huge amount of data almost automatically. This is where Microsoft Access comes in and offers extremely practical solutions for data management . Using the functions, it is possible to organize complex and extensive databases in every respect. Rights management can also be used to determine who has access to which areas. All this without any programming knowledge!

So if you know how to use Access , you will add a considerable amount of expertise to your brain, your CV and your company, resulting in a better overview and more efficient (team) work . In this training course, IT professional René Fürst explains how to use Access - become a data pro!

A tutorial that takes you from the basics to your own database

In the 7.5-hour course with 66 video lessons , the database management system is looked at from the basics and then in detail . To begin with, you will receive an introduction to the interface, operation and working with data records. You will create your first database, duplicate, delete, search, sort and filter entries - practice is the focus of the course right from the start, making your learning a breeze .

About the course content

As databases should always be presented clearly so that the system is sustainable in the long term, a separate chapter is dedicated to the topic of database design . For example, you will learn how to create links, what is known as normalization and what the primary key is all about. Once you know how to work with tables and how to integrate Excel tables, it's time to delve into the finer Access details:

You use selection and action queries to read data and perform updates or calculations. For example, do employees get more pay? - No problem, because Access lets you add percentages without further ado. You can also generate reports and forms to compile data clearly and communicate with professionally and efficiently prepared business documents. You will find out how this works with Access in the training course.

To ensure that the theory goes straight to your head and stays there, the explanations are run through using practical examples. Employee and customer data, salaries, VAT ... Relevant for everyday office life! Exercises and sample files are also included.

What will you learn in the Access course?

You will learn how to use Microsoft Access and thus how to manage data . These skills will add another facet to your CV and provide companies with a much sought-after skill: structure and overview.