ISTM 210 Exam 3 Access Questions & Answers 100% Correct!

Access Menu Ribbon - ANSWERSAt the top of the window Provides access to all of the features Access Object Navigation Pane - ANSWERSAt the side of the window Provided to help users interact with the various objects in database files Compact and Repair tool - ANSWERSIn 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 - ANSWERS1. Tables 2. Queries 3. Forms 4. Reports Tables - ANSWERSUsed to store the data in Access Consists of columns, which store data fields, and rows, which store database records Queries - ANSWERSUsed 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 - ANSWERSUsed 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 - ANSWERSUsed 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 - ANSWERS1. Object view 2. Design View 3. Layout View Object View - ANSWERSDisplays the finished object (Maybe a finished table) Design View - ANSWERSUsed to edit the object