This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Microsoft Access for Office 2007 Assignment #1 (Part 2) Intro to Access...just a little more reading before we enter data into our database Data is defined as "facts existing in isolation." When you put the data together in a meaningful way, they become “ information .” A record is like your doctor's record...all the “facts” he has about you. A field is a collection of one kind of fact...like First Name or Last Name...from various records. What kind of fields would your doctor's database have? I'd say your Name, Address, Phone Number, Insurance Carrier, Date of Birth, Emergency Contact, etc. Think of a few more… So…your doctor would set up a DATABASE , and it would consist of a TABLE all his patients and is made up of FIELDS for First Name, Last Name, Address, Vaccines, etc. The TABLE would have a RECORD for each patient with data in each FIELD . He could Sort the table alphabetically by last names or he could Filter the table to find the people who use Blue Cross for insurance. The doctor could create a FORM for making it easy to enter new records into the table, or he could run QUERIES , which ask the tables to show specific info, such as all his patients who have Blue Cross insurance and are over age 65. all his patients who have Blue Cross insurance and are over age 65....
View Full Document
- Spring '10
- Design View, Personal name, Family name, Given name