Online Course: Access 2010 Beginner

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

=free      =new      =seen
Introduction to the Course
LernFilm starten

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
LernFilm starten
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
LernFilm starten
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
LernFilm starten
8-12 Min.  
In this video you will learn how to proceed when gathering information for your Access database.
Redundancy
LernFilm starten
4-6 Min.  
In this video we will explain the terms "relational database" and "redundancy" to you.
Primary Keys and Foreign Keys
LernFilm starten
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
LernFilm starten
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
LernFilm starten
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
LernFilm starten
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
LernFilm starten
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
LernFilm starten
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
LernFilm starten
18-30 Min.  
This video will show you how to add, delete and move fields in tables.
Setting an Input Mask
LernFilm starten
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
LernFilm starten
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
LernFilm starten
18-30 Min.  
In this film we will explain the term index and show you how to index columns.
Relationships
LernFilm starten
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
LernFilm starten

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
LernFilm starten

15-25 Min.  
In this video you will learn how to create queries quickly and easily by using the query wizard.
Queries on Queries
LernFilm starten
21-35 Min.  
In this video we will show you how to create queries on queries in order to filter nested information.
Calculated Fields
LernFilm starten
15-25 Min.  
This video will show you how to add calculations to your queries.
Expression Builder
LernFilm starten

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
LernFilm starten
24-40 Min.  
In this film you will learn how to use aggregate functions in order to calculate and summarize values in queries.
Autoform
LernFilm starten
9-15 Min.  
In this video we will show you the quickest and easiest way to create a form.
Form Wizard
LernFilm starten
9-15 Min.  
In this video you will learn how to create a form by using the Form Wizard.
Form Views
LernFilm starten
15-25 Min.  
In this video we explain the different Form Views and how to apply these views to your forms.
Creating a Form
LernFilm starten
33-55 Min.  
In this video we will show you how to create a form manually, from scratch.
Forms with Headers and Footers
LernFilm starten
24-40 Min.  
In this video we will show you how to insert headers and footers into a form.
Tab Order
LernFilm starten
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
LernFilm starten
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
LernFilm starten
30-50 Min.  
In this video we will show you how to use the controls "Label", "Text Field" and "Image".
Option Groups and Buttons
LernFilm starten
24-40 Min.  
In this video we will show you the controls "Toggle Button", "Option Field", "Check Box" and "Option Group".
Using Tab Controls
LernFilm starten
18-30 Min.  
In this video we will explain the Tab control and show you how to create your own tabs.
Button Control
LernFilm starten
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
LernFilm starten
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
LernFilm starten
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
LernFilm starten
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
LernFilm starten
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
LernFilm starten
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
LernFilm starten
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
LernFilm starten

18-30 Min.  
In this video we will show you how to create reports using the Report Wizard.
Using the Clipboard
LernFilm starten
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
LernFilm starten
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
LernFilm starten
12-18 Min.  
This video will show you how to use the help function in Office.
back to top
Confirm

This site uses cookies. By visiting this website you agree to the use of cookies. More on this..