Access 2007 Introduction
4.5 (34 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.
219 students enrolled

Access 2007 Introduction

All you need to know to design, build and use a basic database
4.5 (34 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.
219 students enrolled
Last updated 10/2016
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
  • 2.5 hours on-demand video
  • 2 downloadable resources
  • 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
  • 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
Requirements
  • Basic Microsoft Windows training or equivalent experience
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.

Who this course is for:
  • Students who need to collect, analyze and query large amounts of data
Course content
Expand all 44 lectures 02:38:12
+ Introduction
1 lecture 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.

Preview 00:52
+ Create a New Table Using the Datasheet View
4 lectures 11:10
Adding Fields
02:39
Changing the Data Type
04:53
Adding a Lookup Field
02:38
Deleting a Field
01:00
+ Create a New Table in Design View
4 lectures 16:07
Understanding the Design View
07:23
Setting Input Masks
02:21
Using the Lookup Tab
01:19
Indexing a Table
05:04
+ Finding Data
4 lectures 09:56
Using the Find Dialog Box
02:21
Using Replace
01:05
Deleting Records
02:01
Changing the Table Appearance
04:29
+ An Overview of Queries
8 lectures 38:40
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
+ Forms
4 lectures 29:18
Creating a New Form
07:32
Using the Form Design Window
03:33
Selecting, Moving and Resizing Controls
17:00
+ Reports
5 lectures 21:06
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