This preview shows pages 1–3. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full 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