This Access course for beginners explains how to create and administer databases. Learn the basics about data types, tables and queries, how to use validation rules, indexes and relationships and how to create forms for the entry and maintenance of data. Apart from that we explain how to use aggregate functions, calculated fields and filtering and sorting criteria for the evaluation and analysis of your data.
Course Duration: 9-13 hours
Introduction to the Course | |
10-15 Min. |
|
In this video you will get important information about how to work with our course and which settings you need to apply before starting to work with it. In addition you will learn how to work with the sample files. | |
Avoiding the Protected View | |
4-6 Min. |
|
In this video we will show you how to avoid the Protected View when opening the example files downloaded from our website. | |
Introduction to Relational Databases | |
6-9 Min. |
|
In this video we will outline and explain the terms "database" and "relational database" and show you what databases are used for. | |
Adding Data to the Database | |
8-12 Min. |
|
In this video you will learn how to proceed when gathering information for your Access database. | |
Redundancy | |
4-6 Min. |
|
In this video we will explain the terms "relational database" and "redundancy" to you. | |
Primary Keys and Foreign Keys | |
12-18 Min. |
|
In this video, you will learn how to assign a meaningful primary key to a table and what you need foreign keys for. | |
Database Relationships | |
10-15 Min. |
|
In this video you will learn about the different kinds of relationships which are possilbe between tables in a database. | |
Data Types | |
16-24 Min. |
|
In this film you will learn about the different data types which Access offers and what they are used for. | |
Structure of Access Database | |
8-12 Min. |
|
In this video you will learn about the structure of an Access database and you will be introduced to its objects. | |
User Interface | |
14-21 Min. |
|
In this film, we introduce the workspace, the ribbon and other important elements of the user interface in Access 2010. | |
Adding Tables | |
28-42 Min. |
|
In this video we will show you how to create tables, define field data types and add data to the table. | |
Adding, Moving, Erasing Fields | |
18-30 Min. |
|
This video will show you how to add, delete and move fields in tables. | |
Setting an Input Mask | |
15-25 Min. |
|
In this video you will learn how to create an input mask in order to control the data input in tables or forms. | |
Validation Rules | |
24-40 Min. |
|
This film will show you how to define rules that check the user's data entry on its validity. You will learn how to setup validation rules both on fields and on data sets. | |
Indexes | |
18-30 Min. |
|
In this film we will explain the term index and show you how to index columns. | |
Relationships | |
21-35 Min. |
|
In this video we will show you how to create relationships between tables. Additionally we will familiarize you with the term referential integrity and the cascading of updates and deletion of records. | |
Design Queries | |
12-20 Min. |
|
In this video we will show you how to retrieve data from your Access database and how to analyse it by using queries. | |
Query Wizard | |
15-25 Min. |
|
In this video you will learn how to create queries quickly and easily by using the query wizard. | |
Queries on Queries | |
21-35 Min. |
|
In this video we will show you how to create queries on queries in order to filter nested information. | |
Calculated Fields | |
15-25 Min. |
|
This video will show you how to add calculations to your queries. | |
Expression Builder | |
27-45 Min. |
|
This video will give you an introduction to the Expression Builder which you can use to create formulas and expressions. | |
Aggregate Functions | |
24-40 Min. |
|
In this film you will learn how to use aggregate functions in order to calculate and summarize values in queries. | |
Autoform | |
9-15 Min. |
|
In this video we will show you the quickest and easiest way to create a form. | |
Form Wizard | |
9-15 Min. |
|
In this video you will learn how to create a form by using the Form Wizard. | |
Form Views | |
15-25 Min. |
|
In this video we explain the different Form Views and how to apply these views to your forms. | |
Creating a Form | |
33-55 Min. |
|
In this video we will show you how to create a form manually, from scratch. | |
Forms with Headers and Footers | |
24-40 Min. |
|
In this video we will show you how to insert headers and footers into a form. | |
Tab Order | |
9-15 Min. |
|
In this video we will show you how to match the order in which the fields in your form are activated with the order in which the fields are displayed. | |
Using Controls | |
12-20 Min. |
|
In this video we will give you a short overview of the available controls in Access and we will show you some important settings for using these controls. | |
Label, Text Field, Image | |
30-50 Min. |
|
In this video we will show you how to use the controls "Label", "Text Field" and "Image". | |
Option Groups and Buttons | |
24-40 Min. |
|
In this video we will show you the controls "Toggle Button", "Option Field", "Check Box" and "Option Group". | |
Using Tab Controls | |
18-30 Min. |
|
In this video we will explain the Tab control and show you how to create your own tabs. | |
Button Control | |
21-35 Min. |
|
In this video we will explain the control "Button Control" and we will show you how to start various actions in Access. | |
The Lookup Function | |
24-40 Min. |
|
In this video you will learn how to use the lookup function in Access. We will show you how to adjust the search settings and how to set your personal settings to be default settings. | |
Search for Data | |
24-40 Min. |
|
We introduce you to the "Search for Data" function which gives you the possibility to simply choose information when searching for data instead of having to enter it. | |
Sorting Data | |
9-15 Min. |
|
In this video we will explain how to sort data in an ascending or descending way using different criteria. | |
Filtering Data in the Datasheet View | |
18-30 Min. |
|
In this video you will learn how to filter data in tables, queries and forms using the Datasheet View. You can use various filters for texts, numbers or dates. | |
Filtering in Forms | |
18-30 Min. |
|
We will show you in this video how to use a form based filter to display only certain data sets in a form. | |
Printing Tables and Queries | |
10-15 Min. |
|
Usually it is recommended to print reports if you want to print data from a database. In this video we will show you how you can adapt your print settings to print tables or queries. | |
Report Wizard | |
18-30 Min. |
|
In this video we will show you how to create reports using the Report Wizard. | |
Using the Clipboard | |
10-15 Min. |
|
This video will introduce you to the Office clipboard which is used to copy and insert objects into documents across the different programs. | |
Specifying Security Settings | |
18-27 Min. |
|
This video will show you how to adjust the security settings in Office 2010 by using the trust center. We will explain how you can block macros and Active X controls and how to define the optimal settings. | |
Using the Help Function | |
12-18 Min. |
|
This video will show you how to use the help function in Office. | |
You would like to use our Online-Service in your business?
Go to Corporate Orders..