Exam 1: Creating a Database

-The ____________________ box in the Navigation Pane (displayed in the accompaying figure) allows the Access user to search for all database objects that contain a specific value, such as the city, "Albany."

Green Thumb Nursery is analyzing wholesale customer purchases and would like to create an Access database of wholesale customers and the wholesale prices for all of the nursery's products. When designing the database, it is necessary to determine the number of tables needed to provide the owner with the names, addresses, and contact information of the customers, as well as the product names and wholesale prices for each product. In addition, it is neccessary to know which products have been purchased by each customer. Andrea, the owner, wants to be able to print reports that show which customers bought specific products from the database. Answer the following questions related to this case. -Which data type is best for the field that will contain the customer's street address?

Case 1-1 Lisel is the Student Body President of her college. She is organizing a Fun Run/Walk fund-raising event to benefit the local Children's Hospital. Lisel wants to create an Access database to manage event vendors, the venue, participants, donors, and donations. Before the event takes place, Lisel and the student government representatives must contact vendors and ask for their participation in the event. Also, participants in the event must be registered and issued an entry number. Three tables are necessary for the database: Vendors, Participants, and Venue. Fields in the Vendors table will include: Vendor Name, Vendor Contact Information, Venue Space Assigned. Fields in the Participants table will include: FirstName, LastName, ParticipantNumber, Donation, and Donors. The Venue table will include: TentNumber and TentSize. Choose the best answer for the questions below. -Based on the table descriptions, which fields might be used to create a relationship between the Vendors and Venue tables?

Which Access 2013 view contains commands used to manage Access files and options?

Field values that may be entered into a field are determined by the data type of the field. _________________________

MATCHING -The specific content of a field.

What function does compacting an Access database perform other than reducing the file size?

-Which Access database object asks a question about the data stored in a database and displays specific fields and records that answer the question?

MATCHING -AutoNumber and Short Text are two examples of this Access feature which determines the values that may be entered in a field.

MATCHING -The Access Ribbon tab that offers the option for the user to compact and repair a database.

A table is a predesigned database that includes professionally designed database objects.

-Which view is used to make design changes to a form while the form is displaying data?

Explain why databases should be compacted, and list the steps to follow to compact a database.

This icon represents which Access 2013 object?

-Each record in a table is uniquely identified by a foreign key.

MATCHING -The Access Ribbon tab that allows the user to create database objects such as tables, forms, and reports.

A database or a relational database is a collection of related tables.

-In a relational DBMS, a user may create a database structure that contains which of the following?

The ____________________ option is available to compact and repair a database file automatically every time the database is closed.

Use the ____________________ feature on the Ribbon to see how many pages are in a report based on the current layout.