->
Oreilly - Access 2007 Introduction - 001071CWORKS
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
  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
  12. Show and hide more

    Oreilly - Access 2007 Introduction


 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.


 Coktum   |  

Information
Members of Guests cannot leave comments.




rss