Access 2003 Level 2: Accessing the Possibilities

IT@Emory computer education - Microsoft Office Training

Learn the fundamentals of Access as you work with tables, queries, reports, forms and macros. Build your own personal contact management system in class, beginning with table creation, look up wizards and data value intelligence, then create command buttons and menus. Fieldwork is assigned to ensure you master the material. Learn to build relational databases and avoid potential pitfalls of using Access.

Prerequisite: Some experience with Windows

Instructor: Greg Creech, Master – Microsoft Office Application Specialist (MCAS)
3 session(s): Wed: Dec 2-16 / 9:00 am-4:00 pm
Registration fee: $495   CEUs: 1.8      

After this class, you will be able to

• Create your own relational database from scratch
• Design tables for storing data and fine-tune tables by creating fields to store text, numbers, and other data types
• Relate tables using referential integrity to build an effective data structure
• Import and export data from Access in various formats, such as Text, Excel, and XML
• Create queries to extract, sort, and filter data from your relational database
• Design forms for easy data entry and editing
• Design reports to prepare your data for printing
• Use macros to automate processes such as closing the database or opening a form

What will be covered

Lesson 1: Databases: What a Concept


•    Databases from Concept to Reality
  
•    What databases are and what databases are not
  
•    Databases: Terms of Endearment
  
•    Types of Databases
  
•    Database Planning and Plotting
  
•    Relationships Overview
  
•    Joins and Keys
  
•    Database Objects
  
•    Database Window
  Lesson 2: Creating a Database
  
•    Database Wizards
  
•    Address Wizard
  
•    Generic Wizard
  
•    Database Creation 101
  
•    Using an Existing Database
  Lesson 3: Tables with Data
  
•    Building a Table from "Scratch"
  
•    Table Overview
  
•    Datasheet View and Design View
  Lesson 4: AutoForm and Form Wizard
  Lesson 5: Form Design: The Basics
  
•    Form View
  
•    Design View-Form
  Lesson 6: The Toolbox
  Lesson 7: More About Tables
  
•    Department Lookup Table
  
•    More Complex Personnel Table
  
•    The Lookup Wizard
  
•    Compact and Repair Database
  Lesson 8: Relationship Creation
  
•    Importing and Exporting Data
  
•    Export
  
•    Import
  
•    Importing Access Objects from Another Database
  
•    Copying Database Objects
  Lesson 9: Queries: Questions and Answers with lots of Expressions
  
•    Query Overview
  
•    Query Examples
  
•    Working in Query Design View
  
•    The Query Toolbar and Important Icons
  
•    Select Query Exercise – Specific Value
  Lesson 10: Report and Label Wizards and Design View
  
•    Report Wizard
  
•    Report Design: The Basics
  
•    The Label Wizard
  Lesson 11: Back to Queries
  
•    Select Query Exercise – Wildcard
  
•    Query Examples
  
•    Range Queries
  
•    Queries as a Troubleshooter
  
•    Joins
  
•    Calculation Queries
  
•    Report Wizard II
  Lesson 12: Forms
  
•    Overview and Purpose
  
•    Sample Forms
  
•    Menu Forms
  
•    View Only or Read Only Forms
  
•    Multi-Table and Forms based upon Queries
  
•    Input Forms
  
•    Search and Edit Forms
  
•    Creating a New Form Using the Form Wizard
  Lesson 13: Reports
  
•    Overview and Purpose
  
•    Sample Reports
  
•    Detail Report with Groups, Sub-Totals, Grand Totals
  
•    Summary Report
  
•    Parameter Reports
  
•    Specialized Reports

Share this class:   Digg    Facebook    Del.icio.us    Reddit    LinkedIn  

Search Results

Search again