Learn Microsoft Access 2010 -The Ultimate Beginner Training-
5.0 (2 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.
30 students enrolled
Wishlisted Wishlist

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

Add to Wishlist

Learn Microsoft Access 2010 -The Ultimate Beginner Training-

This Access course for beginners explains how to create and administer databases with MS Access 2010.
5.0 (2 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.
30 students enrolled
Current price: $10 Original price: $40 Discount: 75% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • 29 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • By the end of this course you will be able to setup a simple database and enter and refine data. Use the videos and sample files to increase your knowledge.
View Curriculum
Requirements
  • No previous knowledge in Access 2010 required.
Description

This Access course for beginners explains how to create and administer databases.

Learn the basics about data types, tables and queries, how to use validation rules, indexes and relationships and how to create forms for the entry and maintenance of data. Apart from that we explain how to use aggregate functions, calculated fields and filtering and sorting criteria for the evaluation and analysis of your data.

Use the videos and sample files to follow the course.

Course Duration: 13 - 22 hours

Who is the target audience?
  • With this Access course for beginners you will learn Access 2010 from scratch.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 39 Lectures Collapse All 39 Lectures 03:41:43
+
Introduction to Relational Databases
6 Lectures 27:17

In this video we will outline and explain the terms "database" and "relational database" and show you what databases are used for.

Preview 02:45

In this video you will learn how to proceed when gathering information for your Access database.

Adding Data to the Database
03:54

In this video we will explain the terms "relational database" and "redundancy" to you.

Redundancy
02:23

In this video, you will learn how to assign a meaningful primary key to a table and what you need foreign keys for.

Primary Keys and Foreign Keys
05:32

In this video you will learn about the different kinds of relationships which are possilbe between tables in a database.

Preview 04:35

In this film you will learn about the different data types which Access offers and what they are used for.

Data Types
08:08
+
Introduction to Access 2010
8 Lectures 56:14

In this video you will learn about the structure of an Access database and you will be introduced to its objects.

Structure of Access Database
04:23

In this film, we introduce the workspace, the ribbon and other important elements of the user interface in Access 2010.

Preview 06:50

In this video we will show you how to create tables, define field data types and add data to the table.

Adding Tables
13:45

This video will show you how to add, delete and move fields in tables.

Adding, Moving, Erasing Fields
05:45

In this video you will learn how to create an input mask in order to control the data input in tables or forms.

Setting an Input Mask
04:41

This film will show you how to define rules that check the user's data entry on its validity. You will learn how to setup validation rules both on fields and on data sets.

Validation Rules
08:00

In this film we will explain the term index and show you how to index columns.

Indexes
05:51

In this video we will show you how to create relationships between tables. Additionally we will familiarize you with the term referential integrity and the cascading of updates and deletion of records.

Relationships
06:59
+
Queries
6 Lectures 33:31

In this video we will show you how to retrieve data from your Access database and how to analyse it by using queries.

Design Queries
04:15

In this video you will learn how to create queries quickly and easily by using the query wizard.

Query Wizard
04:57

In this video we will show you how to create queries on queries in order to filter nested information.

Preview 03:21

This video will show you how to add calculations to your queries.

Calculated Fields
04:36

This video will give you an introduction to the Expression Builder which you can use to create formulas and expressions.

Expression Builder
09:11

In this film you will learn how to use aggregate functions in order to calculate and summarize values in queries.

Aggregate Functions
07:11
+
Forms
6 Lectures 30:38

In this video we will show you the quickest and easiest way to create a form.

Autoform
02:22

In this video you will learn how to create a form by using the Form Wizard.

Preview 02:58

In this video we explain the different form views and how to apply these views to your forms.

Form Views
04:46

In this video we will show you how to create a form manually, from scratch.

Creating a Form
10:38

In this video we will show you how to insert headers and footers into a form.

Forms with Headers and Footers
07:26

In this video we will show you how to match the order in which the fields in your form are activated with the order in which the fields are displayed.

Tab Order
02:28
+
Using controls
5 Lectures 32:56

In this video we will give you a short overview of the available controls in Access and we will show you some important settings for using these controls.

Short overview of the available controls in Access
03:28

In this video we will show you how to use the controls "Label", "Text Field" and "Image".

Label, Text Field, Image
09:47

In this video we will show you the controls "Toggle Button", "Option Field", "Check Box" and "Option Group".

Option Groups and Buttons
07:25

In this video we will explain the Tab control and show you how to create your own tabs.

Using Tab Controls
05:40

In this video we will explain the control "Button Control" and we will show you how to start various actions in Access.

Button Control
06:36
+
Searching sorting filtering
5 Lectures 29:39

In this video you will learn how to use the lookup function in Access. We will show you how to adjust the search settings and how to set your personal settings to be default settings.

Preview 08:00

We introduce you to the "Search for Data" function which gives you the possibility to simply choose information when searching for data instead of having to enter it.

Search for Data
06:56

In this video we will explain how to sort data in an ascending or descending way using different criteria.

Sorting Data
03:10

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.

Filtering Data in the Datasheet View
06:09

We will show you in this video how to use a form based filter to display only certain data sets in a form.

Filtering in Forms
05:24
+
Specials
2 Lectures 10:28

Usually it is recommended to print reports if you want to print data from a database. In this video we will show you how you can adapt your print settings to print tables or queries.

Printing Tables and Queries
04:31

In this video we will show you how to create reports using the Report Wizard.

Report Wizard
05:57
+
Conclusion
1 Lecture 00:00
About the Instructor
LernFilme.com High quality video trainings for workplace learning. LernFilme.com
4.3 Average rating
22 Reviews
236 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.