by Tim Miles | Released September 2016 | ISBN: 001071CWORKS

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. Show and hide more Publisher resources Download Example Code

1. Introduction
   • Introduction 00:00:53
2. 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
3. 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
4. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. 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
11. Conclusion
    • Course Recap 00:01:32
Show and hide more