1. The first step anyone should take in building a database is to:
a. Determine the version of access to use.
b. Determine the number of table that will be required.
c. Determine the purpose of the database.
d. Run an ERD analysis of the data information.
2. A data entry such as the last name of a customer should be:
a. Hosted in a singe record in a single table.
b. Hosted in two separate records in a single table.
c. Hosted in a separate record in two separate tables.
d. Input as a text file entry into a single table.
3. How does access identify each record within a database?
a. By the first field created for each record
b. By its primary key
c. By the table number
d. By the table's tabular chart ID
4. You are creating a series of fields for your customer database. You want to make sure that the data entry person always inputs a last name for each field. What is the most effective way to do this?
a. Format the filed to a different background color than the other fields.
b. Make it the first field in the table.
c. Make it the last field in the table.
d. Set it as a required field.
5. You need to configure the properties of a field that will list the hiring date for each employee so that the date is always displayed in the format. Which tab ribbon do you access to accomplish this?
a. Design tab
b. Format tab
c. Database tools tab
d. Description tab
6. You have a database comprised of thousands of records; each record representing a purchase by a customer, there is a field in the database that displays the shipping charge applied to each purchase. You have only three shipping charges, $5, $10, $15. You want to ensure that your data entry person inputs only one of these three numbers. You can accomplish this by setting ______ the field.
a. The format property of
b. The caption property of
c. A validation rule for
d. A default value for
7. Now that you know how to use access 2007, your boss wants you to convert many of the excel worksheets you used to create for data information to access databases. How do you do this?
a. Import the excel worksheets by clicking the office button and selecting import.
b. Click the excel button in the import group on the external data tab ribbon.
c. Click the excel button in the conversion group on the external data tab ribbon.
d. Click the excel button in the office application group on the design tab ribbon.
8. You create a table in access 2007 and link it to the source data in an excel worksheet that is stored on the same computer that hosts access 2007. What is the benefit of doing this?
a. Any future changes made to the worksheet will be reflected within the access table.
b. Once the import process is complete, excel will archive the worksheet.
c. Once the conversion process is complete, excel will archive the worksheet.
d. Access will open the excel program whenever this table is opened in access.
9. You have a field in your customer database for phone numbers. You want the field to display a hyphen within the number requiring the data entry person to enter it. How do you do this?
a. Set the hyphen as a default value for the field.
b. Create a validation rule for the field.
c. Format the field for the hyphen character.
d. Use the input mask wizard and select the hyphen.
10. What is the purpose of creating a lookup column in access?
a. To create a field that will compare itself to other fields within the same database
b. To create a field that will compare itself to other fields from other databases
c. To retrieve values from other sources such as other table or a list
d. To lookup format and style setting that match the data being inputted
11. What is the benefit for your data entry people by providing their data entries via combo boxes?
a. They can choose which formatting style they need by the click of a mouse.
b. It eliminates typing errors since data entries are selected by the mouse.
c. It combines multiple fields into one simple input box.
d. It will add the field entry into all other related fields upon entering the data.
12. The most common relationship in access 2007 is:
a. One-to-one
b. One-to-many
c. Many-to-many
d. Many-to-one
13. You modify the primary key values in one table of your database and all the related records in another table are automatically updated. You have just witnessed an example of a (n) _______ update.
a. Cascading
b. Relational
c. Intermediate relation
d. Intermediate integrity
14. One of your suppliers has gone out of business. You want to delete its record from your database and ensure that it is deleted from all related tables. The best way to accomplish this is to implement a (n) ________ delete.
a. Intermediate relation
b. Relational
c. Cascading
d. Total
15. You wish to create a form in access 2007. The easiest way to do this is to click the form button on the ________ tab ribbon.
a. Home
b. Design
c. Database
d. Create
16. You want to use the snipping tool application to do a screen capture of your open access screen. To access it you need to select it from the:
a. Office button
b. Design tab ribbon
c. Accessories folder from the start menu
d. Administrative tools in the start menu
17. You have created a form in access 2007 but the form is blank. What could be the reason?
a. The table for the form has no data
b. A table has not been assigned to the form
c. A column has not been assigned to the form
d. A database has no been assigned to the form
18. You want to insert a text box into a form you are creating in access 2007. You can do this by clicking the text box button from the_______ group on the _______ tab ribbon.
a. Object; insert
b. Object; design
c. Controls; create
d. Controls; design
19. You want to modify the tab order of a form you are creating. You need to access the tab order button from the _______ layout group on the _______ tab ribbon.
a. Control; design
b. Control; arrange
c. Form; design
d. Form; arrange
20. You have opened the snipping took and want to capture the entire screen of your computer and save it to your computer. You can do this by click the:
a. New button and click full-screen snip
b. Snip button and click the full-screen snip
c. New button and drag the mouse across the entire screen
d. Snip button and drag the mouse across the entire screen