Set: DATABASE TEST 2

Familiarize

Learn

Test

Play Scatter

Play Space Race

Combine with other sets Login to add to Favorites
Print: Term List | Flashcards Editing not allowed
Export Deleting not allowed

Share these flash cards

With group: None
HTML link to set: Tiny link:
Share on Facebook Share on MySpace

All 20 terms

TermDefinition
PRIMARY KEYTHE FIRST/PRIMARY WAY YOU ACCESS A COMPUTER
RED EXCLAMATION MARKCLICK THIS ICON TO RUN A QUERY
RELATIONSHIPSA TABLE FORMS RELATIONSHIPS WITH OTHER TABLES
YOUR ID NUMBERYOUR PRIMARY KEY TO ACCESS CMS COMPUTERS
BEAUTY OF DATABASEEVERY DEPARTMENT DOESN'T HAVE TO RETYPE THE SAME PERSONAL INFO ON YOU
1ST STEP TO CREATE DATABASEPLAN AND DESIGN FIRST!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
FOY PRESSES SAVEFOYCA1 GRADES/ABSENTS WILL FORM RELATIONSHIPS WITH OTHER TEACHERS TABLES OF GRADES/ABSENTS
>=10,000 (BONUS - MET GOAL)IF YOU DON'T PUT THE = SIGN ONLY THOSE > THAN WILL RECEIVE BONUS - VERY IMPORTANT IN PAYROLL DEPT.
COMPARISON OPERATORS>= > < <> =
tbl qry frm rptNAMING CONVENTIONS (PROTOCOL FOR NAMING TABLES, QUERIES , FORMS AND REPORTS)
PHONE NUMBERPRIMARY KEY FOR A PIZZA TAKEOUT
AVERAGE QUERYYOU HAVE TO DO A TOTAL FORMULA QUERY BEFORE YOU CAN DO AN AVERAGE QUERY
COST IN WORD PROBLEMCOST IS NOT FORMATTED AS A NUMBER - IT IS FORMATTED AS CURRENCY!!!!!!
WORD PROBLEMSREAD CAREFULLY - THEY ARE DESIGNED TO TEST YOUR REASONING AND READING/COMPREHENSION SKILLS
SNOWFLAKES AND HOT CHOCOLATETWO OF MS. FOY'S FAVORITE THINGS
SCHOOL CAFETERIA PRIMARY KEYSTUDENT LUNCH NUMBER
TAX OFFICE PRIMARY KEYSOCIAL SECURITY NUMBER
SPORTS PLAYER PRIMARY KEYNUMBER ON UNIFORM
PRIMARY KEY FIELD THAT FORMS RELATIONSSHIIP AT MPSTUDENT ID NUMBER IS USED TO FORM RELATIONSHIIPS WITH OTHER TABLES OF INFORMTION ON STUDENT
PRIMARY KEY WHEN POLICE PULLS YOU OVERLICENSE TAG NUMBER

Set Information

Terms 20
Creator FOYFOY
Created January 6, 2009
Groups None
Subject CA1
Access Anyone
Edit Creator Only
Get rid of ads on Quizlet
Pop out

Discuss

No Messages
Last Message: never

You must be logged in to discuss this set.