Exit this survey
Microsoft Access 2007
1. Please answer the following questions. Thank You.
*
1
. Name
Name
2
. Department
Department
*
3
. Contact Number
Contact Number
4
. What is the basis of the Ribbon’s organization? (Pick one answer.)
What is the basis of the Ribbon’s organization? (Pick one answer.)
Commands are grouped alphabetically.
Commands you don’t use are not shown.
Commands are grouped around common activities.
Commands are listed on menus.
5
. What would be the fastest way to create a database for your contacts? (Pick one answer.)
What would be the fastest way to create a database for your contacts? (Pick one answer.)
Download a Contacts database template.
Click Blank Database.
Search for one on the Internet.
Buy an address book.
6
. How do you use an older database in Access 2007? (Pick one answer.)
How do you use an older database in Access 2007? (Pick one answer.)
Open the database and use the Save As command.
Send it as an e-mail attachment, using Microsoft Office Outlook® 2007.
Open the database in Access 2007, and the upgrade happens automatically.
Open the database and export its data to a new blank database in Access 2007.
7
. Access 2007 features cannot be shared with people who use earlier versions of Access. (Pick one answer.)
Access 2007 features cannot be shared with people who use earlier versions of Access. (Pick one answer.)
True
False
8
. What’s in an Access database? (Pick one answer.)
What’s in an Access database? (Pick one answer.)
Tables and nothing but tables.
Tables, forms, and reports.
One really big table.
9
. Which of the following would you use to print your data? (Pick one answer.)
Which of the following would you use to print your data? (Pick one answer.)
A form.
A report.
Either one.
10
. A form always shows everything that a table shows. (Pick one answer.)
A form always shows everything that a table shows. (Pick one answer.)
True
False
11
. Which of the following can provide data for a report? (Pick one answer.)
Which of the following can provide data for a report? (Pick one answer.)
A form
Another report
A query
12
. You should use Access in which of the following scenarios? (Pick one answer.)
You should use Access in which of the following scenarios? (Pick one answer.)
You need a relational data structure.
Multiple users need to work on the data simultaneously.
You have a large amount of text data.
All of the above.
13
. Why do you need to be careful when changing data types? (Pick one answer.)
Why do you need to be careful when changing data types? (Pick one answer.)
You can't store photographs after you change a data type.
You may lose data.
Access may convert all your text to numbers.
14
. Why does Access set data types as you enter data? (Pick one answer.)
Why does Access set data types as you enter data? (Pick one answer.)
They're a standard for most databases.
They help ensure accurate data entry.
They help you use storage space efficiently.
All of the above.
15
. How do you sort data? (Pick one answer.)
How do you sort data? (Pick one answer.)
Right-click any record in a datasheet and click Sort A to Z or Sort Z to A.
Click the Ascending or Descending buttons, located on the Home tab, in the Sort & Filter group.
Click the arrow located to the right of any column header, and then click Sort A to Z or Sort Z to A.
All of the above.
16
. Filters remove unwanted data from your data sheet. (Pick one answer.)
Filters remove unwanted data from your data sheet. (Pick one answer.)
True
False
17
. How do you hide a column? (Pick one answer.)
How do you hide a column? (Pick one answer.)
Select and right-click a cell, then click Hide Columns.
Click the column header, and on the Datasheet tab, in the Fields & Columns group, click Hide.
Right-click the column header and click Hide Columns.
18
. What is Layout View? (Pick one answer.)
What is Layout View? (Pick one answer.)
A view available in forms and reports that allows you to see data and still make changes to the form or report.
A view that allows you to make a wide variety of changes but you cannot see the data.
The view that Access uses when a table or report is first opened.
19
. What is the function of a primary key? (Pick one answer.)
What is the function of a primary key? (Pick one answer.)
To uniquely identify each record in a table.
To encrypt and decrypt your database.
To help ensure you enter data in the correct table.
20
. A good database design helps ensure that your data is what? (Pick one answer.)
A good database design helps ensure that your data is what? (Pick one answer.)
Always backed up.
Complete and accurate.
Duplicated so it’s easier to find.
21
. To create a one-to-many relationship, you do which of the following? (Pick one answer.)
To create a one-to-many relationship, you do which of the following? (Pick one answer.)
Use the primary key from the table on the “one” side as a foreign key in the table on the “many” side.
Use a junction table with at least two foreign key fields.
Turn off indexing for the primary key field.
22
. Referential integrity is useful because it does which of the following? (Pick one answer.)
Referential integrity is useful because it does which of the following? (Pick one answer.)
Takes the place of an index.
Keeps primary and foreign key values in sync.
Allows you to “orphan” data safely.
23
. All reports must contain which of the following? (Pick one answer.)
All reports must contain which of the following? (Pick one answer.)
A title section.
A date/time section.
A detail section.
A footnote section.
24
. What’s the really important thing to remember when designing reports? (Pick one answer.)
What’s the really important thing to remember when designing reports? (Pick one answer.)
They must be clear and easy to understand.
They must contain a date and time.
They must group data in some way.
They must use all the available report sections.
Powered by
SurveyMonkey
Create your own
free online survey
now!
Javascript is required for this site to function, please enable.