Access 2010 Introduction
4.5 (22 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.
392 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Access 2010 Introduction to your Wishlist.

Add to Wishlist

Access 2010 Introduction

All you need to know to design, build and use a basic database
4.5 (22 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.
392 students enrolled
Last updated 10/2016
English
Price: $30
30-Day Money-Back Guarantee
Includes:
  • 4.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I 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
View Curriculum
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 is the target audience?
  • Students who need to collect, analyze and query large amounts of data
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 47 Lectures Collapse 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
+
Getting Started
5 Lectures 34:45


Reviewing the Ribbon
16:06


Understanding the Navigation Pane
04:59
+
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
+
Conclusion
1 Lecture 02:45
Conclusion
02:45
About the Instructor
Intellezy Trainers
4.4 Average rating
2,774 Reviews
19,373 Students
133 Courses
Computer Training Specialists

At Intellezy, we believe learning should be simple, engaging, and relevant. We make this possible by building innovative, short-segment eLearning videos and easy-to-use quick reference cards designed to educate and empower companies and individuals. In today’s rapidly evolving workplace it is imperative to make sure you have the skills required to succeed. Our library provides dynamic, task-focused videos right at your fingertips, right when you need them. Our goal? To educate the world, one video at a time.