Developing and Manageing Databases National Louis University

Reading and other Class Activities / Assignments

Session One: 

Read Post Ch 1                Systems Design

    Answer Rev Questions 1,3

Read Post Ch 10  Database Administration

    Answer Exercises 3a, 3c, & 3d

Read Wempen     Read & Work Lessons 1 - 6

Prepare DB Paper Outline

Relational Database Theory

Developing Database Requirements

MS Access Operating Environment

Database Tables

Quiz

Session Two: 

Read Post Ch 2    Database Design

    Answer Rev Questions 2 - 4

Read Wempen     Read & Work Lessons 7 - 13

Select Database Project Topic

Simple Database Query Development

Quiz

Session Three: 

Read Post Ch 3    Data Normalization

    Answer Review Questions 1, 2, 4, & 11

Read Wempen     Read & Work Lessons 14 - 17

Normalization Exercise

Constraints on Data

Validation of Data Entry                                                                           

Quiz

Session Four: 

Read Post Ch 4    Data Queries

    Answer Review Question 1

Read Wempen     Read & Work Lessons 18 - 22

Designing Complex Queries

Calculated Fields in a Query

Using Events to Trigger Actions

Quiz         

Session Five: 

Read Post Ch 6    Forms and Reports      

    Answer Rev Questions1, 5, & 8

Read Wempen     Read & Work Lessons 23 - 25

Developing Database Forms and Reports

Calculations on Forms and Reports

Quiz

Session Six:   

Read Post Ch 11  Distributed Databases & the Internet

    Answer Review Questions 1-3, & 5

Read Wempen     Work Lessons 26 - 29

Quiz

 

Hit Counter