Online Course: Access 2010 Expert

Are you looking for further hints concerning Access? Use conditional formatting, create relationships, export data, compact and repair your database. This Access course for experts will show you how it’s done. Learn more about documentation, performance analysis, the table analysis wizard, password and encryption and get to know the advantages of splitting a database into Front End and Back End.

Course Duration: 5-7 hours

=free      =new      =seen
Dynamic Hyperlinks
LernFilm starten
27-45 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.
Using Access Keys
LernFilm starten
8-12 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.
Create Your Own Tabs
LernFilm starten
16-24 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.
Object Dependencies
LernFilm starten
6-9 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.
Alternating Row Colors
LernFilm starten
6-10 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.
Conditional Formatting
LernFilm starten

36-60 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.
Various Values in a Collapsed Combo Box
LernFilm starten
18-30 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.
Creating Relationships
LernFilm starten
15-25 Min.  
In this film we will show you how to create and adapt relationships between tables when needed to create a query.
Join Operations
LernFilm starten
15-25 Min.  
In this film we explain the three different join operations used to connect tables.
Find Duplicates
LernFilm starten
12-20 Min.  
In this video we will show you how to easily find identical data sets by using a wizard.
Export Data
LernFilm starten
9-15 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.
Importing and Linking Database Objects
LernFilm starten
12-18 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.
Compact & Repair Databases
LernFilm starten
6-9 Min.  
In this film you will learn how to keep your database small and consistent.
Converting Databases
LernFilm starten
6-9 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.
Documenter
LernFilm starten
12-20 Min.  
In this video we will show you how to easily carry out the documentation of a database by using the documenter.
Performance Optimization
LernFilm starten
6-9 Min.  
In this film we will show you how to improve the performance of your database using the performance optimizer.
Table Analyzer Wizard
LernFilm starten
36-60 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.
Exclusive Mode
LernFilm starten
6-9 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.
Password and Encryption
LernFilm starten
8-12 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.
Using Application Parts
LernFilm starten
24-40 Min.  
In this video we will show you what Application Parts are and how to create them.
Splitting Databases
LernFilm starten

33-55 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.
ACCDE Databases
LernFilm starten

6-9 Min.  
In this film we will show you how to create an ACCDE database that prevents contained forms, reports and programmes from being modified.
Programming Access
LernFilm starten
6-9 Min.  
In this video we compare macros and VBA programming and explain their advantages and disadvantages.
Macro Editor
LernFilm starten
15-25 Min.  
In this video we will introduce you to the macro editor which you can use to create your own macros.
Using Submacros
LernFilm starten
12-18 Min.  
In this video we will show you how to use Submacros and how to bundle actions within a macro into a group.
Simple Macros
LernFilm starten
21-35 Min.  
In this video we will show you how to create simple macros that can be run for example with a mouse click.
Displaying the Developer Tools
LernFilm starten
4-6 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.
Program Options
LernFilm starten
6-9 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.
back to top
Confirm

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