Access 2010 Introduction
4.2 (30 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
419 students enrolled

Access 2010 Introduction

All you need to know to design, build and use a basic database
4.2 (30 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
419 students enrolled
Last updated 5/2018
English
English [Auto]
Current price: $27.99 Original price: $39.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4.5 hours on-demand video
  • 2 downloadable resources
  • 1 Practice Test
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Open, navigate and add data to an existing database
  • Design and create a new database
  • Effectively use and create tables
  • Create and use queries
  • Create and use forms
  • Create and use reports
Requirements
  • Basic Microsoft Windows training or equivalent experience
Description

This course covers the basics functions of Access 2010. After an introduction to database concepts and the Access environment and Help systems, you will learn how to open and use existing databases and design and create databases. Next, you will work with tables, fields, and records; sort, search and filter data; and set field properties and data entry rules. You also will learn to create queries, forms, and reports.

Who this course is for:
  • Students who need to collect, analyze and query large amounts of data
Course content
Expand all 47 lectures 04:26:01
+ Introduction
1 lecture 01:40

If you would like to work along with the instructor, please download the attached .zip file, which contains all the files used throughout this course.

Preview 01:40
+ Opening an Existing Database
8 lectures 37:09
Reviewing the Anatomy of a Table
07:12
Using the Search Text Box
01:21
Using the Field Quick Filter Button
08:03
Reordering Columns
05:15
+ Creating a New Database
9 lectures 45:36
Understanding the Table Design View
05:45
Understanding the Different Data Types
10:00
Adding Fields
06:40
Adding Calculated Fields
05:29
Adding Pre-Defined Fields
02:16
Modifying Fields
06:05
+ Working With the Table
5 lectures 20:23
Searching With Wildcards
04:53
Using Replace
05:02
Adding Totals
04:33
Adding the Subdatasheet
04:57
+ Creating a Select Query
5 lectures 48:19
Using the Query Wizard
09:01
Using the Query Design View
08:53
Setting Query Criteria
10:40
Creating a New Query
06:51
Using Range Operators
12:54
+ Creating Simple Forms
7 lectures 42:58
Creating Simple Forms Using the Form Wizard
04:33
Selecting, Moving and Resizing Controls
15:05
Creating a Simple Form Using the Form Button
06:54
Using Labels
04:02
Formatting Controls
03:15
Setting Tab Order
06:12
+ Creating Simple Reports
6 lectures 32:26
Creating Simple Reports Using the Report Wizard
07:07
Selecting, Moving and Resizing Controls
04:23
Using Report Bands
02:28
Using Groups
01:28
Using Controls
04:25
Changing the Page Layout
12:35