Exam 1: Creating a Database

Which of the following terms describes the Access feature that allows a user to size a column in datasheet view so that the column is just wide enough to display the longest visible value in the column?

There are two ways to move vertically from one record to another in a table; use the vertical scroll bar or the ____________________.

Which term identifies a field that appears in two separate tables and may be used to connect records in the separate tables?

Which of the following attributes of a table are saved only when the table object is saved?

How many characters may a field name in Access contain including numbers, letters, spaces, and special characters?

MATCHING -The Access 2013 view that shows the number of pages that will be printed.

This icon represents which Access 2013 object?

-The accompanying figure shows the first dialog box for the ____ Wizard.

Each Access database may be as large as two gigabytes in size and may have up to 255 people using the database at the same time. _________________________

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. -Laquan, another student representative, has the responsibility of contacting the vendors for the event and assigning tent spaces to them. He needs to view data that uses fields from both the Vendor table and the Venue table. Which database tool would create the most concise list of vendors, vendor contact information, and assigned tent spaces: a query, a table, or a form?

Which of the following is the file extension used for Access 2013 database files?

Each row in an Access table datasheet displays which of the following?

-In the accompanying figure, the Table Tools tab is an example of this type of tab that appears and provides options for working with a specific object when the object is selected.

MATCHING -An Access 2013 tool that allows the user to quickly add fields and records to display in query results.

A field in a second table that is the primary key in the first table is used to form a relationship between the two tables; the field in the second table is called a(n) ____________________.

Clicking or tapping this navigation button moves the insertion point to the ____________________ in a table.

This icon represents which Access 2013 object?

A table's contents are shown in rows and columns when using the ____________________ view.

Files created with Access 2013 may be used with which previous version of Access?

All data in a database is contained in which database object?