Question 1 (Multiple Choice Worth 5 points)
Where can you see what items (such as tables, forms, reports, queries) are in the database you are using?
Navigation Pane
Home tab
External Data tab
Database Tools tab
Question 2 (Multiple Choice Worth 5 points)
How do you know if you need a relational structure?
When you have repeated data and/or you need to track actions or events
For a family tree where everyone is related
Have a small amount of information that needs to be analyzed
Have to perform a lot of calculations with the data
Question 3 (Multiple Choice Worth 5 points)
You should use Access when:
You need a relational data structure
Multiple users need to work on the data at the same time
You have a large amount of text data
All of the above
Question 4 (Multiple Choice Worth 5 points)
What is a flat data structure?
It is a simple list, not connected to other data.
It contains data that is simple and boring.
It contains a series of data tables that are unrelated to each other.
A complex database that is not related to any other database.
Question 5 (Multiple Choice Worth 5 points)
How do you base a new report on an existing table?
Copy and paste the table data into the new report
Select the table in the Navigation Pane and click Report on the Create tab
Click Microsoft Office Button, Save As, Report
On the Create tab, in the Reports group, click New Table
Question 6 (Multiple Choice Worth 5 points)
Which of the following are true statements about Excel and Access?
Access is designed for relational data while Excel is best for flat data structures.
Excel is designed for relational data while Access is best for flat data structures.
Access and Excel are both designed for relational data; Access is just a simpler program for beginners.
Access and Excel are both designed for flat data; Excel is just a simpler program for beginners.
Question 7 (Multiple Choice Worth 5 points)
What is a relational database structure?
It uses multiple tables to organize information; all tables in the database are related in some way.
It relates information in one database to information in another database.
It analyzes related information in each database.
It simply shows the relationships between different data entered for each related database.
Question 8 (Multiple Choice Worth 5 points)
Which of the following is a type of table template?
Events
Issues
Tasks
Contacts
All of these
Question 9 (Matching Worth 45 points)
MatchTermDefinition
AccessA) Best program for storing and maintaining data
ExcelB) Divides information into logical pieces and places each piece in a separate table
dataC) Prebuilt databases designed to suit your needs
PivotD) Interactive tables or charts
relational data structureE) Best program for analyzing data that has been collected
database templatesF) Used to enter information into Access
Navigation PaneG) Individual items of information
flat data structureH) Allows you to see what is in your database
data entry formI) A simple list unrelated to other data
Question 10 (Multiple Choice Worth 5 points)
What’s the fastest way to create a database for your contacts?
Click Contacts from Featured Online Templates
Click Blank Database
Go to Google and search for one
Click Assets from Featured Online Templates
Question 11 (Multiple Choice Worth 5 points)
What are Access templates?
Forms to be completed by the user
Pre-built databases for specific tasks
Ideas for new databases
None of these
Question 12 (Multiple Choice Worth 5 points)
What is available on the Getting Started page?
Online Database Templates
Blank Database button
Previously created databases
All of these
btw its 2007 Access Tutorials
btw its 2007 Access Tutorials
Technorati Tags: copy and paste, data access, data structure, data structures, data tables, database tools, family tree, home tab, microsoft, microsoft office, multiple choice, multiple users, navigation pane, queries, relational data, relational structure, true statements