Access 2010 Introduction

All you need to know to design, build and use a basic database
4.7 (16 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.
377 students enrolled
$30
Take This Course
  • Lectures 48
  • Contents Video: 4.5 hours
  • 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 4/2013 English

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

What are the requirements?

  • Basic Microsoft Windows training or equivalent experience

What am I going to get from this course?

  • 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

What is the target audience?

  • Students who need to collect, analyze and query large amounts of data

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

Section 2: Getting Started
Using the File Tab
Preview
04:59
Using Templates
Preview
05:26
Reviewing the Ribbon
16:06
Customizing the Quick Access Toolbar
Preview
03:17
Understanding the Navigation Pane
04:59
Section 3: Opening an Existing Database
Opening a Database
Preview
04:12
Using the Navigation Pane
Preview
03:57
Reviewing the Anatomy of a Table
07:12
Adding a Record
Preview
04:46
Using the Navigation Buttons
Preview
02:23
Using the Search Text Box
01:22
Using the Field Quick Filter Button
08:03
Reordering Columns
05:15
Section 4: Creating a New Database
Creating a New Table in Design View
Preview
04:14
Understanding the Table Design View
05:45
Understanding the Different Data Types
10:00
Adding Fields
06:40
Adding Calculated Fields
05:29
Adding and Validating Record Data
Preview
03:10
Using the Data Sheet View
Preview
01:58
Adding Pre-Defined Fields
02:16
Modifying Fields
06:06
Section 5: Working With the Table
Using the Find Dialog Box
07:51
Searching With Wildcards
04:53
Using Replace
05:03
Adding Totals
04:33
Understanding Table Relationships
Preview
00:58
Adding the Subdatasheet
04:57
Section 6: Creating a Select Query
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
Section 7: Creating Simple Forms
Creating Simple Forms Using the Form Wizard
04:33
Understanding the Form Design View
Preview
02:57
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:13
Section 8: Creating Simple Reports
Creating Simple Reports Using the Report Wizard
07:08
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
Section 9: Conclusion
Conclusion
02:45

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Intellezy Trainers, 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.

Ready to start learning?
Take This Course