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

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:

Sort, Retrieve And Analyze Data
  • 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.
Work With Reports
  • 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.
Integrate Access With Other Applications
  • 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).
Manage An Access Database
  • 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.


Download now!