Learn Microsoft Access 2010 -The Ultimate Beginner Training-

This Access course for beginners explains how to create and administer databases with MS Access 2010.
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.
25 students enrolled
$40
Take This Course
  • Lectures 39
  • Contents Video: 3.5 hours
    Other: 1 min
  • Skill Level Beginner 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

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

What are the requirements?

  • No previous knowledge in Access 2010 required.

What am I going to get from this course?

  • 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.

What is the target audience?

  • With this Access course for beginners you will learn Access 2010 from scratch.

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: Introduction to Relational Databases
02:45

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

03:54

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

02:23

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

05:32

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

04:35

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

08:08

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

Section 2: Introduction to Access 2010
04:23

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

06:50

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

13:45

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

05:45

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

04:41

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

08:00

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.

05:51

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

06:59

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.

Section 3: Queries
04:15

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

04:57

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

03:21

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

04:36

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

09:11

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

07:11

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

Section 4: Forms
02:22

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

02:58

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

04:46

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

10:38

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

07:26

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

02:28

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.

Section 5: Using controls
03:28

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.

09:47

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

07:25

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

05:40

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

06:36

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

Section 6: Searching sorting filtering
08:00

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.

06:56

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.

03:10

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

06:09

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.

05:24

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

Section 7: Specials
04:31

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.

05:57

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

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