Username:  
Password:  

Online Course: Access 2007 Expert

Are you looking for further hints concerning Access? Use conditional formatting, create relationships, export data, compact and repair your database. This Access tutorial 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: 3 - 5 hours
= free Demo       = just released       = already seen
Title of Film Length Info
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.
Alternating Row Colors 2 Min.
In this film we will show you how to improve the layout of a report by inserting changing back colors for rows.
Conditional Formatting 7 Min.
In this film we will show you how to attach the formatting of controls to conditions.
Various Values in a Collapsed Combo Box 6 Min.
We will show you in this film how to adapt the display in a combo box to show more than one value at once, even when it is collapsed.
Creating Relationships 4 Min.
We will show you in this film how to create and adapt relationships between tables when needed to create a query.
Join Operations 5 Min.
In this film we explain the three different join operations used to connect tables.
Find Duplicates 3 Min.
In this video we will show you how to easily find identical data sets using a wizard.
Export Data 2 Min.
You will learn in this film how to export tables, reports or other database objects from a database to use them in other applications.
Importing and Linking Database Objects 5 Min.
In this film we will show you how to import tables, forms, queries or other database objects from other databases and how to link them with another database.
Compact & Repair DBs 2 Min.
In this film you will learn how to keep your database small and consistent.
Converting Databases 2 Min.
In this film we will show you how to convert databases from former Access versions into the Access 2007 format.
Documenter 4 Min.
In this video we will show you how to easily carry out the documentation of a database by using the documenter.
Performance Optimization 2 Min.
In this film we will show you how to improve the performance of your database using the performance optimizer.
Table Analyzer Wizard 12 Min.
We introduce you to the Table Analyzer Wizard which is used to split redundant tables, copy data and build relationships between tables.
Exclusive Mode 3 Min.
In this video you will learn about the exclusive mode. Using the exclusive mode, the database can be opened only by one user at a time.
Password and Encryption 4 Min.
We will show you in this video how to secure your databse by encoding it and by using a password.
Splitting Databases 9 Min.
In this video we will explain the advantages of partitioning a databases accessed by many users into a so-called Front End and Back End.
ACCDE Databases 3 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 3 Min.
In this video we compare macros and VBA programming and explain their advantages and disadvantages.
Macro Editor 5 Min.
We will introduce you in this video to the macro editor which you can use to create your own macros.
Group Macros 3 Min.
In this video we will show you how to group similar actions in group macros.
Simple Macros 7 Min.
We will show you in this video how to create simple macros that can be run for example with a mouse click.
Display the Developer Tools Tab 2 Min.
In this video you will learn how to display the developer tools tab. This tool gives you access to macros, the VBA editor and to several control features such as check boxes, list and drop-down boxes and others.
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 of the popular examples.
back to top
 

 

switch to Online-Help..



Watch Sample Movie




One year
excellent support
eg. Access:

all Online Courses,
(from Beginner to Expert)
Online-Help,
Special Topics
only 79.90 EUR
Buy now..   



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!
Secure Payment Processing with Worldpay Secure Payment Processing with Worldpay
Secure Payment Processing with Worldpay Secure Payment Processing with Worldpay Secure Payment Processing with Worldpay
Secure Payment Processing with Worldpay
Secure Payments by PayPal SOFORT Banking - Fast & Secure.


You would like to use our Online-Service in your business?

Go to Corporate Orders..

   Feedback/Suggestions
Confirm

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