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
Customizing the Command Area | |
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 | |
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 | |
36-60 Min. |
|
In this film you will learn how to use the controls "Combo Box" and "List Box". | |
Creating Navigation Forms | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
6-10 Min. |
|
Learn how to use functions and expressions to filter the display of data effectively. | |
Using Criteria for Filtering | |
24-40 Min. |
|
In this film we will explain how to filter the display of records in queries using filter criteria. | |
Hide Duplicates | |
6-10 Min. |
|
In this film we will show you how to avoid the display of duplicates in queries. | |
Top Values | |
6-10 Min. |
|
In this film you will learn how to filter top values in queries. | |
Parameter Queries | |
18-30 Min. |
|
In this film we will show you how to create flexible queries by using query parameters. | |
Update Query | |
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 | |
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 | |
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 | |
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 | |
15-25 Min. |
|
In this video we will show you how to summarize and analyze data using Crosstab Queries. | |
Report Tools | |
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 | |
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 | |
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 | |
12-20 Min. |
|
In this video we will explain how to add calculations to reports. | |
PDF XPS | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
12-20 Min. |
|
In this video we will explain the summary functions in PivotTables. | |
Formatting PivotTables | |
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 | |
15-25 Min. |
|
In this video we will show you how to sort and group data in PivotTables. | |
Pivot Property Sheet | |
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 | |
18-30 Min. |
|
In this video we will show you how to create calculated fields in PivotTables. | |
Pivot Top 10 | |
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 | |
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 | |
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 | |
15-25 Min. |
|
In this video we will show you how to create your own navigation bar. | |
Startup Settings | |
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 | |
21-35 Min. |
|
In this film you will learn how to link files, web pages or Email addresses to your database. | |
You would like to use our Online-Service in your business?
Go to Corporate Orders..