Discover Access 2007 HD is interactive multimedia training 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.Discover Access 2007 - Part I covers the following topics:Access 2007 Basics Office 2007 Overview Access 2007 OverviewScreen Layout Getting Started The Ribbon The Title Bar & Quick Access Toolbar The Office Button The Navigation Pane Database Objects Display & View Database ObjectsCreate And Open A Database What Is A Database? Creating A New Database Open An Existing DatabaseCustomize Access Access Options Customizing The Quick Access ToolbarHelp in Access 2007 Microsoft Office Access Help Working In The Access Help Window Context Specific Help Office DiagnosticsPlanning A Database Planning Basics What Is A Table? Define A Table Define Fields Identify Primary KeysDefine Relationships One-To-Many Relationships Many-To-Many Relationships One-To-One RelationshipsReview The Design Refining The Design Queries Forms & ReportsDatabase Templates Database Templates Use A Database TemplateCreate A Table Create A Blank DatabaseWork With Table Data Enter DataModify A Table Modify Table Structure Modify Table Format Create A Lookup FieldBuild A Relational Database [Expert] Referential Integrity & Cascade Options Create A One-To-Many Relationship Create A Many-To-Many RelationshipControl Data Entry In Tables [Expert] Validation Rules Create A Validation Rule Create A Validation Rule Error MessageForm Basics What Is A Form? What Is A Sub-Form? Form ViewsCreate A Form Automatically Create & Use A Form Use The Form Wizard Split FormsCreate Forms In Design View Creating Forms Form Controls Bound & Unbound Controls Create A Form In Design View Create A Calculated ControlModify Control Properties Control Properties Modify The Format Of A Control Add Data Validation To A ControlCreate Subforms Subforms Create A Subform Using The Form Wizard
