Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Learn Microsoft Access 2010 -The Expert Training- to your Wishlist.

Add to Wishlist

Learn Microsoft Access 2010 -The Expert Training-

Are you looking for further hints concerning Access? This Access course for experts will show you how it’s done.
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
20 students enrolled
$15 $45 67% off
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 15 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
Description

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.

Use the videos and sample files to follow the course.

Course Duration: 7 - 12 hours

Who is the target audience?
  • With this course you will you will extend your advanced knowledge of Access 2010 and become an expert user of MS Access.
Students Who Viewed This Course Also Viewed
What Will I Learn?
By the end of this course you will be able to use complex expert functions, export and import data and finaly manage, repair and program your Access database efficiently.
View Curriculum
Requirements
  • Basic and advanced knowledge of Access is recommended
Curriculum For This Course
Expand All 26 Lectures Collapse All 26 Lectures 02:10:57
+
Expert Functions
8 Lectures 44:38

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.

Dynamic Hyperlinks
08:04

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.

Preview 03:01

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.

Alternating Row Colors
02:17

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.
Conditional Formatting
12:03

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.

Various Values in a Collapsed Combo Box
05:55

In this film we will show you how to create and adapt relationships between tables when needed to create a query.

Preview 04:43

In this film we explain the three different join operations used to connect tables.

Join Operations
04:51

In this video we will show you how to easily find identical data sets by using a wizard.

Preview 03:44
+
Database Management
12 Lectures 01:02:00

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.

Export Data
02:56

In this film we will show you how to import and how to link tables, forms, queries or other database objects from other databases.

Importing and Linking Database Objects
05:21

In this film you will learn how to keep your database small and consistent.

Compact & Repair Databases
02:59

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.

Converting Databases
02:40

In this video we will show you how to easily carry out the documentation of a database by using the documenter.

Documenter
04:34

In this film we will show you how to improve the performance of your database using the performance optimizer.

Preview 02:32

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.

Table Analyzer Wizard
12:10

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.

Preview 03:07

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.

Password and Encryption
04:28

In this video we will show you what Application Parts are and how to create them.

Using Application Parts
07:51

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.

Splitting Databases
10:18

In this film we will show you how to create an ACCDE database that prevents contained forms, reports and programmes from being modified.

ACCDE Databases
03:04
+
Programming
5 Lectures 23:19

In this video we compare macros and VBA programming and explain their advantages and disadvantages.

Programming Access
03:22

In this video we will introduce you to the macro editor which you can use to create your own macros.

Macro Editor
04:54

In this video we will show you how to create simple macros that can be run for example with a mouse click.

Simple Macros
06:56

In this video we will show you how to use Submacros and how to bundle actions within a macro into a group.

Preview 05:25

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.

Program Options
02:42
+
Conclusion
1 Lecture 00:00
About the Instructor
4.1 Average rating
19 Reviews
220 Students
8 Courses

LernFilme offers high quality video trainings for the workplace. The German based Company founded in 2004 is specialized in software trainings for Microsoft Office programs and Lotus Notes.

With our Online Courses users can work with new programs or extend their knowledge at any time. The users decide when they want to learn, the content and pace. Our aim towards the day-to-day needs of users, together with the pure simplicity, are the basis of the success and the high acceptance of our System.

Report Abuse