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

ISTM 210 Exam 3 Access With Questions with 100% Correct Answers Access Menu Ribbon - answerAt the top of the window Provides access to all of the features Access Object Navigation Pane - answerAt the side of the window Provided to help users interact with the various objects in database files Compact and Repair tool - answerIn the Database Tools Menu Tab Analyzes the database and reduces the size of the database file (Compact on Close) Tables - answerUsed to store the data in Access Consists of columns, which store data fields, and rows, which store database records Queries - answerUsed to find the specific data you need from the database Can be constructed to locate related data across more than one table Can be used to perform some basic calculations on numeric data Forms - answerUsed to present the data in a table in a separate window one record at a time Used to help with entering new data into a table and to navigate through the records of a table in user-friendly way Reports - answerUsed to organize and present the data in your database Used to present the data in a meaningful way to aid in managerial decision making Can be generated from tables or queries Different Views - answer1. Object view 2. Design View 3. Layout View Object View - answerDisplays the finished object (Maybe a finished table) Design View - answerUsed to edit the object Allows you to add and configure the field in a table Allows you to add elements to the form or report and change the appearance of those elements Layout View - answerLike the design view, but provides fewer options for manipulating the object Often easier to use than the design view Not always an option to use Relation - answerTechnical term for a table Is the basis of the term "Relational Database" Relationship - answerWhen a table contains data associated with data from another table within the database Entity - answerSomething you are collecting data on Attribute - answerData stored for each database record Record - answerRow in the table All the information you have about specific instances of an entity Field - answerColumn in the table All information you have of an attribute Prometheus approach to creating tables - answerTable Design Naming fields - answer1. Should be meaningful and descriptive 2. Allows you to use spaces, but not recommended 3. Use only letters and numbers, no symbols or special letters Data types for fields - answer1. Short Text (up to 255 characters) 2. Long Text (up to 65,536 characters) 3. Number (positive or negative) 4. Date/Time 5. Currency (number data type starting with $) 6. AutoNumber (Access automatically generates a number when a new record is added to the table) 7. Yes/No 8. OLE Object (stores files, recommended to use attachment instead) 9. Hyperlink (links to websites or folders/files on computer) 10. Attachment (stores files for a database record, could be virtually any format) 11. Calculated (creates a field generated by a formula, often refers to values in other fields) 12. Lookup Wizard (simplifies data entry, presents the user with a list of items to choose from when entering new record) Field properties - answer1. Field size (how large the field will be, how many characters, numbers, and precision) 2. Input Mask (sets rules for how the data will be entered in the field) 3. Default value (have an automatic starting value for the field when a new record is added) 4. Validation rule/validation text (checks values to make sure they fit a specific rule) 5. Required (makes sure that a value is entered for a field when a new record is added to a table) Primary Key - answeruniquely identifies each record in a table Often is the first field of the table Indicated by a small gold key to the left of the field Foreign Key - answerWhen a field is used to link two tables Normalization - answerThe process of organizing tables and relationships between tables 1. We want each table to contain data about very specific things 2. We want to limit duplicated or redundant information as much as possible Types of relationships between tables in a database - answer1. One to One (1:1) 2. One to Many (1:M) 3. Many to Many (M:M) One to One relationship - answerRepresents a situation where a record from one table can only be associated with one record from the other table One to Many relationship - answerMost common type of relationship Means that a single record from one table could be associated with more than one record from the second table, but a record from the second table can only be associated with one record from the first table