Professional Development Committee Workshop
A Computer Offering Given by Maureen Greenbaum

Create that List You’ve Been Needing

Student Learning Outcomes:

 Start a program. 
Open a database.
Design a table. 
Create a database. 
Learn about records & fields.
Use a primary key.

Learn More on my Tutorials Page

MS Access the database tool that is part of the Microsoft Office 2007 Suite

This course objective

bulletOverview of Access
bulletWhat Access can (should be used to)  do
bulletComponents
bulletTwice or 3 times as many features as Excel
bulletBrave (Undo)
bulletHelp

Versus

bulletWord processing (MS Word)
bulletPresentations (PowerPoint)
bulletSpreadsheets (Excel) for a picture frozen in time
bulletNot available in all versions of Office 2007
bullet $59.95 Ultimate Steal if your have a edu email addr4ess

Use Access for

bulletData that constantly changes
bulletData that you wish to sort/group various ways
bulletData that has a variable number of subordinate records (ie students and assignments submitted)

The screen

bullet2007 Ribbon: Home, Create, External Data Datasheet
bullet2003 Toolbar(s) (same as other Office tools)
bulletHover for words that explain
bulletUse View Toolbars to toolbars appear/disappear
bulletMove them, resize, see/choose extra icons
bulletCustomizing a bar (add, remove, move icons)

The database

bulletNamed saved right away, each record automatically saved to disk when you move to next
bulletIncludes "everything"
bulletTables
bulletRelationships
bulletForms
bulletQueries
bulletReports

Tables

bulletWizard, select, rename fields
bulletDesign, change names, size, format, default etc
bulletTwo mode: designer (puppeteer) and user (audience) 
bulletEnter data
bulletDatasheet, change column widths, drop down related
bulletForms (Autoform)
bulletExample:
bulletselect "Students
bulletchange first name to 15 long
bulletadd Date entered UCC as type date, note various formats
bulletselect "Students and Classes"
bulletdelete ClassID
bulletadd Assignment and Submit date
bulletNote Index

Forms

bulletTwo mode: designer (puppeteer) and user (audience)
bulletSelect field or label, change it (size, position, properties  - Format ONLY)
bulletAdd a field (close, table-design, form)

Filters

Queries - select only some records

Reports - subtotals and totals


Last updated: 02/15/2009