In this online course for upgraders we support you in your transition to Access 2016. We explain the new user interface and tell you which new program features are available and how to use them. This course is intended for users who want to gain an overview quickly and are planning to use our online help to get targeted solutions for specific program features. To learn how to work with Access in general, please refer to our online courses for Access 2010.
Course Duration: 3 - 4 hours
= free Demo = just released = already seen
Title of Film
Information on the Course
In this video you will get important information on how to work with this upgrader course.
Access 2016 Novelties
In this film we introduce the most significant features and changes in Access 2016.
Exporting linked data sources
Complex databases often contain links to many external data sources. In order to get an overview of all sources linked to your database, you can export them to an Excel workbook in just a few steps.
Access 2013 Novelties
In this film we introduce the most significant features and changes in Access 2013.
Office 2013 User Interface
In this video we will familiarize you with the new user interface of Office 2013. You will learn how to work with the ribbon and all the other important new features.
Novelties Access 2010
In this film we introduce the most significant features and changes in Access 2010. Novelties that came with the version 2007 are included in this video as well.
The new User Interface
In this video we explain the new User Interface of Microsoft Access 2010 and show you the differences to older versions.
Migrating to Access 2007 or later
There are a number of important factors to be taken into account when you change to the new version of Access. In this film we explain the main points and provide different solutions to create a multiuser environment in Access 2007 or later versions.
File Types and Compatibility
In this video we will explain the various file types in Access 2007/2010 and older versions.
In this video we explain the different Form Views and how to apply these views to your forms.
Filtering Data in the Datasheet View
In this video you will learn how to filter data in tables, queries and forms using the Datasheet View. You can use various filters for texts, numbers or dates.
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
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
In this video we will show you how to group and sort data in order to clearly structure reports.
In this video we will introduce you to the Protected View, a new security feature of the Office 2013 programs. Depending on your environment, the basic settings are more or less useful. We will show you how to adjust them without compromising your safety.
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.
Customizing the Command Area
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.
Create Your Own Tabs
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.
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.
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.
Creating Navigation Forms
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.
Using Application Parts
In this video we will show you what Application Parts are and how to create them.