# Presentation: 125884

## Advanced Data Presentation Techniques via the Internet

**Session  IIB**
- _Microsoft Access_
- Henry Weigel
- May 24, 2000
- Bangladesh Ministry of Energy and Mineral Resources

## The Use  of MS Access

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

## 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

## 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)

## Forms

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

## Examples

- Monthly Energy Review  _[..\Session4\MER_Demo\merdb2000_x.](file:///../Session4/MER_Demo/merdb2000_x.mdb)__[mdb](file:///../Session4/MER_Demo/merdb2000_x.mdb)_
- World Energy Database  _[..\Session4\World_Demo\World2000_X.](file:///../Session4/World_Demo/World2000_X.mdb)__[mdb](file:///../Session4/World_Demo/World2000_X.mdb)_

## EIS Using MS Access

## Monthly Energy Review

- One of EIA’s 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

## Summary Statistics Menu

## Energy Overview and Selected Charts

- Production
- Consumption
- Energy trade
- Prices

## Energy Overview

## Energy Consumption by Sector

## Crude Oil Price

## Prices of Petroleum Products

## Retail Prices of Electricity

## Instructions

## Choices: Overview of Production

## Choices: Overview of Consumption

## Choices: Petroleum Production

## Petroleum Production: Graph Option

## Choices: Electricity Generation

## Characteristics of Charts

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

## World Energy DatabaseUsing MS Access

## Title Chart: Main Menu

- Seven choices
- Country
- Four energy types
- Reports
- Analysis
- Energy balance perspective

##      Oil Balance

## Natural Gas Balance

## Coal Balance

## Electricity Balance

## Report Options

## Report Option: Country Data

## Menu of Analysis Options

## Analysis Option

## Analysis Option:Unaccounted for Oil Supply

## Analysis Option: Graph

## Session 4, EIS Development: Access Forms – World Energy

- Henry Weigel
- Energy Information Administration
- February 2000

## World Energy Database

## Country Selection Property Box

## Button-Object Relationship

- _[..\Session4\World_Demo\](file:///../Session4/World_Demo/MainMenuLayout.xls)__[MainMenuLayout](file:///../Session4/World_Demo/MainMenuLayout.xls)__[.](file:///../Session4/World_Demo/MainMenuLayout.xls)__[xls](file:///../Session4/World_Demo/MainMenuLayout.xls)_

## Reports Button

- Macro:  Reports.Print Reports
- Forms: Reports Menu with option values
- Reports: Analysis of Oil Balances
- Query: Analysis of Oil Balances
- Table: Country Oil Totals

## Report Options

## Report Option: Country Data

## Analysis Button

- Macro:  Analysis.Menu
- Forms: 1. Analysis Menu,
- Forms: 2. Oil Consumption
- Query: Analysis of Oil Balances
- Table: Country Oil Totals

## Menu of Analysis Options

## Analysis Option

## Analysis Option:Unaccounted for Oil Supply

## Oil Button

- Event Proc:
- DocName = "Oil Data"
- DoCmd.OpenForm DocName, , , LinkCriteria
- Open Form Oil Data and SubForm Oil Balances
- Query: Oil Sorted
- Tables: Oil & CtryFIPS

## Oil Balance for the Philippines

## Data Sources for Oil Balance

## Data Sources for Oil Balance 2

## Data Sources for Oil Balance 3

## Gas Button

- Event Procedure to open Form:
- Gas Data
- SubForm Gas Balance
- Query: Gas Sorted
- Tables: Gas & CtryFIPS

## Natural Gas Balance

## Coal Button

- Event Procedure to open Form:
- Coal Data
- SubForm Coal Balance
- Query: Coal Sorted
- Tables: Coal & CtryFIPS

## Coal Balance

## Electricity Button

- Event Procedure to open Form:
- Electricity Data
- SubForm Electricity Balance
- Query: Electricity Sorted
- Tables: Electricity & CtryFIPS

## Electricity Balance