We use cookies to give you the best experience when you browse our site. For more information about the cookies we use or to view our privacy policy, click here.
With thousands of short segment IT video lessons at your disposal, Intellezy is the most engaging IT online learning library available. Get started today! With thousands of short segment IT video lessons at your disposal, Intellezy is the most engaging IT online learning library available. Get started today!

Access 2007

Beginner
Subscribe Now

Course Overview

Instructor: Timothy Miles
Subject: Access 2007
Duration: 02 Hour 40 Minutes
Level: Beginner
Pre-requisites: 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.

Course Lessons

Introduction
Introduction0min 52sec
Introducing Access 2007
Starting Access2min 07sec Navigating the Main Screen0min 57sec Using the Quick Access Toolbar and Ribbon1min 22sec Using the Navigation Pane1min 08sec Navigating in the Document Window2min 17sec
Opening An Existing Database
Opening a Table2min 40sec Navigating a Table2min 27sec Using Quick Search0min 42sec Using Quick Filter4min 56sec
Creating a New Table Using Datasheet View
Adding Fields2min 39sec Changing the Data Type4min 53sec Adding a Lookup Field2min 38sec Deleting a Field1min 00sec
Create A New Table In Design View
Understanding The Design View7min 23sec Setting Input Masks2min 21sec Using The Lookup Tab1min 19sec Indexing A Table 5min 04sec
Adding Records to a Table
Adding a Record3min 03sec Using Zoom Mode1min 45sec Using Shortcut Keys3min 32sec Filtering Data2min 35sec
Finding Data
Using the Find Dialog Box2min 21sec Using Replace1min 05sec Deleting Records2min 01sec Changing Table Appearance4min 29sec
An Overview on Queries
Understanding Query Types0min 57sec Using the Query Wizard5min 21sec Using the Query Design View5min 00sec Using the QBE Grid3min 29sec Entering Criteria6min 46sec Creating a Query Manually4min 43sec Using Logical Operators in Criteria4min 21sec Using Wildcards in Criteria8min 03sec
Forms
Understanding Forms1min 13sec Creating a New Form7min 32sec Using the Form Design Window3min 33sec Selecting, Moving, and Resizing Controls17min 00sec
Reports
Understanding Report Design Steps1min 20sec Creating a Report5min 38sec Modifying Controls in a Report8min 28sec Basing a Report on a Query3min 31sec Adjusting and Printing a Report2min 09sec
Conclusion
Course Recap1min 32sec

Timothy Miles

Instructor

Tim has been a professional developer for over 20 years. He has worked with almost every industry, creating many different software solutions. If it requires code, he has probably worked with it.

Learn More About Timothy Miles

© 2020 Intellezy, LLC. All rights reserved | Terms of Use | Privacy