Access (1) - University of Florida Introduction to Database...

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

View Full Document Right Arrow Icon
HSC IT Center Training University of Florida Introduction to Database Concepts and Microsoft Access 2003 Health Science Center IT Center – Training [email protected] 352-273-5051
Background image of page 1

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

View Full DocumentRight Arrow Icon
HSC IT Center Training University of Florida Database Concepts and Access 2003 Introduction Database Microsoft Access Design and Creation Plan Tables Queries Forms Reports
Background image of page 2
HSC IT Center Training University of Florida Things to Do Contact your customer support Backup Backup Backup
Background image of page 3

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

View Full DocumentRight Arrow Icon
HSC IT Center Training University of Florida What is a Database? A structured collection of related data An filing cabinet, an address book, a telephone directory, a timetable, etc. In Access, your Database is your collection of related tables
Background image of page 4
HSC IT Center Training University of Florida Data vs. Information Data – a collection of facts made up of text, numbers and dates: Murray 35000 7/18/86 Information - the meaning given to data in the way it is interpreted: Mr. Murray is a sales person whose annual salary is $35,000 and whose hire date is July 18, 1986 .
Background image of page 5

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

View Full DocumentRight Arrow Icon
HSC IT Center Training University of Florida Basic Database Concepts Table A set of related records Name: Barry Harris College: Medicine Tel: 392-5555 Name: Barry Harris College: Medicine Tel: 392-5555 Name: Barry Harris Field Record A collection of data about an individual item A single item of data common to all records
Background image of page 6
HSC IT Center Training University of Florida An Example of a Table Records Fields Name GatorLink Phone College Graff rgraff 392-3900 Pharmacy Harris bharris 392-5555 Medicine Ipswich zipswich 846-5656 PHHP
Background image of page 7

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

View Full DocumentRight Arrow Icon
HSC IT Center Training University of Florida Design and Document Your Database A designers best tools are a pencil and paper It is important to plan what you are going to do The sooner you touch the computer the sooner you’ll make a mistake If you don’t plan you will often have to start again Document what you are doing, will you remember what you did in three months time?
Background image of page 8
HSC IT Center Training University of Florida Questions To Ask Yourself What have I got? (Inputs) What do I want?
Background image of page 9

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

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

This note was uploaded on 12/08/2010 for the course USE 3425 taught by Professor Raman during the Spring '10 term at Punjab Engineering College.

Page1 / 30

Access (1) - University of Florida Introduction to Database...

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

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