Access - Access- Creating a Database I nt roduction to...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Access- Creating a Database I nt roduction to Database Concepts Organizing Data Data is valuable resource to anhy business Customer’s names Addresses Contract amounts Dates Organzing ,storing,maintain,retrieving and sorting data are critical activities FIRST STEP TO ORGANIZING DATA Identify individual fields Field- a single characteristic or attribute of a person, place,object, event, or ides. Ex. Customer ID,first name,last name,company name,address,phone number NEXT Group related fields together into tables. Table- a collection of fields that describe a person, place, object, event, or idea. Field value- specific value,or content of a field Ex. Customer ID,First Name,Last Name,Phone. Record- when information are given under the field values then it’s called a record Each row of field values is a record Ex. Kathy Zhang 905 520 9576 Databases and Relationships A collection of related tables is called a database/ relational database ....
View Full Document

This note was uploaded on 12/09/2010 for the course COMP SCI 1B03 taught by Professor Dr.dotler during the Spring '10 term at McMaster University.

Page1 / 4

Access - Access- Creating a Database I nt roduction to...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online