Assignment #1 Part 2 Access 2007 revised

Assignment #1 Part 2 Access 2007 revised - Microsoft Access...

Info iconThis preview shows pages 1–2. 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: 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 Soyour 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

Page1 / 2

Assignment #1 Part 2 Access 2007 revised - Microsoft Access...

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

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