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) Four types of objects in Access - answer1. Tables 2. Queries 3. Forms 4. Reports 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)