Exam 2: Creating a Database

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

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

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

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

Case 1-3 Main Street Catering has created a database with one table containing customer information. When creating the table, Marissa did not follow recommendations for naming fields in a table. There are a number of changes that would make the field names more useful and follow field naming recommendations. Using the accompanying figure, answer the following questions about the CustomerTable.Which field name follows the recommendation of capitalizing the first letter of each word and also follows the no spaces recommendation?

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

Which Access feature provides information about Access commands and features and instructions about how to use them?

Access report printing options may be changed using the Navigation dialog box. _________________________

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

This icon represents which Access 2013 object?

To save a table in Access with a name that relates to the database (a name other than the Access default name), it is necessary to complete which process?

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

The default primary key for an Access database is the ID field. _________________________

Case 1-1Lisel 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 view is used to make design changes to a form while the form is displaying data?

Case 1 -2 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?

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

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