Free Sample
CHAPTER 1: INTRODUCING ACCESS 2007
Free Sample
01:00
Head
Free Sample
02:41
Knowing When to Use Access™
Free Sample
03:11
Working with Database Objects
Free Sample
07:10
Converting Older Databases
Free Sample
CHAPTER 2: EXPLORING THE NEW USER INTERFACE
Free Sample
00:25
Head
Free Sample
05:18
Exploring the Getting Started Screen
Free Sample
03:55
Opening a Microsoft Template
Free Sample
03:26
Using the Navigation Pane
Free Sample
08:04
Using the Home Tab, Part 1
Free Sample
05:20
Using the Home Tab, Part 2
Free Sample
02:58
Using the Create Tab
Free Sample
05:43
Using the External Data Tab
Free Sample
03:58
Using the Database Tools Tab
Free Sample
05:45
Using the Office Menu
Free Sample
08:28
Explaining the Access Options
Free Sample
05:10
Using the Quick Access Toolbar
Free Sample
06:01
Adding Custom Commands to the Quick Access Toolbar
Free Sample
05:59
Using the Help Menu
Free Sample
02:46
Understanding the Message Bar
Free Sample
04:18
Creating Trusted Locations
Free Sample
06:09
Working in the Object Window
Free Sample
CHAPTER 3: WORKING IN THE NAVIGATION PANE
Free Sample
00:23
Head
Free Sample
07:17
Displaying Categories
Free Sample
03:13
Showing Views
Free Sample
04:51
Sorting the Objects
Free Sample
03:20
Searching for Objects
Free Sample
02:37
Collapsing Groups
Free Sample
07:27
Creating Custom Groups
Free Sample
06:17
Adding Object Shortcuts
Free Sample
05:02
Hiding Custom Groups
Free Sample
03:18
Changing the Interface Mode
Free Sample
01:46
Final Comments & Credits
Free Sample
CHAPTER 4: CREATING TABLES
Free Sample
00:36
Head
Free Sample
04:02
Explaining the Datasheet Tab
Free Sample
07:18
Entering Data in a New Table
Free Sample
06:10
Using a Table Template
Free Sample
05:13
Identifying the Entities
Free Sample
05:44
Working with Design View
Free Sample
05:20
Creating DataTypes
Free Sample
05:17
Using Field Validation Rules
Free Sample
07:19
Defining Primary Keys
Free Sample
06:34
Adding Indexes
Free Sample
04:26
Working with Table Relationships
Free Sample
04:15
Creating Table Relationships
Free Sample
05:16
Defining Multi-Value Field Lookups
Free Sample
CHAPTER 5: CREATING QUERIES
Free Sample
00:22
Head
Free Sample
08:58
Creating a Select Query
Free Sample
06:46
Using Expressions in a Query
Free Sample
04:02
Sorting Data
Free Sample
04:51
Searching for Data
Free Sample
02:40
Selecting Data from Many Tables
Free Sample
03:26
Working in Layout View
Free Sample
03:40
Working in SQL View
Free Sample
04:28
Creating a Crosstab Query
Free Sample
04:10
Running Action Queries
Free Sample
03:43
Running Update Queries
Free Sample
03:27
Using the Query Wizard
Free Sample
CHAPTER 6: CREATING FORMS
Free Sample
00:24
Head
Free Sample
03:36
Using Quick Create Commands
Free Sample
02:41
Exploring Form Types
Free Sample
03:50
Navigating within Forms
Free Sample
05:04
Using the Form Wizard
Free Sample
05:13
Creating a Form from Scratch
Free Sample
03:58
Working in Layout View
Free Sample
03:05
Working in Design View
Free Sample
03:14
Setting Form Properties
Free Sample
05:16
Using Form Controls
Free Sample
05:07
Using Control Layouts
Free Sample
03:25
Applying AutoFormats
Free Sample
03:26
Understanding Subforms
Free Sample
CHAPTER 7: CREATING REPORTS
Free Sample
00:20
Head
Free Sample
03:10
Using the Report Command
Free Sample
08:55
Running the Report Wizard
Free Sample
03:48
Exploring Report Views
Free Sample
05:22
Creating a Report from Scratch
Free Sample
05:10
Using Conditional Formatting
Free Sample
06:56
Grouping & Sorting
Free Sample
03:06
Setting Report Properties
Free Sample
04:25
Detailing Your Report
Free Sample
02:34
Applying AutoFormats
Free Sample
04:03
Adding Subreports
Free Sample
01:45
Alternating Record Colors
Free Sample
03:24
Filtering in Report View
Free Sample
04:42
Creating Labels
Free Sample
CHAPTER 8: CREATING MACROS
Free Sample
00:25
Head
Free Sample
03:56
Working in Macro Design Mode
Free Sample
02:39
Assigning Macro Actions
Free Sample
04:25
Setting Macro Arguments
Free Sample
06:45
Running an AutoExec Macro
Free Sample
06:02
Creating Embedded Macros
Free Sample
02:00
Final Comments & Credits
