Using the NFPA 299 database cindy3'mdb, v0'3, 6232002

1
Using the NFPA 299 databasecindy3.mdb, v0.3,
6/23/2002

• John Q. Murray
• Murray Information Services, Inc.

2
v0.3 Access 2000 database

• Offers access to all NFPA299 assessments
• Adds forms to make it easy to use
• Provides a robust search capability
• By ownername, address, city
• Or view all records in the database
• Add new assessments
• Edit existing assessments

3
Get started open the database

• Start Microsoft Access 2000
• From the File menu, select the Open command
• In the Open dialog, select cindy3.mdb
• Or create a shortcut to cindy3.mdb and click

4
It starts up with the NFPA299 form
Two important details (1) Tabs access different
parts of the form (2) Command buttons do the work
5
Command buttons (lower right)

• Search Find record(s) based on criteria
• New / Clear Clear all fields in the form
• Generate sample Supply valid values in all
  required fields
• Save Write the data to the database

6
Search

• Click the Search command button from the main
  NFPA299 form
• Launches the dialog Search for an assessment

• Can enter all or none of the criteria

7
Three possible results of the search

• No matching records
• One matching record
• More than one matching record

8
1. No matching records

• Displays an error message, No assessments found
  for those criteria
• Click OK
• Returns to the dialog Search for an assessment
  to search again

9
2. One matching record

• Displays that matching record in the form

10
3. More than one match

• Displays another dialog asks you to select one
  record from the matching records
• This example no criteria, displays all records
  in the db
• ID, Address number, Address street, City, Date, By

11
You must select a record

• If none selected before clicking Go to record
  displays an error message

12
Display the selected record
13
Select different tabs
14
Select different tabs
15
Search by city (Huson)
16
Search by street name Conifer
17
Change a misspelled street name

• Change Appalosa to Appaloosa

18
Make changes, then click Save
19
Updated records get a new ID

• Note that the old record (ID 765) is still
  present in the database but no longer visible to
  the user in the forms
• Only the latest version of the data can be
  accessed
• Internally, the database stores bookkeeping
  information about changed records the
  PreviousID and NextID fields

20
Yabba dabba doo!

• Quitting time
• Exit the application
• From the File menu, select the Exit command