Have a Question? Call 0800 689 3038 or Click here to email us.
Cart 0
Access 2007 Essentials Online Training

Access 2007 Essentials Online Training

[ TTAC10AD ]


Course Description

Explore the endless capabilities of Access 2007. These lessons, begin with a solid introduction of Access and cover topics such as defining a database, knowing when to use Access, working with database objects, and converting older databases. Once you're up to speed on the intricacies of Access, we walk you through step-by-step procedures on how to construct your table structures, create and adapt meaningful data entry forms, as well as share tracked information with others through reports.

Course Features

  • Length of Subscription: 12 Months Online On-Demand Access
  • Running Time: 6.6 Hours
  • Platform: Windows & MAC OS
  • Level: Beginner to Intermediate
  • Project Files: Included

Learn anytime, anywhere, at home or on the go.

Stream your training via the internet, or download to your computer and supported mobile device, including iPad, iPhone, iPod Touch and most Android devices.

Course Outline

Chapter 1: INTRODUCING ACCESS 2007 (17 min)

Defning a Database
Knowing When to Use Access™
Working with Database Objects
Converting Older Databases


Exploring the Getting Started Screen
Opening a Microsoft Template
Using the Navigation Pane
Using the Home Tab, Part 1
Using the Home Tab, Part 2
Using the Create Tab
Using the External Data Tab
Using the Database Tools Tab
Using the Office Menu
Explaining the Access Options
Using the Quick Access Toolbar
Adding Custom Commands to the Quick Access Toolbar
Using the Help Menu
Understanding the Message Bar
Creating Trusted Locations
Working in the Object Window


Displaying Categories
Showing Views
Sorting the Objects
Searching for Objects
Collapsing Groups
Creating Custom Groups
Adding Object Shortcuts
Hiding Custom Groups
Changing the Interface Mode
Final Comments & Credits

Part/Disc 2
Chapter 1: CREATING TABLES (67 min)

Explaining the Datasheet Tab
Entering Data in a New Table
Using a Table Template
Identifying the Entities
Working with Design View
Creating DataTypes
Using Field Validation Rules
Defining Primary Keys
Adding Indexes
Working with Table Relationships
Creating Table Relationships
Defining Multi-Value Field Lookups

Chapter 2: CREATING QUERIES (50 min)

Creating a Select Query
Using Expressions in a Query
Sorting Data
Searching for Data
Selecting Data from Many Tables
Working in Layout View
Working in SQL View
Creating a Crosstab Query
Running Action Queries
Running Update Queries
Using the Query Wizard

Chapter 3: CREATING FORMS (48 min)

Using Quick Create Commands
Exploring Form Types
Navigating within Forms
Using the Form Wizard
Creating a Form from Scratch
Working in Layout View
Working in Design View
Setting Form Properties
Using Form Controls
Using Control Layouts
Applying AutoFormats
Understanding Subforms

Chapter 4: CREATING REPORTS (57 min)

Using the Report Command
Running the Report Wizard
Exploring Report Views
Creating a Report from Scratch
Using Conditional Formatting
Grouping & Sorting
Setting Report Properties
Detailing Your Report
Applying AutoFormats
Adding Subreports
Alternating Record Colors
Filtering in Report View
Creating Labels

Chapter 5: CREATING MACROS (26 min)

Working in Macro Design Mode
Assigning Macro Actions
Setting Macro Arguments
Running an AutoExec Macro
Creating Embedded Macros
Final Comments & Credits

More from this collection