Executive Information Systems Session 4

1
Executive Information Systems Session 4

• Henry Weigel
• Energy Information Administration
• February 2000

2
The Use of MS Access

• Database and graphical user interface all in one
  package
• Data queries made easy
• Forms as user interface
• Reporting capability

3
Database Design

• Follow good design techniques
• E.g., third normal form
• Assure data integrity
• Easier to maintain
• It is better to have several tables that can be
  linked than one or two huge, cumbersome tables

4
Querying the Data

• Construct queries by using design features
• Logic for data selection
• Input from tables and/or other queries
• Based on SQL (Structured Query Language)

5
Forms

• For data presentation
• Input from tables or queries
• Selection lists
• Customizing the form with property parameter
  settings

6
Examples

• Monthly Energy Review ..\MER_Demo\merdb2000_X.mdb
  
• World Energy Database ..\World_Demo\World2000_X.m
  db