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
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
In this film we will show you how to improve the layout of a report by inserting changing back colors for rows.
In this film we will show you how to attach the formatting of controls to conditions.
Various Values in a Collapsed Combo Box
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.
We will show you in this film how to create and adapt relationships between tables when needed to create a query.
In this film we explain the three different join operations used to connect tables.
In this video we will show you how to easily find identical data sets using a wizard.
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
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
In this film you will learn how to keep your database small and consistent.
In this film we will show you how to convert databases from former Access versions into the Access 2007 format.
In this video we will show you how to easily carry out the documentation of a database by using the documenter.
In this film we will show you how to improve the performance of your database using the performance optimizer.
Table Analyzer Wizard
We introduce you to the Table Analyzer Wizard which is used to split redundant tables, copy data and build relationships between tables.
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
We will show you in this video how to secure your databse by encoding it and by using a password.
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.
In this film we will show you how to create an ACCDE database that prevents contained forms, reports and programmes from being modified.
In this video we compare macros and VBA programming and explain their advantages and disadvantages.
We will introduce you in this video to the macro editor which you can use to create your own macros.
In this video we will show you how to group similar actions in group macros.
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
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.
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.