Learn Microsoft Access 2010 -The Ultimate Advanced Training-
4.2 (5 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.
42 students enrolled
Wishlisted Wishlist

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

Add to Wishlist

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.2 (5 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.
42 students enrolled
Current price: $10 Original price: $45 Discount: 78% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • 35 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
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.
View Curriculum
Requirements
  • Basic knowledge of MS Access is recommended.
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

Who 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 39 Lectures Collapse All 39 Lectures 03:24:12
+
Advanced Fundamentals
2 Lectures 15:46

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

Property Sheet
06:10

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.

Precision and Display of Numbers
09:36
+
Navigation
5 Lectures 32:54

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

Combo Box and List Box
11:53

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.

Preview 04:35

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

Navigation Menu
09:16

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

Preview 04:50

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

Using Formulas as Filter Criteria
02:20
+
Advanced Queries
9 Lectures 39:15

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

Using Criteria for Filtering
08:27

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

Hide Duplicates
02:18

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

Top Values
02:03

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

Preview 05:34

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

Update Query
03:31

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

Delete Query
04:28

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

Append Queries
03:29

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

Make Table Query
04:03

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

Crosstab Queries
05:22
+
Reports
6 Lectures 40:15

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.

Report Tools
05:36

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

Creating Reports Manually
09:51

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

Grouping and Sorting in Reports
07:51

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

Preview 04:04

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.

PDF XPS
03:39

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

Creating Charts
09:14
+
Forms
4 Lectures 17:21

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.

Aggregate Functions in Forms
05:18

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

Preview 04:11

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.

Attaching Forms as Subforms
02:27

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.

Form Templates
05:25
+
Using PivotTables
10 Lectures 47:32

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

Introduction to PivotTables
04:11

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

Creating PivotTables
09:21

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

Summary Functions in PivotTables
04:09

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

Formatting PivotTables
02:42

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

Preview 04:42

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

Pivot Property Sheet
02:56

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

Calculated Fields in PivotTables
05:35

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

Pivot Top 10
04:34

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.

Creating PivotCharts
05:49

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.

Adjust PivotCharts
03:33
+
Specials
2 Lectures 10:09

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

Startup Settings
03:47

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

Hyperlinks
06:22
+
Conclusion
1 Lecture 00:00
About the Instructor
LernFilme.com High quality video trainings for workplace learning. LernFilme.com
3.9 Average rating
21 Reviews
228 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.