microsoft access 2010 design and create tables to store data l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Microsoft Access 2010 Design and Create Tables to Store Data PowerPoint Presentation
Download Presentation
Microsoft Access 2010 Design and Create Tables to Store Data

Loading in 2 Seconds...

play fullscreen
1 / 15

Microsoft Access 2010 Design and Create Tables to Store Data - PowerPoint PPT Presentation


  • 258 Views
  • Uploaded on

Microsoft Access 2010 Design and Create Tables to Store Data. Chapter 2. Chapter Overview. Databases and Decision Making Designing Database Tables Creating Tables in Access Primary Keys Field Data Types and Properties. Databases and Decision Making. Input (Data). Process. Output

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Microsoft Access 2010 Design and Create Tables to Store Data' - Patman


Download Now An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
chapter overview
Chapter Overview
  • Databases and Decision Making
  • Designing Database Tables
  • Creating Tables in Access
  • Primary Keys
  • Field Data Types and Properties
databases and decision making
Databases and Decision Making

Input

(Data)

Process

Output

(Information)

Input using Forms Handled by Queries Output to Reports

Stored in Tables Supports Decision Making

GIGO – Garbage In, Garbage Out

designing database tables
Designing Database Tables

Database design is critically important to the success of an information system.

Your tables are the foundation of the entire database.

designing database tables5
Designing Database Tables
  • 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 redundancy
creating tables in access
Creating Tables in Access
  • Table Wizard (don’t use)
  • Datasheet and Design Views
primary keys
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 type
field data types
AutoNumber

Text

Hyperlink

Number

Memo

Date / Time

Currency

Yes / No

OLE Object

Attachment

Calculated

Lookup Wizard

Field Data Types
field properties
Field Size

Format

Input Mask

Caption

Default Value

Validation Rule

Validation Text

Required

Allow 0 Length

Indexed

Field Properties

These help to prevent GIGO

questions requested updates from hr users
Questions & Requested Updates from HR Users
  • Bad data appears in AssessmentScore
  • Need email address of every applicant
  • Want option to store 9 digit zip code
  • CID value occasionally skips numbers
  • Need to track the HR employee assigned to each candidate
  • Data entry and editing is not user-friendly
quick review
Quick Review

What does GIGO stand for?

a. Gee, I Goofed, OK

b. Grand Illusions, Go On

c. Global Indexing, Global Order

d. Garbage In, Garbage Out

quick review12
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 field

c. It must be first in a table

d. It can never be changed

quick review13
Quick Review

Which fields are commonly defined with an input mask?

a. Social Security number

b. First, middle and last name

c. City, state and zip code

d. All of the above

quick review14
Quick Review

Which field data type appears as a check box in a table?

a. Text field

b. Number field

c. Yes/No field

d. All of the above

quick review15
Quick Review

The_______ is a field (or combination of fields) that uniquely identifies a record.