Session 4 EIS: Access Forms -- MER

1
Session 4EIS Access Forms -- MER

• Henry Weigel
• Energy Information Administration
• February 2000

2
EIS Using MS Access
3
Monthly Energy Review

• One of EIAs flagship publications
• Represented as an EIS
• MS Access
• Database
• Graphical user interface by means of the queries
  and forms capabilities
• Main menu Summary or Detailed

4
Summary Statistics Menu
5
Energy Overview and Selected Charts

• Production
• Consumption
• Energy trade
• Prices

6
Energy Overview
7
Energy Consumption by Sector
8
Crude Oil Price
9
Prices of Petroleum Products
10
Retail Prices of Electricity
11
Instructions
12
Choices Overview of Production
13
Choices Overview of Consumption
14
Choices Petroleum Production
15
Petroleum Production Graph Option
16
Choices Electricity Generation
17
Characteristics of Charts

• Overview charts
• Clearly defined by legends and axis labels
• Available Options at the bottom
• Detailed charts
• Monthly data
• Various options e.g., graph, print, save, export