Typically, when you create a subreport, the contains the one side of the one-to-many relationship. Subreport. Clauses. Operations. Properties. Main report. QUESTION 2 The formatting property that sets the fill color of your control such as a text box is: Layout Back Fill. Fore Color. Back Color. Visible. QUESTION 3 The property of a report that regulates which database fields are available in the report is the: Security Setting. Design Fields. Parameter. Field Range. Record Source QUESTION 4 The view that provides you with the most flexibility when you are creating a report is: Layout view. Design view. Table view. Object view. Datasheet view. If you need to create a report showing data from a table that includes a one-to-many relationship, create a(n): New table. Subreport. Action query. Subquery. Append query. QUESTION 6 This query property limits the number of records that display in a query. Display Number Filter Field Top Values Selective Values Max records QUESTION 7 To indicate dates, Access uses serial numbers that are based on: The number of days from January 1,1900. The binary number system. Metric intervals. The number of days from January 1, 2000. Geometric algorithms. QUESTION 8 One way to add fields to a report in Design view is to: Import. Copy and paste. Click and drag. Find and replace. Append. This query creates a new table in a database and also copies the records into the new table. Update query Append query Records query Duplicate query Make table query QUESTION 10 Any fields you use in a calculated control expression must be included in the: Record Source. Drop-down control menu. Access field inventory. Data Sorter. Subreport. QUESTION 11 A field that gets its value by accumulating a total over a set of records is called a(n) : Aggregator Running total. AutoSum. Count If field. AutoNumber. QUESTION 12 A query that is used inside another query is called a(n) : Subquery. Internal query. Conditional query. Dependent query. Action query. To retrieve the current time for your Access database, use the: Time content field. Now function. Date function. Date conversion button. Count function QUESTION 14 A query you can use to make changes to the data in an Access database is called a(n): Select query. Event query. Subquery. Action query. Editing query. QUESTION 15 To view the data in a database in an organized and professional way, use a: Form. Table. Query. Report. Template