Access 2007 Introduction
4.3 (20 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.
172 students enrolled
Wishlisted Wishlist

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

Add to Wishlist

Access 2007 Introduction

All you need to know to design, build and use a basic database
4.3 (20 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.
172 students enrolled
Last updated 10/2016
English
Current price: $10 Original price: $30 Discount: 67% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
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 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 44 Lectures Collapse 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
+
Opening An Existing Database
4 Lectures 10:45


Using Quick Search
00:42

Using Quick Filter
04:56
+
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
+
Adding Records to a Table
4 Lectures 10:55


Using Shortcut Keys
03:32

Filtering Data
02:35
+
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
1 More Section
About the Instructor
Intellezy Trainers
4.4 Average rating
3,025 Reviews
20,537 Students
132 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.