Access - Level One

Description

In this full day workshop participants will learn the basics of creating and using a simple Access database application. Participants will create and use tables, forms, queries, and reports. Focus will be on using Access as a productivity tool as well as an instructional tool. By the end of the workshop participants will be able to define a database, describe basic database functions, identify the basic elements of an Access database, use a database, and create a simple database.

Topics

  • What is a Database?
  • Why Should You Use a Database?
  • What Can A Database Do?
  • What Are the Elements of a Database?
  • Records
  • Fields
  • Tables
  • Queries
  • Forms
  • Reports
  • Flat File DB vs. Relational Database
  • Creating a Database From Scratch
  • Naming Fields and Setting Properties
  • Data Types
  • Entering Data in a Table
  • Creating Lookups
  • Using Yes/No Data Type
  • Creating a Query Using the Query Design Grid
  • Select Queries
  • Parameter Queries
  • Sort Order in Queries
  • Creating Forms Using the Wizard
  • Creating A Form In Design View
  • Creating and Formatting Reports

Access - Level Two

Description

In this full day workshop participants will take a more in-depth look at queries, forms, and reports, covering topics not discussed in the Level One workshop. In addition, the concepts involved in relational databases will be discussed and demonstrated. Participants will create two table and establish a one-to-many relationship between the tables. Then they will create queries, forms, and reports that utilize that relationship.

FileMaker Pro - Level One

Description

This workshop will provide beginning users of databases with hands-on practice in designing and using these applications in classroom management and as instructional tools. Participants will create a simple database with four layouts, including graphics and navigation buttons.

Topics

  • Determine field types

  • Manipulate and format fields

  • Design and create simple layouts

  • Use graphics in design, in fields

  • Data entry/add records

  • Set tab order, move among fields

  • Find records

  • Sort records

  • Add and delete records

  • Modify layouts and fields

  • Create 1-step navigation buttons

  • Add and format text objects

  • Auto-enter and validation options

  • Create value lists

FileMaker Pro - Level Two

Description

Participants will be able to create navigation and command buttons, relationships, calculation fields, portals, and  simple scripts. We will explore layout parts and their applications. Ideas for classroom integration will be shared. Prerequisite: basic word processing skills

Topics

  • Change preferences (application and document)

  • Value lists

  • Design calculation fields – numerical, text, and logical

  • Define one-to-one relationships

  • Design and create look up fields

  • Container fields

  • Create portals

  • Create simple scripts

  • Activate scripts with start-up, with buttons, and with calculations

  • Summary, header, footer parts

  • Set groups and passwords (when time permits)