Microsoft Access Course outline

Getting Started with Access 2007/2010

• Navigate using the Navigation Pane and the Access Ribbon toolbar.
• Understand Access terminology for databases, tables, records, and fields.
• Identify the uses of various objects in Access such as a Query or a Macro.

 

Designing the Database

• Design tables best suited to the purpose of your database.
• Implement consistent and logical naming conventions to make your database easier for others to use.
• Harness existing templates to avoid unnecessary duplication of effort.

 

Entering Data and Managing Records

• Use database table fields to quickly find and edit records.
• Add captions to provide additional information useful for data entry.
• Create validation rules and input masks for searchable and accurate records.
• Employ "wildcards" to generate meaningful results on even the most difficult searches.

 

Using Queries Effectively

• Retrieve and display a set of database records based on any number of criteria.
• Use the Query Wizard for faster, easier query creation, or code powerful queries using Structured Query Language.
• Refine the set of results by modifying, saving or restoring previous queries.
• Perform global updates and calculations on query results.

 

Generating Meaningful Reports

• Build custom reports which communicate the data and support business decision making.
• Modify a report's design while viewing the data for optimal visual effect.
• Preview a report and modify the page layout as needed for printing.

 

Our outlines are a guide to the content covered on a typical course. We may change or alter the course topics to meet the objectives of a particular course.

---

Microsoft Access Course outline

Designing the Database to Meet Business Requirements

• Organize data efficiently and eliminate redundant data for improved database performance.
• Create logical relationships between tables and fields, and maintain those relationships with referential integrity.
• Understand database normalization and the various normal forms

 

Enhancing Database Tables with Advanced Techniques

• Quickly view information from several tables using subdatasheets.
• Create and modify a lookup column to more efficiently display information from separate list of values or from another table.

 

Performing Complex Queries for Sophisticated Results

• Perform inner, outer and self-joins to link unrelated data tables.
• Save and reuse queries you use regularly.
• Use calculated fields to display the results of a mathematical or logical expression.

 

Designing Access Forms to Meet Users' Expectations

• Aid the user with visual cues, such as shapes and borders which group related controls.
• Use graphics effectively to draw the users' attention toward relevant portions of the form.
• Embed documents and spreadsheets in Access forms, to provide supplemental information when the user needs it most.
• Use form controls and menus effectively for data validation, to assist the user in entering appropriate data.

 

Displaying Data Powerfully with Charts, Graphs, and PivotTools

• Highlight important features in charts by including graphic elements.
• Use the exhaustive set of Access chart and graph properties to draw attention to critical data.
• Configure PivotTables and PivotCharts to view data within a datasheet or form.

 

Our outlines are a guide to the content covered on a typical course. We may change or alter the course topics to meet the objectives of a particular course.

---

 

Querying with SQL

• SQL and Access
• Writing SQL statements
• Attaching SQL queries to controls

 

Advanced queries

• Creating crosstab queries
• Creating parameter queries
• Using action queries

 

Macros

• Creating, running, and modifying macros
• Attaching macros to the events of database objects

 

Advanced macros

• Creating macros to provide user interaction
• Creating macros that require user input
• Creating the AutoKeys and AutoExec macros
• Creating macros for data transfer

 

Importing, exporting, and linking

• Importing and Exporting objects
• Interacting with XML documents
• Linking Access objects
• Working with Windows SharePoint Services

 

Database management

• Optimizing resources
• Protecting databases
• Setting options and properties

 

Internet integration

• Hyperlink fields
• Working with Outlook 2007 and Outlook 2010

 

Our outlines are a guide to the content covered on a typical course. We may change or alter the course topics to meet the objectives of a particular course.