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: 12 - 21 hours
= free Demo = just released = already seen
Title of Film
Introduction to the Course
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.
Introduction to Relational Databases
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
In this video you will learn how to proceed when gathering information for your Access database.
In this video we will explain the terms "relational database" and "redundancy" to you.
Primary Keys and Foreign Keys
In this video, you will learn how to assign a meaningful primary key to a table and what you need foreign keys for.
In this video you will learn about the different kinds of relationships which are possilbe between tables in a database.
In this film you will learn about the different data types which Access offers and what they are used for.
Structure of Access Database
In this video you will learn about the structure of an Access database and get introduced to its objects.
In this film, we introduce the workspace, the ribbon and other important elements of the user interface in Access 2007.
In this video we will show you how to create tables, define the field data type and add data to the table.
Adding, Moving, Erasing Fields
This video will show you how you can add, delete and move fields in tables.
Setting an Input Mask
In this video you will learn how to create an input mask in order to control the data input in tables or forms.
In this film we show how to define rules that check the user's data entry on its validity. You will learn how to setup validation rules either on fields or on data sets.
In this film we will explain the term index and show you how to index columns.
This video 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 deletions of records.
This video will show you how to retrieve data from your Access database and how to analyse them by using queries.
In this video you will learn how to create queries quickly and easily by using the query wizard.
Queries on Queries
In this video, we will show you how to create queries on queries in order to filter nested information.
This video will show you how to add calculations to your queries.
This video will give you an introduction on the Expression Builder which you can use to create formulas and expressions.
In this film you will learn how to use aggregate functions to calculate and summarize values in queries.
In this video we will show you the quickest and easiest way to create a form.
In this video you will learn how to create a form using the Form Wizard.
In this video we explain the different form views and how to apply these views to your forms.
Creating a Form
In this video we will show you how to create a form manually, from scratch.
Forms with Headers and Footers
We will show you in this video how to insert headers and footers into a form.
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.
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
In this video we will show you how to use the controls "Label","Text field" and "Image".
Option Groups and Buttons
In this video we will show you the controls "Toggle Button", "Option Field", "Check Box" and "Option Group".
Using Tab Controls
In this video we will explain the tab control and show you how to create your own tabs.
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
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
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.
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
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
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
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.
In this video we will show you how to create reports using the report wizard.
Using the Clipboard
This video explains the Office clipboard which is used to copy and insert objects into documents across the different Office programs.
Using the Help Function
This video will show you how to use the help function in Office.
Specifying Security Settings
This video will show you how to adjust the security settings in Office 2007 by using the trust center. We will explain how you can block macros and Active X controls and how to find the optimal setting.