Exam 2: Creating a Database

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.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?

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

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

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

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.Based on the table descriptions, which fields might be used to create a relationship between the Vendors and Venue tables?

Another term used for the column selector feature is ____.

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

When working with Access in ____ Mode, the user may tap the buttons on the Ribbon and also tap to use other features of Access 2013.

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

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) ____________________.

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

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

A single characteristic or attribute of a person, place, object, event, or idea is a(n) table . _________________________

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

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 -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.Which data type is best for the field that will contain the customer's street address?