TEST QUESTIONS AND CORRECT ANSWERS
COMPLETE SOLUTION VERIFIED PASS
●● Navigation Pane
Answer: provides way for user to interact w/various objects in database
files
●● Types of Objects
Answer: Tables
Queries
Forms
Reports
●● Tables
Answer: used to store data in access. Columns- store data fields
rows- store database records. Most important
●● Queries
Answer: used to find specific data you need from a database. Does not
give a copy of data, rather a diff view
,●● Forms
Answer: Used 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
Answer: allow you to organize and present data. Aids in managerial
decision making. Generates from tables or queries.
●● Views
Answer: different ways to look at an object
●● Access is a
Answer: relational database
●● Naming fields should be
Answer: meaningful and descriptive- spaces not recommended, no
special characters
●● Short Text
Answer: store data that won't be treated like a number for calculations.
Ex. Phone #'s and zip codes. limited to 255 characters
, ●● Long Text
Answer: stores large amts. of text. Limited to 65,536 characters.
●● Number
Answer: stores + and - #'s. Can contain decimal. Used for calculations
●● Date/Time
Answer: store date or time info. Can be formatted to display in several
diff ways.
●● Currency
Answer: number data type that places $ symbol in front
●● Autonumber
Answer: automatically insert value for autonumber field when a new
record is added to a table
●● Yes/no
Answer: store data with only 2 possible values. T/F, On/Off, Yes/No
●● OLE object
Answer: used to store files created by other programs like Word, Excel,
etc.