Video 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.Table of contents
-
Introduction
- Introduction 00:00:53
-
Introducing Access 2007
- Starting Access 00:02:07
- Navigating the Main Screen 00:00:57
- Using the Quick Access Toolbar and Ribbon 00:01:22
- Using the Navigation Pane 00:01:08
- Navigating in the Document Window 00:02:17
-
Opening An Existing Database
- Opening a Table 00:02:40
- Navigating a Table 00:02:27
- Using Quick Search 00:00:42
- Using Quick Filter 00:04:57
-
Creating a New Table Using Datasheet View
- Adding Fields 00:02:39
- Changing the Data Type 00:04:53
- Adding a Lookup Field 00:02:38
- Deleting a Field 00:01:01
-
Creating a New Table in Design View
- Understanding the Design View 00:07:23
- Setting Input Masks 00:02:21
- Using the Lookup Tab 00:01:19
- Indexing a Table 00:05:04
-
Adding Records to a Table
- Adding a Record 00:03:04
- Using Zoom Mode 00:01:45
- Using Shortcut Keys 00:04:25
- Filtering Data 00:02:36
-
Finding Data
- Using the Find Dialog Box 00:02:21
- Using Replace 00:01:05
- Deleting Records 00:02:01
- Changing the Table Appearance 00:05:13
-
An Overview on Queries
- Understanding Query Types 00:00:57
- Using the Query Wizard 00:05:21
- Using the Query Design View 00:05:00
- Using the QBE Grid 00:03:29
- Entering Criteria 00:06:46
- Creating a Query Manually 00:04:43
- Using Logical Operators in Criteria 00:04:21
- Using Wildcards in Criteria 00:08:04
-
Forms
- Understanding Forms 00:01:13
- Creating a New Form 00:07:32
- Using the Form Design Window 00:03:33
- Selecting, Moving, and Resizing Controls 00:17:00
-
Reports
- Understanding Report Design Steps 00:01:20
- Creating a Report 00:05:38
- Modifying Controls in a Report 00:08:28
- Basing a Report on a Query 00:03:31
- Adjusting and Printing a Report 00:02:09
-
Conclusion
- Course Recap 00:01:32
Product information
- Title: Access 2007 Introduction
- Author(s):
- Release date: September 2016
- Publisher(s): Intellezy
- ISBN: 001071CWORKS
You might also like
audiobook
Transformed
Help transform your business and innovate like the world's top tech companies! Transformed: Moving to the …
audiobook
What's New in AI: Open Source Large Language Models with Eric Xing (Audio)
Join host George Anadiotis and guest Eric Xing, for a discussion about the current and expanding …
audiobook
The Art of Leadership
Many people think leadership is a higher calling that resides exclusively with managers who practice or …
audiobook
Crucial Conversations
The book that revolutionized business communications has been updated for today's workplace. Crucial Conversations provides powerful …