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 ]

£48.00

Seen this product cheaper elsewhere?
We'll beat any like-for-like training quote!
CLICK HERE


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)

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


Chapter 2: EXPLORING THE NEW USER INTERFACE (84 min)

  • 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


Chapter 3: WORKING IN THE NAVIGATION PANE (45 min)

  • 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

If you'd like a Free Demo of this product then please complete the form here :

Need to train your Team? Contact Us for Discounts on Multiple Subscription Purchases.


More from this collection