Microsoft Access Relational Database Design and Queries

Auto audio on: the next questions will be read aloud when you click Continue.

1. 1

   The diagram shows Customers.CustomerID connected to Orders.CustomerID, with 1 beside Customers and infinity beside Orders. What does this relationship mean?

   

   A One customer can be associated with many orders B Each customer must have exactly one order C One order can belong to many customers
2. 2

   Which field is the best primary key for a Customers table?

   A LastName, because most customers have one B CustomerID, using a unique AutoNumber value C City, because it helps group customers
3. 3

   In an Orders table, what is the role of CustomerID when it references the primary key of the Customers table?

   A It is a calculated field B It is a multivalued field C It is a foreign key
4. 4

   A table design shows OrderDate configured as Short Text. Which data type should be used instead to support date calculations and date-based filtering?

   

   A Date/Time B Long Text C Attachment
5. 5

   In the Edit Relationships dialog, which feature should be enabled to prevent an order from referencing a customer record that does not exist?

   

   A Cascade Update Related Fields only B Enforce Referential Integrity C Create New Database
6. 6

   CustomerID is AutoNumber in the Customers table. Which field configuration is normally required for the related CustomerID foreign key in the Orders table?

   A AutoNumber with a duplicate-value setting B Short Text with unlimited length C Number with Field Size set to Long Integer
7. 7

   The query diagram shows Customers linked to Orders with a standard inner join. Which records will the query return?

   

   A Only customers and orders with matching CustomerID values B Every customer, including those without orders C Only customers who have no matching orders
8. 8

   In an Access query, what does the criterion Like "A*" under the LastName field select?

   A Last names containing exactly one letter B Last names beginning with A C Last names ending with A
9. 9

   The image shows one Orders table containing OrderID, OrderDate, and three repeating groups of ProductID, ProductName, Quantity, and UnitPrice fields. What is the best redesign?

   

   A Add more product groups to allow larger orders B Combine every field into one Long Text field C Create an OrderDetails table with one record per product on each order
10. 10

    Which criterion turns an OrderDate query into a parameter query that asks the user for a starting date?

    A >= [Enter start date:] B >= "OrderDate" C Is Not Date()
11. 11

    To count the number of orders for each customer in the Totals query shown, which Total-row settings should be used?

    

    A CustomerID: Count; OrderID: Group By B CustomerID: Group By; OrderID: Count C CustomerID: Where; OrderID: First
12. 12

    Which expression correctly creates a calculated query field named LineTotal from Quantity and UnitPrice?

    A [LineTotal] = [Quantity] + [UnitPrice] B LineTotal; [Quantity] x [UnitPrice] C LineTotal: [Quantity] * [UnitPrice]
13. 13

    Customer records are frequently searched by LastName, but duplicate last names are valid. Which field property is most appropriate?

    

    A Indexed: Yes (Duplicates OK) B Indexed: Yes (No Duplicates) C Required: No, with no index
14. 14

    Referential integrity is enforced between Customers and Orders, and Cascade Delete Related Records is not enabled. Why might Access refuse to delete a customer?

    A The customer has no related order records B Related orders still reference that customer C The Customers table uses an AutoNumber primary key