Home > Course Catalog > Discover Access 2007 Part I
Discover Access 2007 Part I

Discover Access 2007 is an interactive e-learning tool for users of Microsoft Office Access 2007. The Discover products combine audio, animation, and software simulation to make the “discovery” of computer programs both effective and entertaining. The products are also designed to help you learn at your own pace, allowing you to repeat topics or jump to anywhere in the course.

The following topics are covered in this course:

Introducing Access 2007
  • Access 2007 Basics:Office 2007 Overview, Access 2007 Overview.
  • Screen Layout:Getting Started, The Ribbon, The Title Bar & Quick Access Toolbar, The Office Button, The Navigation Pane, Database Objects, Display & View Database Objects.
  • Create And Open A Database:What Is A Database? Creating A New Database, Open An Existing Database.
  • Customize Access:Access Options, Customizing The Quick Access Toolbar.
  • Help in Access 2007:Microsoft Office Access Help, Working In The Access Help Window, Context Specific Help, Office Diagnostics.
Design A Database
  • Planning A Database:Planning Basics, What Is A Table? Define A Table, Define Fields, Identify Primary Keys.
  • Define Relationships:One-To-Many Relationships, Many-To-Many Relationships, One-To-One Relationships.
  • Review The Design:Refining The Design, Queries, Forms & Reports.
Build A Database
  • Database Templates:Database Templates, Use A Database Template.
  • Create A Table:Create A Blank Database.
  • Work With Table Data:Enter Data.
  • Modify A Table:Modify Table Structure, Modify Table Format, Create A Lookup Field.
  • Build A Relational Database [Expert]:Referential Integrity & Cascade Options, Create A One-To-Many Relationship, Create A Many-To-Many Relationship.
  • Control Data Entry In Tables [Expert]:Validation Rules, Create A Validation Rule, Create A Validation Rule Error Message.
Work With Forms
  • Form Basics:What Is A Form? What Is A Sub-Form? Form Views.
  • Create A Form Automatically:Create & Use A Form, Use The Form Wizard, Split Forms.
  • Create Forms In Design View:Creating Forms, Form Controls, Bound & Unbound Controls, Create A Form In Design View, Create A Calculated Control.
  • Modify Control Properties:Control Properties, Modify The Format Of A Control, Add Data Validation To A Control.
  • Create Subforms:Subforms, Create A Subform Using The Form Wizard.


Download now!