DiscoverAccess 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.

• 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.

• 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.

• 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.

• Find And Sort Data:Find A Record, Sorting Records, Perform An Advanced Sort.
• Work With Filters:What Is A Filter? Apply & Remove Filters.
• Use Queries To Retrieve Data:Creating & Saving Queries, Multi-Table Queries, Create A Select Query, Add A Calculated Field To A Query.
• Summarize Data With Select Queries:Summarizing Data, Create A Query To Summarize Data.
• Create Complex-Criteria Queries:Complex-Criteria Queries, Create A Complex-Criteria Query.
• Create Parameter Queries:Parameter Queries, Create A Parameter Query.
• Create Action Queries To Modify Data:Action Queries words/min, Create A Delete Query, Create An Update Query, Create An Append Query.

• Report Basics:What Is A Report?
• Create Reports Using The Report Wizard:Use The Report Wizard.
• Create Reports In Design View:Creating Reports, Report Controls, Error-Checking In Reports, Report Sections, Create A Report In Design View, Add A Calculated Control To A Report.
• Modify Reports:Report Element Properties, Modify Control Properties, Modify Section Properties, Modify Report Properties.
• Sort And Group Report Data:Set Sorting & Grouping Options.
• Use Subreports:Use Subreports, Create A Subreport.

• Import Data Into Access:Importing Data, Import Data Into A New Table.
• Link To External Data:Link To Another Access Database Table, Working With Linked Tables.
• Export Data From Access:Exporting Data, Export Data (Exercise).

• File Formats & Compatibility:New PowerPoint 2007 File Format, Saving An Access 2007 Database In An Earlier Version, Converting A Database to Access 2007 Format.
• Database Security:Database Security In Access 2007, Encrypt A Database With A Password.
• Database Splitter:Splitting Databases, Split A Database.
• Improve Database Performance:Use Performance Analyzer, The Compact & Repair Tool.
• Share A Database:Publishing A Database, Exporting Data To A SharePoint List.
• Collect Database Data:Collecting Data Via E-mail.