For a one-to-many relationship in the Access Relationships window, how can you tell which table is the many" table? O a. The one symbol identifies the many table. b. An infinity symbol identifies the "many" table. C. The many" table always appears to the left of the "one" table. d. The "manytable always appears below the "one" table. If you are creating a computed field that adds 10 percent to the UnitPrice field, how do you enter the UnitPrice field name in the expression? a. (UnitPrice) b. "UnitPrice" c. Unit Price O d. (UnitPrice] If you are sorting records by more than one field, which field is the first field that is evaluated for sorting purposes? a. minor sort key b. secondary sort key C. primary sort key d. maximum sort key If you want to select records containing the text Consulting in the ProjectType field, how does Access save the criterion in the query grid of Query Design View? O a. [Consulting] O b. "Consulting" Oc Consulting) O d. #Consulting In Access, if you want a query to list the ProductID. Category, and Description field values and sort the records by description within each category, how should you arrange the fields from left to right in the query design grid? O a. Description. Category, ProductID O b. ProductID. Description. Category O c. ProductID. Category. Description O d. Description ProductID. Category In general, what should be in place before you select fields from more than one table in Access Query Design View? O a. The tables should not contain fields with the same field name. b. The tables should be merged into one table. Oc. The tables should be related in a proper one-to-many relationships. d. The join line between the tables should be deleted. The Access query design grid contains the ProductID. Product Name, and Rating fields. How can you omit the Rating field from the query results but use it to set a criterion for the query? O a. Change the query to an update query. O b. Delete the Rating field from the query design grid. O c. Clear the checkmark from the Rating field's Show check box. Od. Add a second copy of the Rating field to the query design grid. is a question about the data structured in a way that the DBMS can recognize and process. a. query b. relationship c. product d. tuple