In this film we will show you how to create an ACCDE database that prevents contained forms, reports and programmes from being modified.
Adding Data to the Database
4 Min.
In this video you will learn how to proceed when gathering information for your Access database.
Adding Tables
14 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
6 Min.
This video will show you how to add, delete and move fields in tables.
Adjust PivotCharts
4 Min.
In this video you will learn how to set the chart type for your analysis, how to add a title to the chart and how to apply other relevant graphical adjustments.
Aggregate Functions
8 Min.
In this film you will learn how to use aggregate functions in order to calculate and summarize values in queries.
Aggregate Functions in Forms
5 Min.
In this film we will explain how to summarize data in a form using aggregate functions. For example you can show the total value of displayed orders.
Alternating Row Colors
2 Min.
In this film we will show you how to improve the layout of a report, form or query by inserting changing back colors for rows.
Append Queries
3 Min.
In this film we will show you how to add data sets to a table by using Append Queries.
Attaching Forms as Subforms
3 Min.
In this film we will show you how to easily create a form with a subform using the drag & drop method. The same procedure can be applied to reports and subreports, too.
Autoform
3 Min.
In this video we will show you the quickest and easiest way to create a form.
Avoiding the Protected View
2 Min.
In this video we will show you how to avoid the Protected View when opening the example files downloaded from our website.
Button Control
7 Min.
In this video we will explain the control "Button Control" and we will show you how to start various actions in Access.
Calculated Fields
5 Min.
This video will show you how to add calculations to your queries.
Calculated Fields in PivotTables
6 Min.
In this video we will show you how to create calculated fields in PivotTables.
Calculating in Reports
4 Min.
In this video we will explain how to add calculations to reports.
Combo Box and List Box
12 Min.
In this film you will learn how to use the controls "Combo Box" and "List Box".
Compact & Repair Databases
3 Min.
In this film you will learn how to keep your database small and consistent.
Conditional Formatting
12 Min.
In this film we will show you how to attach the formatting of controls to conditions. The formatting options include back and font colors, font styles and data bars.
Converting Databases
3 Min.
In this film we will show you how to convert databases from former Access versions into the Access 2007 format. Since Access 2010 hasn't introduced a new format, the Access 2007 format is the most current format.
Create Your Own Tabs
8 Min.
In this video we will show you how to create your own tabs in the Office programs. You can thereby integrate your own macros and frequently used commands into the user interface.
Creating a Form
11 Min.
In this video we will show you how to create a form manually, from scratch.
Creating Charts
9 Min.
In this video you will learn how to create charts in order to visualize large amounts of numbers.
Creating Forms and Subforms Using the Wizard
4 Min.
In this film we will show you how to use the Form Wizard to easily create forms with subforms.
Creating Navigation Bars
5 Min.
In this video we will show you how to create your own navigation bar.
Creating Navigation Forms
5 Min.
In this video we will show you how to create a Navigation Form. A Navigation Form is a type of form designed to work as a navigation tool for forms and reports in your database. It is also the replacement of the Switchboard Manager.
Creating PivotCharts
6 Min.
In this video we will show you how to analyze data by using PivotCharts. You will learn how to create PivotCharts, how to choose chart types and how to adjust the chart settings.
Creating PivotTables
10 Min.
In this video we will show you how to analyse and evaluate data in Access by using PivotTables.
Creating Relationships
5 Min.
In this film we will show you how to create and adapt relationships between tables when needed to create a query.
Creating Reports Manually
10 Min.
In this video we will show you how to create customized reports by designing them step by step from scratch.
Creating Subforms with the Wizard
4 Min.
In this video you will learn how to connect forms that contain information from different tables by adding a subform to an existing form. The same procedure can be applied to reports and subreports.
Crosstab Queries
5 Min.
In this video we will show you how to summarize and analyze data using Crosstab Queries.
Customizing the Command Area
5 Min.
In this video we will show you how to add frequently used commands, or commands which are non-existent on the Ribbon, to the Quick Access toolbar. Additionally, you will learn how to minimize the Ribbon.
Data Types
8 Min.
In this film you will learn about the different data types which Access offers and what they are used for.
Database Relationships
5 Min.
In this video you will learn about the different kinds of relationships which are possilbe between tables in a database.
Delete Query
5 Min.
In this video we will show you how to create Delete Queries in order to delete large amounts of data with one single command.
Design Queries
4 Min.
In this video we will show you how to retrieve data from your Access database and how to analyse it by using queries.
Displaying the Developer Tools
2 Min.
In this video you will learn how to display the Developer Tools tab. There you have access to macros, to the VBA editor, and you can apply various controls such as checkboxes, list boxes and drop-down menus.
Documenter
4 Min.
In this video we will show you how to easily carry out the documentation of a database by using the documenter.
Dynamic Hyperlinks
9 Min.
In this video we will show you how to add dynamic hyperlinks to forms by using the Hyperlink Builder. This allows for hyperlinks to be divided into components that can change depending on data from your database.
Exclusive Mode
3 Min.
In this video you will learn about the exclusive mode. When using the exclusive mode, the database can be opened only by one user at a time.
Export Data
3 Min.
In this film you will learn how to export tables, reports or other database objects from a database in order to use them in other applications.
Expression Builder
9 Min.
This video will give you an introduction to the Expression Builder which you can use to create formulas and expressions.
File Types and Compatibility
3 Min.
In this video we will explain the various file types in Access 2007/2010 and older versions.
Filtering Data in the Datasheet View
6 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
6 Min.
We will show you in this video how to use a form based filter to display only certain data sets in a form.
Find Duplicates
4 Min.
In this video we will show you how to easily find identical data sets by using a wizard.
Form Templates
6 Min.
In this video we will explain how to create form templates. By using form templates you can quickly create new forms that are already formatted.
Form Views
5 Min.
In this video we explain the different Form Views and how to apply these views to your forms.
Form Wizard
3 Min.
In this video you will learn how to create a form by using the Form Wizard.
Formatting PivotTables
3 Min.
In this video we will show you how to format a PivotTable in order to display the results in a neat manner.
Forms with Headers and Footers
8 Min.
In this video we will show you how to insert headers and footers into a form.
Grouping and Sorting in Reports
8 Min.
In this video we will show you how to group and sort data in order to clearly structure reports.
Hide Duplicates
2 Min.
In this film we will show you how to avoid the display of duplicates in queries.
Hyperlinks
7 Min.
In this film you will learn how to link files, web pages or Email addresses to your database.
Importing and Linking Database Objects
6 Min.
In this film we will show you how to import and how to link tables, forms, queries or other database objects from other databases.
Indexes
6 Min.
In this film we will explain the term index and show you how to index columns.
Interactive Command Guide
3 Min.
In this video you will learn how to work with Microsofts Interactive Guide in order to comfortably and quickly find familiar commands from older versions in the new interface of Office 2010.
Introduction to PivotTables
4 Min.
In this video we give you an introduction to PivotTables and with the help of some examples show you what they are used for.
Introduction to Relational Databases
3 Min.
In this video we will outline and explain the terms "database" and "relational database" and show you what databases are used for.
Introduction to the Course
5 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.
Join Operations
5 Min.
In this film we explain the three different join operations used to connect tables.
Keyboard Shortcuts
4 Min.
This video will make you familiar with the keyboard shortcuts available in Microsoft Office. We will, in particular, introduce you to the shortcuts for the most common commands.
Label, Text Field, Image
10 Min.
In this video we will show you how to use the controls "Label", "Text Field" and "Image".
Macro Editor
5 Min.
In this video we will introduce you to the macro editor which you can use to create your own macros.
Make Table Query
4 Min.
In this video we will show you how to create new tables based on existing data using Make Table Queries.
Migrating to Access 2007 or later
5 Min.
There are a number of important factors to be taken into account when you change to the new version of Access. In this film we explain the main points and provide different solutions to create a multiuser environment in Access 2007 or later versions.
Navigation Menu
10 Min.
In this film you will learn how to manually create a navigation menu which is used to quickly access the most important database objects.
Novelties Access 2010
10 Min.
In this film we introduce the most significant features and changes in Access 2010. Novelties that came with the version 2007 are included in this video as well.
Object Dependencies
3 Min.
In this video we will show you how you can check object dependencies. Before deleting tables, forms or queries from your database it is highly recommended to check whether they are related to other database objects.
Option Groups and Buttons
8 Min.
In this video we will show you the controls "Toggle Button", "Option Field", "Check Box" and "Option Group".
Parameter Queries
6 Min.
In this film we will show you how to create flexible queries by using query parameters.
Password and Encryption
4 Min.
In this video we will show you how to secure your database by encoding it and by using a password. Databases encrypted in Access 2010 cannot be opened in Access 2007.
PDF XPS
4 Min.
In this video we will show you how to export database objects as PDF or XPS files. The PDF format is very useful, because of its small size and because it cannot be edited after it is saved.
Performance Optimization
3 Min.
In this film we will show you how to improve the performance of your database using the performance optimizer.
Pivot Property Sheet
3 Min.
In this video we will explain the Property Sheet in PivotTables which you can use to perform frequently used tasks.
Pivot Top 10
5 Min.
In this video we will show you how to filter the highest and lowest values in PivotTables quickly and easily.
Precision and Display of Numbers
10 Min.
In this film we explain the relation between a field data type and the precision of the displayed and saved values. Also we will show you how to adapt the displayed values for example to rounded values.
Primary Keys and Foreign Keys
6 Min.
In this video, you will learn how to assign a meaningful primary key to a table and what you need foreign keys for.
Printing Tables and Queries
5 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.
Program Options
3 Min.
You can change the behaviour and the look and feel of Access in many ways. In this film we show you how to change the program settings using some popular examples.
Programming Access
3 Min.
In this video we compare macros and VBA programming and explain their advantages and disadvantages.
Property Sheet
6 Min.
In this film we explain the properties window, where you can display and set various properties for objects, fields and other controls.
Queries on Queries
7 Min.
In this video we will show you how to create queries on queries in order to filter nested information.
Query Wizard
5 Min.
In this video you will learn how to create queries quickly and easily by using the query wizard.
Redundancy
2 Min.
In this video we will explain the terms "relational database" and "redundancy" to you.
Relationships
7 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.
Report Tools
6 Min.
Access offers various tabs containing commands and different views for creating and editing reports. In this video we will show you the different tabs and views and we will show you how to use them properly.
Report Wizard
6 Min.
In this video we will show you how to create reports using the Report Wizard.
Search for Data
8 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.
Setting an Input Mask
5 Min.
In this video you will learn how to create an input mask in order to control the data input in tables or forms.
Simple Macros
7 Min.
In this video we will show you how to create simple macros that can be run for example with a mouse click.
Sort and Group PivotTables
5 Min.
In this video we will show you how to sort and group data in PivotTables.
Sorting Data
3 Min.
In this video we will explain how to sort data in an ascending or descending way using different criteria.
Specifying Security Settings
9 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.
Splitting Databases
11 Min.
In this video we will explain the advantages of partitioning a database accessed by many users into a so-called Front End and Back End.
Startup Settings
4 Min.
In this film we will show you how to set a form to be opened automatically when a database is run.
Structure of Access Database
4 Min.
In this video you will learn about the structure of an Access database and you will be introduced to its objects.
Summary Functions in PivotTables
4 Min.
In this video we will explain the summary functions in PivotTables.
Switchboard Manager
10 Min.
In this film we will introduce you to the Switchboard Manager which is used to create a personalized navigation menu. The database user can access all important forms and reports via this navigation menu.
Tab Order
3 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.
Table Analyzer Wizard
12 Min.
In this video we introduce you to the Table Analyzer Wizard which is used to split redundant tables, copy data and build relationships between tables.
The Lookup Function
8 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.
The new User Interface
6 Min.
In this video we explain the new User Interface of Microsoft Access 2010 and show you the differences to older versions.
Top Values
2 Min.
In this film you will learn how to filter top values in queries.
Update Query
4 Min.
In this film we explain how to create an Update Query in order to quickly update large amounts of data in tables.
User Interface
7 Min.
In this film, we introduce the workspace, the ribbon and other important elements of the user interface in Access 2010.
Using Access Keys
4 Min.
This video will show you how to use access keys in Office 2010. By using access keys on your keyboard you can perform all commands from the Ribbon without undertaking long operation sequences with your mouse.
Using Application Parts
8 Min.
In this video we will show you what Application Parts are and how to create them.
Using Controls
4 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.
Using Criteria for Filtering
8 Min.
In this film we will explain how to filter the display of records in queries using filter criteria.
Using Formulas as Filter Criteria
2 Min.
Learn how to use functions and expressions to filter the display of data effectively.
Using Submacros
6 Min.
In this video we will show you how to use Submacros and how to bundle actions within a macro into a group.
Using Tab Controls
6 Min.
In this video we will explain the Tab control and show you how to create your own tabs.
Using the Clipboard
5 Min.
This video will introduce you to the Office clipboard which is used to copy and insert objects into documents across the different programs.
Using the Help Function
6 Min.
This video will show you how to use the help function in Office.
Validation Rules
8 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.
Various Values in a Collapsed Combo Box
6 Min.
In this film we will show you how to adapt the display in a Combo Box to show more than one value at once, even when it is collapsed.
Subscription Range:
A subscription incorporates all the versions and course levels available for the product!
Subscription Term/Cancellation:
Your subscription ends automatically at the end of 12 months so cancellation is not necessary.
Subscription Extension:
An extension for a further year costs only 50% of the initial license fee.
Payment and Access:
On payment by the payment methods listed below the login data is sent to you immediately. On payment via normal bank transfer the login data is sent to you upon receipt of payment.
Use these payment methods and start immediately!
You would like to use our Online-Service in your business?
Home
Online Help
