Assignment #1 Part 3 Access 2007 revised

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

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

View Full Document Right Arrow Icon
Scroll Bar Row or Record Selector Field Selector Drop down arrow for sorting and filtering Resize by double-clicking here Microsoft Access for Office 2007 Assignment #1 (Part 3) In Design View , you should have this: There are many other fields we could use, but these are the ones that will keep our database from getting too big or too confusing. " Kin " means the resident's "next of kin" or closest relative. The residents all live at the retirement home, but we sometimes need to contact their next of kin. We will be typing Text, not numbers or dates or money. In later Tables we will use other Data Types. 1. Click on the View icon under Home to move to Datasheet View . From now on, you should be able to switch between views on your own, by clicking the first View under Home . In Datasheet View , you should now have this: 2. Starting in the Resident First field , type the following Records into the database. Press Tab to move from field to field. Press Tab twice at the end of the line to skip the first column, AutoNumber, which will fill in automatically as soon as you move past it. 1. ID Resident First Resident Last Kin First Kin Last Kin Address City State Zip Doctor Last Aut onu mbe r – don’ t type here ! Jane Doe Alice Doe 10 Red Rd. Albany NY 12333 Jones John Smith Barb Smith 20 Blue Rd. Albany NY 12333 Jones Earl Gray Ida Gray 30 Green Rd. Albany NY 12333 Kruger Carol Foster Jim Foster 40 White Rd. Fishkill NY 12222 Blain Peter Foss Fred Foss 50 Yellow Rd. Fishkill NY 12222 Jacobs Sandy Sell Ida Gray 30 Green Rd. Albany NY 12333 Blain Emmy Kraft Lila Peat 70 Violet Rd. Fishkill NY 12222 Aaron Please check your data entries carefully. Spelling counts in databases! Suppose I wanted to sort for only the residents that live in Albany. If I had entered one A b l a n y , that person's record would not appear. 2. Page 1 of 6 Linda Hickman ©2009
Background image of page 1

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

View Full DocumentRight Arrow Icon
Navigating the Database Navigating merely means moving around. Our database has a few records, but imagine if it had 500. Moving to record 87 would be a slow process if you had to press the DOWN ARROW 87 times to get there! Do This: Move around your database by using the ARROW keys located on the right of your keyboard (not on the numeric keypad, however!). Look above the arrow keys at Home and End . Pressing Home will bring you to the beginning of an entry or a line. Ctrl+Home brings you to the beginning cell and Ctrl+End brings you to the last. This is true for all Microsoft applications It's a great thing to know, especially if you have many pages of information. Poof! You're back at the beginning. Poof! You're at the end. Also, using the arrow keys gives you more control than trying to
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 08/11/2010 for the course CSIS 100 taught by Professor Judy during the Spring '10 term at Palomar.

Page1 / 6

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

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