The Salvation Army-Cleveland Temple Corps
Community Computer Center
Beginning Access
Syllabus
Prepared by: Permeil Dass
Day One:
    Overview of Access and database programs in general
    Database Design< br>Start with the end in mind br>Opening Access
    Access Basic Commands (See Info for Word)
    • Opening files
    • Closing files
    • Save/Save As
    • Printing
    • Starting a new database
    Review
    • Maximizing windows
    • Minimizing windows
    • Resizing windows
    • Sending windows to the taskbar
    • Closing windows
    • Closing Access
    • Tiling windows
    Main Components in Access
    • Tables
    • Queries
    • Forms
    • Reports
    • Macros
    • Modules
    • Using Wizards
    Terminology
    • Fields
    • Rows
    • Column Headings
    • Records
    • Columns
    • Cells
    • Datasheet View
    • Design View
 Day Two: Selecting
  • Rows
  • Columns
  • Cells
Inserting/Deleting
  • Columns
  • Rows/records
Moving Around in a Table
  • Home
  • End
  • Arrow keys
  • Tab/shift tab
  • Between records
Getting Help
  • Office Assistant
  • Help Menu
  • Right-clicking
Using Columns
  • Renaming
  • Freezing
  • Moving
  • Hiding
  • Adjusting the width
Sorting/Filtering Records
  • Filter by selection
  • Filter by exclusion
  • Advanced filters
  • Filter by form
Creating New Tables
  • Wizards
  • Auto
  • Using design or datasheet view
  • Field Names/Datatypes
 Day Three: CreatingForms
  • AutoForm
  • Form Wizard
  • Design View
  • Working in Design View
  • Controls-Bound/Unbound
Sections within Design View
  • Header/Page Header
  • Footer/Page Footer
  • Detail
  • Selecting
  • Moving/Resizing Controls
  • Adding/Deleting Controls
  • Text
  • Field Cells
  • Formatting Controls
Relationships
  • Primary Key
  • Enforce Referential Integrity
  • Cascade Update
  • Cascade Delete
  • Adding tables and queries
 Day Four: Queries
  • Simple Query Wizard
  • Simple Query Wizard-using one table or query
  • Simple Query Wizard-using two tables or queries
  • Working with Queries
  • Sorting and Filtering

 Day Five: Reports
  • Report Wizard
  • Auto Report
  • Labels
  • Working with Reports
Printing
  • Printing Selected records
  • Sorting
  • Grouping
  • Tables
  • Forms
  • Queries
  • Reports
Review
Questions/Answers
  Day Six: Review
  Day Seven: Review
  Day Eight: Test for Certificate
  Return to Main Document