Learn Microsoft Access 2010 -The Ultimate Advanced Training-

In our advanced Access course you will learn how to use Access efficiently for your daily work.
4.5 (4 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.
35 students enrolled
$45
Take This Course
  • Lectures 39
  • Contents Video: 3.5 hours
    Other: 1 min
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 10/2013 English

Course Description

In our advanced Access course you will learn how to use Access efficiently for your daily work.

We explain how to use special controls and subforms to allow a comfortable and clear data maintenance. Additionally we will show you how to create queries and how to include parameters, filter criteria, formulas and expressions in queries in order to perform various tasks. Learn how to create reports and how to analyze your data using Pivot Tables. Course

Use the videos and sample files to follow the course.

Duration: 11 - 18 hours

What are the requirements?

  • Basic knowledge of MS Access is recommended.

What am I going to get from this course?

  • By the end of this course you will be able to manage and customize Access databases and work with complex quieries, formulas, reports and Pivot Tables.

What is the target audience?

  • With this course you will you will extend your basic knowledge of Access 2010 and become an advanced MS Access user.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Advanced Fundamentals
06:10

In this film we explain the properties window, where you can display and set various properties for objects, fields and other controls.

09:36

In this film we explain the relation between a field data type and the precision of the displayed and saved values. Also we will show you how to adapt the displayed values for example to rounded values.

Section 2: Navigation
11:53

In this film you will learn how to use the controls "Combo Box" and "List Box".

04:35

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.

09:16

In this film you will learn how to manually create a navigation menu which is used to quickly access the most important database objects.

04:50

In this video we will show you how to create your own navigation bar.

02:20

Learn how to use functions and expressions to filter the display of data effectively.

Section 3: Advanced Queries
08:27

In this film we will explain how to filter the display of records in queries using filter criteria.

02:18

In this film we will show you how to avoid the display of duplicates in queries.

02:03

In this film you will learn how to filter top values in queries.

05:34

In this film we will show you how to create flexible queries by using query parameters.

03:31

In this film we explain how to create an Update Query in order to quickly update large amounts of data in tables.

04:28

In this video we will show you how to create Delete Queries in order to delete large amounts of data with one single command.

03:29

In this film we will show you how to add data sets to a table by using Append Queries.

04:03

In this video we will show you how to create new tables based on existing data using Make Table Queries.

05:22

In this video we will show you how to summarize and analyze data using Crosstab Queries.

Section 4: Reports
05:36

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.

09:51

In this video we will show you how to create customized reports by designing them step by step from scratch.

07:51

In this video we will show you how to group and sort data in order to clearly structure reports.

04:04

In this video we will explain how to add calculations to reports.

03:39

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.

09:14

In this video you will learn how to create charts in order to visualize large amounts of numbers.

Section 5: Forms
05:18

In this film we will explain how to summarize data in a form using aggregate functions. For example you can show the total value of displayed orders.

04:11

In this film we will show you how to use the Form Wizard to easily create forms with subforms.

02:27

In this film we will show you how to easily create a form with a subform using the drag & drop method. The same procedure can be applied to reports and subreports, too.

05:25

In this video we will explain how to create form templates. By using form templates you can quickly create new forms that are already formatted.

Section 6: Using PivotTables
04:11

In this video we give you an introduction to PivotTables and with the help of some examples show you what they are used for.

09:21

In this video we will show you how to analyse and evaluate data in Access by using PivotTables.

04:09

In this video we will explain the summary functions in PivotTables.

02:42

In this video we will show you how to format a PivotTable in order to display the results in a neat manner.

04:42

In this video we will show you how to sort and group data in PivotTables.

02:56

In this video we will explain the Property Sheet in PivotTables which you can use to perform frequently used tasks.

05:35

In this video we will show you how to create calculated fields in PivotTables.

04:34

In this video we will show you how to filter the highest and lowest values in PivotTables quickly and easily.

05:49

In this video we will show you how to analyze data by using PivotCharts. You will learn how to create PivotCharts, how to choose chart types and how to adjust the chart settings.

03:33

In this video you will learn how to set the chart type for your analysis, how to add a title to the chart and how to apply other relevant graphical adjustments.

Section 7: Specials
03:47

In this film we will show you how to set a form to be opened automatically when a database is run.

06:22

In this film you will learn how to link files, web pages or Email addresses to your database.

Section 8: Conclusion
What we learned
Preview
1 page

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

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.

Ready to start learning?
Take This Course