ISTM 210 Phinney Access Terms Exam Questions & Answers 100% Correct!

object view - ANSWERSdisplays finished object design view - ANSWERSedit the object layout view - ANSWERSeasier to use what is a technical term for a table? - ANSWERSrelation database tables store information for specific things, called _______ - ANSWERSentities record - ANSWERScollection of information you have for an entity, stored in the rows of tables attribute - ANSWERSAKA fields, data stored for each database record, stored in the columns of tables database table - ANSWERScollection of records that have all the same attributes every field must contain what? - ANSWERSname and data type short text (data type) - ANSWERSused to store most data that won't be treated like a number i.e. text, phone numbers, zip codes limited to 255 characters long text (data type) - ANSWERSused to store larger amounts of text limited to 65536 characters number (data type) - ANSWERSused to store positive and negative numbers may contain decimal places the number or currency data type must be used when... - ANSWERSyou expect to perform calculations on the data in a field date/time (data type) - ANSWERSused to store date or time information can be formatted to display dates/times in different ways currency (data type) - ANSWERSnumber data type that places $ in front of the number