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

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

An overview of the areas we cover in this course.

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

What can you do with Access 2016?

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

We create our first own database in Access.

We create our own employee list/address book.

We fill our employee list with data records.

How to duplicate and delete data records.

Search and sort data records and filter out specific information.

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

What is "normalization" and what is it for?

Examples: Why a database design is important.

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

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

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

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

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

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

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

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

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

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

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

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

We establish relationships and also the referential integrity between tables.

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

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

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

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

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

Let's create a query that uses table relationships.

Use the OR criterion to display different data records.

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

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

Learn how to display queries across multiple tables.

Query sales and display only the peak values.

Grouping and summarizing values via a query.

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

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

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

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

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

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

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

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

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

We adapt our first form to our needs.

We design our form and clearly separate the individual areas.

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

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

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.

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.

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

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

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

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.

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

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

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

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

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

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

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

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

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