Online Course: Access 2010 Advanced

In our advanced Access course you will learn how to use Access efficiently for your daily work. We explain how to use special controls and subforms to allow a comfortable and clear data maintenance. Additionally we will show you how to create queries and how to include parameters, filter criteria, formulas and expressions in queries in order to perform various tasks. Learn how to create reports and how to analyze your data using Pivot Tables.

Course Duration: 7-11 hours

=free      =new      =seen
Customizing the Command Area
LernFilm starten
10-15 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.
Precision and Display of Numbers
LernFilm starten
30-50 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.
Combo Box and List Box
LernFilm starten
36-60 Min.  
In this film you will learn how to use the controls "Combo Box" and "List Box".
Creating Navigation Forms
LernFilm starten
15-25 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.
Navigation Menu
LernFilm starten
30-50 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.
Creating Forms and Subforms Using the Wizard
LernFilm starten

12-20 Min.  
In this film we will show you how to use the Form Wizard to easily create forms with subforms.
Creating Subforms with the Wizard
LernFilm starten
12-20 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.
Attaching Forms as Subforms
LernFilm starten
9-15 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.
Property Sheet
LernFilm starten
18-30 Min.  
In this film we explain the properties window, where you can display and set various properties for objects, fields and other controls.
Using Formulas as Filter Criteria
LernFilm starten
6-10 Min.  
Learn how to use functions and expressions to filter the display of data effectively.
Using Criteria for Filtering
LernFilm starten
24-40 Min.  
In this film we will explain how to filter the display of records in queries using filter criteria.
Hide Duplicates
LernFilm starten
6-10 Min.  
In this film we will show you how to avoid the display of duplicates in queries.
Top Values
LernFilm starten
6-10 Min.  
In this film you will learn how to filter top values in queries.
Parameter Queries
LernFilm starten
18-30 Min.  
In this film we will show you how to create flexible queries by using query parameters.
Update Query
LernFilm starten
12-20 Min.  
In this film we explain how to create an Update Query in order to quickly update large amounts of data in tables.
Delete Query
LernFilm starten
15-25 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.
Append Queries
LernFilm starten
9-15 Min.  
In this film we will show you how to add data sets to a table by using Append Queries.
Make Table Query
LernFilm starten
12-20 Min.  
In this video we will show you how to create new tables based on existing data using Make Table Queries.
Crosstab Queries
LernFilm starten
15-25 Min.  
In this video we will show you how to summarize and analyze data using Crosstab Queries.
Report Tools
LernFilm starten
12-18 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.
Creating Reports Manually
LernFilm starten
30-50 Min.  
In this video we will show you how to create customized reports by designing them step by step from scratch.
Grouping and Sorting in Reports
LernFilm starten
24-40 Min.  
In this video we will show you how to group and sort data in order to clearly structure reports.
Calculating in Reports
LernFilm starten
12-20 Min.  
In this video we will explain how to add calculations to reports.
PDF XPS
LernFilm starten
8-12 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.
Creating Charts
LernFilm starten
27-45 Min.  
In this video you will learn how to create charts in order to visualize large amounts of numbers.
Aggregate Functions in Forms
LernFilm starten

15-25 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.
Form Templates
LernFilm starten
12-18 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.
Introduction to PivotTables
LernFilm starten
8-12 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.
Creating PivotTables
LernFilm starten
30-50 Min.  
In this video we will show you how to analyse and evaluate data in Access by using PivotTables.
Summary Functions in PivotTables
LernFilm starten
12-20 Min.  
In this video we will explain the summary functions in PivotTables.
Formatting PivotTables
LernFilm starten
9-15 Min.  
In this video we will show you how to format a PivotTable in order to display the results in a neat manner.
Sort and Group PivotTables
LernFilm starten
15-25 Min.  
In this video we will show you how to sort and group data in PivotTables.
Pivot Property Sheet
LernFilm starten
9-15 Min.  
In this video we will explain the Property Sheet in PivotTables which you can use to perform frequently used tasks.
Calculated Fields in PivotTables
LernFilm starten
18-30 Min.  
In this video we will show you how to create calculated fields in PivotTables.
Pivot Top 10
LernFilm starten
15-25 Min.  
In this video we will show you how to filter the highest and lowest values in PivotTables quickly and easily.
Creating PivotCharts
LernFilm starten
18-30 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.
Adjust PivotCharts
LernFilm starten
12-20 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.
Creating Navigation Bars
LernFilm starten
15-25 Min.  
In this video we will show you how to create your own navigation bar.
Startup Settings
LernFilm starten
12-20 Min.  
In this film we will show you how to set a form to be opened automatically when a database is run.
Hyperlinks
LernFilm starten
21-35 Min.  
In this film you will learn how to link files, web pages or Email addresses to your database.
back to top
Confirm

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