Oreilly - Access 2007 Introduction
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
- Introduction
- 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
Show and hide more
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.