ISTM 210 - Exam 3 With Questions with 100% Correct Answers

ISTM 210 - Exam 3 With Questions with 100% Correct Answers Quick Stove - answersmall co. that sells emergency preparedness and backpack equipment. Location: Orem, Utah Navigation Pane - answerprovides way for user to interact w/various objects in database files Types of Objects - answerTables Queries Forms Reports Tables - answerused to store data in access. Columns- store data fields rows- store database records. Most important Queries - answerused to find specific data you need from a database. Does not give a copy of data, rather a diff view Forms - answerUsed to make entering new or updating existing records easy. A window that displays data in a table. Only shows one record from the table at a time. Reports - answerallow you to organize and present data. Aids in managerial decision making. Generates from tables or queries. Views - answerdifferent ways to look at an object Access is a - answerrelational database Naming fields should be - answermeaningful and descriptive- spaces not recommended, no special characters Short Text - answerstore data that won't be treated like a number for calculations. Ex. Phone #'s and zip codes. limited to 255 characters Long Text - answerstores large amts. of text. Limited to 65,536 characters. Number - answerstores + and - #'s. Can contain decimal. Used for calculations Date/Time - answerstore date or time info. Can be formatted to display in several diff ways. Currency - answernumber data type that places $ symbol in front Autonumber - answerautomatically insert value for autonumber field when a new record is added to a table Yes/no - answerstore data with only 2 possible values. T/F, On/Off, Yes/No OLE object - answerused to store files created by other programs like Word, Excel, etc. Hyperlink - answerused to store links to websites or other folders/files on your computer Attachment - answerstore files for database record. Can be any type of file including pics, sound, and videos Calculated - answerused to create a field that is generated by a formula. Refer to values in other fields for a record Lookup Wizard - answersimplifies data entry. Presents user w/list of items to choose from when entering a new record. Field Properties - answercan be modified for a field Field Size - answerdetermines how large field will be, numbers stored in field can be, and precision. Text- determines how many characters will be stored for each record Input Mask - answerused to set rules on how data will be entered for a field Default Value - answerused to automatically set a starting value for a field when a new record is added to table Validation Rule/Text - answerwork together. Check values when entered into table to make sure they fit a specific rule. Required - answerused to make sure that a value is entered into a field when a new record is added to the table Primary Key - answerfirst field in a table used to uniquely identify each of the records Foreign Key - answerwhen a field is used to link two tables Well designed data base Advantages - answer-less costly -easy to use -helps ensure data integrity (consistent & accurate) -avoid data redundancy Normalization - answerprocess of organizing tables and relationships in a database objectives: