Exam 1: Creating a Database

The only option available for creating tables in Access is to use the datasheet view.

When copying and pasting records from one table to another, the records must first be copied to the ____.

A question asked about the data stored in a database is called a primary key.

Complete field names for all fields are not visible in the table. Which Access feature can Marissa use to make the entire field name visible while entering data?

Data can be presented in customized and useful ways different from tables and queries by using a Simple ____________________.

The default ____________________ provided by Access is the ID field.

-Clicking on the Close option from the Backstage view in Access 2013 performs which of the following tasks?

-Which Access database object(s) might be used to enter, edit, and view records in a database?

Experienced database developers avoid using spaces in field names and object names because names with spaces might cause errors if the objects are involved in ____.

An important reference tool available in Access 2013, which may be used to assist a user with problems that might occur, is the ____________________ system.

Records in separate tables may be connected through a(n) ____________________ that appears in both tables.

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. -When Lisel created the Participants table for the event participants, she used the Access default primary key field and did not change the name of the field. What field name was used as the primary key in the Participants table?

MATCHING -A status box that displays the number of the current record and the total number of records in a table.

Which field is the primary key (unique identifier) in the Customer Table?

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. -What is the minimum number of tables that must be created for this database?

-In the accompanying figure, which number corresponds to the datasheet selector which selects all records in a table?

The query results are stored in the database in which the query has been created. _________________________

Which Access 2013 view shows the contents of a table as a datasheet?

Which button is used to open and close the Navigation Pane?

The process of decreasing the file size of a database and enhancing the performance of the database is called ____________________ the database.