t o Store Data Chapter 2 Chapter Overview Databases and Decision Making Designing Database Tables Creating Tables in Access Primary Keys Field Data Types and Properties Input Data Process ID: 716402
Download Presentation The PPT/PDF document "Intro to MIS - MGS351 Design and Create ..." is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Intro to MIS - MGS351
Design and Create Tables
to Store Data
Chapter 2Slide2
Chapter Overview
Databases and Decision Making
Designing Database Tables
Creating Tables in Access
Primary Keys
Field Data Types and PropertiesSlide3
Input
(Data)
Process
Output
(Information)
Input using
Forms
Handled by
Queries
Output to ReportsStored in Tables Supports Decision MakingGIGO – Garbage In, Garbage Out
Databases and Decision MakingSlide4
Database design is critically important to the success of an information system.
Your tables are the foundation of the entire database.
Designing Database TablesSlide5
Include the necessary data
Determined by reporting needs
Store data in its smallest parts
Split last and first names
Avoid storing calculated data (GPA)What about age versus birthdate?Avoid data redundancyDesigning Database TablesSlide6
Creating Tables in Access
Table Wizard (don’t use)
Datasheet and Design ViewsSlide7
Primary Keys
A field or combination of fields that uniquely identifies records in a table.
Use an existing field
Use a combination of fields (concatenated key)
Create a new field using the Autonumber data typeSlide8
Field Data Types
AutoNumber
Short Text
Hyperlink
NumberLarge NumberLong TextDate / TimeCurrencyYes / NoOLE ObjectAttachmentCalculatedLookup WizardSlide9
Field Properties
Field Size
Format
Input Mask
CaptionDefault ValueValidation RuleValidation TextRequiredAllow 0 LengthIndexed
These help to prevent GIGOSlide10
Questions & Requested Updates from HR Users
Bad data appears in
AssessmentScore
Need email address of every applicant
Want option to store 9 digit zip codeCID value occasionally skips numbersNeed to track the HR employee assigned to each candidateData entry and editing is not user-friendlySlide11
Quick Review
What does GIGO stand for?
a.
Gee, I Goofed, OK
b. Grand Illusions, Go Onc. Global Indexing, Global Orderd. Garbage In, Garbage OutSlide12
Quick Review
Which of the following is true of the primary key?
a.
Its values must be unique
b. It must be defined as a text fieldc. It must be first in a tabled. It can never be changedSlide13
Quick Review
Which fields are commonly defined with an input mask?
a.
Social Security number
b. First, middle and last namec. City, state and zip coded. All of the aboveSlide14
Quick Review
Which field data type appears as a check box in a table?
a. Text field
b. Number field
c. Yes/No fieldd. All of the aboveSlide15
Quick Review
The______ is a field, or combination of fields, that uniquely identifies a record.