Access 2007 Introduction

All you need to know to design, build and use a basic database
4.6 (7 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.
125 students enrolled
$30
Take This Course
  • Lectures 44
  • Contents Video: 2.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 basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

What are the requirements?

  • Basic Microsoft Windows training or equivalent experience

What am I going to get from this course?

  • Ability to open, navigate and enter data in a database
  • Effectively create tables in a new database
  • Understand how to use queries
  • Build and use forms
  • Build 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
00:52

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
Starting Access
Preview
02:07
The Main Screen
Preview
00:57
Using the Quick Access Toolbar and Ribbon
Preview
01:22
Navigation Pane
Preview
01:08
Document Window
02:17
Section 3: Opening An Existing Database
Opening a Table
Preview
02:40
Navigating a Table
Preview
02:27
Using Quick Search
00:42
Using Quick Filter
04:56
Section 4: Create a New Table Using the Datasheet View
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
Section 5: Create a New Table in Design View
Understanding the Design View
07:23
Setting Input Masks
02:21
Using the Lookup Tab
01:19
Indexing a Table
05:04
Section 6: Adding Records to a Table
Adding a Record
Preview
03:03
Using Zoom Mode
Preview
01:44
Using Shortcut Keys
04:25
Filtering Data
02:35
Section 7: Finding Data
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing the Table Appearance
05:13
Section 8: An Overview of Queries
Understanding Query Types
Preview
00:57
Using the Query Wizard
05:21
Using the Query Design View
05:00
Using the QBE Grid
03:29
Entering Criteria
06:46
Creating a Query Manually
04:43
Using Logical Operators in Criteria
04:21
Using Wildcards in Criteria
08:03
Section 9: Forms
Understanding Forms
Preview
01:13
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving and Resizing Controls
17:00
Section 10: Reports
Report Design Steps
01:20
Creating a Report
05:38
Modifying Controls in a Report
08:28
Basing a Report on a Query
03:31
Adjusting and Printing a Report
02:09
Section 11: Conclusion
Conclusion
01:32

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