Deck 18: Maintaining and Querying a Database

Question 1

​ The deletion of a record is temporary and can be undone.

Answer 1

False

Question 2

Which of the following is true of working with queries in Microsoft Access 2016? ​

A)Queries cannot be saved or modified.
B)Queries can be created only in Datasheet view.
C)Queries cannot be based on other queries.
D)Queries can be based on multiple tables.

Answer 2

D

Question 3

​ In Microsoft Access 2016, you can specify a format for a calculated field, just as you can for any field, by modifying its properties.

Answer 3

True

Question 4

In Microsoft Access 2016, the order of the fields in the design grid cannot be changed. ​

Question 5

In Microsoft Access 2016, a record in a primary table that has matching records in a related table can be deleted even if the option to cascade deletions to related records is not selected. ​

Question 6

​ In Microsoft Access 2016, if you want to delete a record from the primary table, you first must delete the related records in the related table.

Question 7

In Microsoft Access 2016, the answer to a select query is returned in a query datasheet. ​

Question 8

In Microsoft Access 2016, the Total row added to a datasheet cannot be removed.

Question 9

In Microsoft Access 2016, which of the following occurs when the Ctrl+End keys are pressed? ​

A)The files are saved and the application is closed.
B)The last field in the last record is selected.
C)The application is closed and unsaved data is lost.
D)The current record is deleted from the database.

Question 10

In Microsoft Access 2016, to create a query that retrieves data from multiple tables, the tables must have unique fields.

Question 11

In Microsoft Access 2016, the count function determines the total of the field values for the selected records.

Question 12

Identify a true statement about modifying queries in Microsoft Access 2016. ​

A)A field's values cannot be hidden in the query results.
B)A field is not removed from the query design by hiding the field value.
C)The order of the fields in a design grid should not be changed.
D)Fields cannot be added to or removed from a query.

Question 13

In the accompanying figure of a Microsoft Access 2016 document, if you check the option that Box 1 is pointing to, the _____. ​ ​

A)data in a query data sheet is duplicated
B)table is not hidden in the database
C)field is displayed in the query datasheet
D)queries are saved for future modification

Question 14

Which of the following is true of working with queries in Microsoft Access 2016? ​

A)Query results cannot be seen in a query datasheet.
B)Fields and records should not be specified in a query.
C)Queries cannot be updated in a query datasheet.
D)Data in a query datasheet is not duplicated.

Question 15

After you run a query, the query datasheet uses a default column name that cannot be changed.

Question 16

In Microsoft Access 2016, calculations, such as sums, averages, minimums, and maximums, cannot be performed on the displayed records using a query datasheet.

Question 17

In Microsoft Access 2016, queries cannot be based on multiple tables. ​

Question 18

In the accompanying figure of a Microsoft Access 2016 document, Box A points to a _____. ​

A)design grid
B)resized field list
C)recordset
D)subdatasheet

Question 19

In Microsoft Access 2016, hiding a field's values removes the field from the query design. ​

Question 20

Identify an accurate statement about deleting a record in Microsoft Access 2016. ​

A)The entire row for a record in a datasheet need not be selected before deleting the record.
B)The deletion of a record is permanent and cannot be undone.
C)An entire row containing a record cannot be deleted at once.
D)A record cannot be deleted once all the fields have been filled and the database has been saved.

Question 21

In the accompanying figure of a Microsoft Access 2016 document, which of the following is Box 1 pointing to? ​ ​
​

​

A)Remove Selection button
B)Toggle Filter button
C)Advanced Filter button
D)Remove Sort button

Question 22

In the accompanying figure of a Microsoft Access 2016 document, which of the following is Box 1 pointing to? ​ ​

A)Tertiary sort field
B)Primary sort field
C)Secondary sort field
D)Quaternary sort field

Question 23

In Microsoft Access 2016, the Query Design button appears on the _____. ​

A)File tab
B)Table tab
C)Home tab
D)Create tab

Question 24

In the accompanying figure of a Microsoft Access 2016 document, which of the following fields will not appear in the query results and why? ​ ​
​

A)The FirstName field will not appear because it is being dragged.
B)The LastName field will not appear because the column is selected.
C)The City field will not appear because the Show check box is not selected.
D)The ClientID field will not appear because it is not the primary key field.

Question 25

In Microsoft Access 2016, you can select as many as _____ different sort fields. ​

A)16
B)12
C)10
D)20

Question 26

Which of the following statements is true of creating a copy of a query in Microsoft Access 2016? ​

A)Existing queries cannot be duplicated.
B)An existing query can be copied but cannot be renamed.
C)Creating a new query from scratch is faster than copying a query.
D)A query can be copied and pasted in the Navigation Pane.

Question 27

In the accompanying figure of a Microsoft Access 2016 document, which of the following boxes is pointing to the Alternate Row Color button? ​
​

A)Box A
B)Box B
C)Box C
D)Box D

Question 28

In the accompanying figure of a Microsoft Access 2016 document, which of the following symbols is Box 1 pointing to? ​ ​

A)Navigation icon
B)Expand icon
C)Filter icon
D)Edit icon

Question 29

In the accompanying figure of a Microsoft Access 2016 document, the criteria mentioned in the AgreementValue field yields query results that include records with a value _____. ​ ​

A)less than $25,000 in the AgreementValue field
B)greater than $25,000 only in the AgreementValue field
C)of 0 to $25,000 in the AgreementValue field
D)of $25,000 or more in the AgreementValue field

Question 30

Identify a true statement about working with related data in a subdatasheet in Microsoft Access 2016. ​

A)When the primary table is opened, the subdatasheet for each record in the primary table is collapsed until it is expanded by clicking the expand button.
B)After a one-to-many relationship between tables with a common field is defined, the Subdatasheet is present only in the secondary table in the relationship.
C)The subdatasheet does not display related records.
D)Records in subdatasheet cannot be deleted.

Question 31

James, a manager at Sugar Maple Inc., uses Microsoft Access 2016 to retrieve flight details. He wants to obtain information about all the flights except those with a SourceCity field value not equal to "Wisbane" To get the information, James should type _____ in the Criteria row in the SourceCity field. ​

A)NE (Wisbane)
B)!={Wisbane}
C)"Wisbane"
D)EXCEPT "Wisbane"

Question 32

To create a query with the And logical operator i n Microsoft Access 2016, _____. ​

A)all conditions should be specified in the same Criteria row of the design grid
B)each condition should be specified in a different Criteria row of the design grid
C)the word AND should be specified in the Criteria row of the design grid
D)the && operator should be specified in the Criteria row of the design grid

Question 33

In the accompanying figure of a Microsoft Access 2016 document, which of the following is Box 1 pointing to? ​ ​

A)Change Case buttons
B)Filter buttons
C)Sort buttons
D)Font Size buttons

Question 34

​ Zoya, a manager, uses Microsoft Access 2016 to manage employee details. To retrieve information about all the employees with AgreementValue not equal to $50,000, she should enter _____ in the Criteria row in the AgreementValue column.

A)Not equal to (50000)
B)!= {50000}
C)NE 50000
D)50000

Question 35

In Microsoft Access 2016, the Alternate Row Color button appears in the Text Formatting group on the _____. ​

A)Design tab
B)File tab
C)Create tab
D)Home tab

Question 36

Sarah, a manager, uses Microsoft Access 2016 to manage employee details. She enters "Dan" in the Criteria row in the FirstName column and "Smith" in the same Criteria row in the LastName column in the design grid. In this case, the query datasheet, created by Sarah, will include the records for employees with a FirstName field value _____. ​

A)not equal to Smith or a LastName field value equal to Dan
B)equal to Dan or a LastName field value equal to Smith
C)equal to Smith and a LastName field value not equal to Dan
D)equal to Dan and a LastName field value equal to Smith

Question 37

Marcus, a professor, uses Microsoft Access 2016 to retrieve and refine the records in a database that stores students' information. He wants to view the list of students whose percentage ends with .99. Which of the following operators should Marcus use to retrieve the list? ​

A)="??.99"
B)=".99"
C)Like "*.99"
D)Like "#.99"

Question 38

Tina, a teacher, uses Microsoft Access 2016 to manage student information. To retrieve the details of all the students who have a TotalScore field value of greater than 70 but less than or equal to 85, she should enter the condition _____ in the Criteria row in the TotalScore field. ​

A)>70 ||
B)70 && 85
C)From 70 to 85
D)Between 70 And 85

Question 39

Which of the following is a rule of referential integrity? ​

A)A record can be added to a related table even if a matching record exists in the primary table.
B)The value of the primary key in the primary table cannot be changed if matching records exist in a related table.
C)A record in the primary table can be deleted if matching records exist in the related table.
D)The Cascade Delete Related Records option cannot be used to delete records in the primary table as well as in a related table.

Question 40

Robert, a manager, uses Microsoft Access 2016 to retrieve employee details. He types 50000 in the Criteria box in the Salary column in the design grid and runs the query. The results for the query include all the records _____. ​

A)with values less than 50,000 in the Salary field
B)except the ones with 50,000 in the Salary field
C)with 50,000 in the Salary field
D)except the ones with values greater than 50,000 in the Salary field

Question 41

Case 18-3 Anna, the manager of a general store, uses Microsoft Access 2016 to maintain product information. She uses multiple criteria to retrieve specific details about products. She combines two or more conditions to filter the records based on her requirement.
Anna types Like "a*" in the Criteria row in the ProductName column and 25 in the same Criteria row in the RetailPrice column. In this case, the query datasheet, created by Anna, will include the records for products with a ProductName field value that :

A)begins with "a" or a RetailPrice field value not equal to 25.
B)ends with "a" or a RetailPrice field value equal to 25.
C)ends with "a" and a RetailPrice field value not equal to 25.
D)begins with "a" and a RetailPrice field equal to 25.

Question 42

Case 18-2 Ali, a librarian, uses Microsoft Access 2016 to maintain information about the books in his library. He retrieves details about the books and authors and filters selected records using queries.
Ali retrieves a list of the authors whose names start with the letters "Jef." He wants to filter this result by including names that have only 5 letters. Which of the following should Ali use to retrieve the names that follow both criteria?

A)="Jef**"
B)>="Jef.."
C)Like "Jef??"
D)In ("Jef"," $$")

Question 43

Case 18-1 Emily, a professor, uses Microsoft Access 2016 to manage student information. She refines queries to display selected records and enters criteria using operators to filter the records and display required information.
To retrieve the details of all the students except those with the FirstName field value "Andrew," Emily should enter _____ in the Criteria row in the FirstName column in the design grid.

A)!={"Andrew"}
B)"Andrew"
C)NOT LIKE = Andrew
D)EXCEPT(Andrew)

Question 44

In Microsoft Access 2016, the _____ determines the number of records selected. ​

A)Num function
B)Count function
C)Total function
D)Tally function

Question 45

Which of the following is true of creating queries with functions in Microsoft Access 2016? ​

A)Functions need to be applied to all the fields in a table and not to specific fields.
B)After a query is run, the query datasheet uses a default column name that cannot be changed.
C)Functions cannot operate the records that meet a query's selection criteria.
D)For each calculation to be executed on a field, the field should be added to the design grid.

Question 46

In Microsoft Access 2016, the _____ determines the total of the field values for the selected records. ​

A)Aggregate function
B)Count function
C)Tot function
D)Sum function

Question 47

Case 18-1 Emily, a professor, uses Microsoft Access 2016 to manage student information. She refines queries to display selected records and enters criteria using operators to filter the records and display required information.
To retrieve the details of all the students with an Age field value greater than 21 but less than or equal to 24, Emily should enter _____ in the Criteria row in the Age column in the design grid.

A)>21 ||
B)Between 21 And 24
C)From 21 to 24
D)21 && 24

Question 48

_____ is a Microsoft Access tool that makes it easy for you to create a mathematical expression. ​

A) Expression Builder ​
B)Expression Setup
C)Expression Engine
D)Expression Filter

Question 49

To create a query with the Or logical operator in Microsoft Access 2016, _____. ​

A)all of the conditions should be specified in the same Criteria row of the design grid
B)each condition should be specified in a different Criteria row of the design grid
C)the word OR should be specified in the Criteria row of the design grid
D)the || operator should be specified in the Criteria row of the design grid

Question 50

Case 18-1 Emily, a professor, uses Microsoft Access 2016 to manage student information. She refines queries to display selected records and enters criteria using operators to filter the records and display required information.
To retrieve the details of all the students with the LastName field value beginning with the letter "a" and ending with the letter "n," Emily should enter _____ in the Criteria row in the LastName column in the design grid.

A)In (a,n)
B)Like (a,n)
C)Like "a*n"
D)In "a*n"

Question 51

In Microsoft Access 2016, _________ is a query that retrieves the information that precisely matches the example you provide of the information being requested.

A)Simple Query Wizard
B)detail query
C)Query by example
D)sample query

Question 52

In Microsoft Access 2016, a(n) _________ is a query in which you specify the fields and records you want Access to choose.

A)action query
B)select query
C)parameter query
D)aggregate query

Question 53

In Microsoft Access 2016, the Builder button appears in the _____ on the Query Tools Design tab. ​

A)Query Setup group
B)Query Type group
C)Query Results group
D)Query Parameters group

Question 54

In the accompanying figure of a Microsoft Access 2016 document, which of the following boxes is pointing to the Property Sheet button? ​ ​

A) Box A ​
B)Box B
C)Box C
D)Box D

Question 55

Case 18-1 Emily, a professor, uses Microsoft Access 2016 to manage student information. She refines queries to display selected records and enters criteria using operators to filter the records and display required information.
Emily wants to retrieve records of students who are from China, Italy, and Mexico. Which of the following operators should Emily use for this purpose?

A)In ()
B)Between …
C)=
D) ​Compare

Question 56

Case 18-3 Anna, the manager of a general store, uses Microsoft Access 2016 to maintain product information. She uses multiple criteria to retrieve specific details about products. She combines two or more conditions to filter the records based on her requirement.
To retrieve details of all the products with a ProductName field value of "Briston" or a RetailPrice value not equal to $10, Anna should enter:

A)"Briston" in the Criteria row in the ProductName column and 10 in a different Criteria row in the RetailPrice column.
B)in the Criteria row in the ProductName column and !={10} in the same Criteria row in the RetailPrice column.
C)"Briston" in the Criteria row in the ProductName column and {10} in the same Criteria row in the RetailPrice column.
D)in the Criteria row in the ProductName column and !=10 in a different Criteria row in the RetailPrice column.

Question 57

Raj, a professor, uses Microsoft Access 2016 to manage student details. He enters 50 in the Criteria row in the PhysicsMarks column and 50 in a different Criteria row in the MathMarks column. In this case, the query datasheet, created by Raj, will most likely include the records for students with a PhysicsMarks field value : ​

A)equal to 50 and a MathMarks field value equal to 50.
B)not equal to 50 and a MathMarks field value not equal to 50.
C)equal to 50 or a MathMarks field value not equal to 50.
D)not equal to 50 or a MathMarks field value equal to 50.

Question 58

Case 18-2 Ali, a librarian, uses Microsoft Access 2016 to maintain information about the books in his library. He retrieves details about the books and authors and filters selected records using queries.
Ali wants to retrieve a record of books whose unit price is not between $30 and $60. Which of the following should Ali use in the Criteria box to retrieve a record that contains a value that is beyond the given range?

A)30; 60
B)= (30||60)
C)60
D)IN(30 && 60)

Question 59

Which of the following is true of storing calculations in a table in Microsoft Access 2016? ​

A)Calculated data stored in a table does not consume space.
B)Using the Calculated Field data type provides limited options for creating a calculation.
C)Including a calculated field in a table whose value is dependent on other fields in the table obeys database design principles.
D)The Calculated Field data type does not store the result of an expression as a field in a table.

Question 60

Case 18-3 Anna, the manager of a general store, uses Microsoft Access 2016 to maintain product information. She uses multiple criteria to retrieve specific details about products. She combines two or more conditions to filter the records based on her requirement.
To retrieve details of all the products with a RetailPrice field value equal to $10 and an OfferPrice field value not equal to $8, Anna should enter:

A)={10} in the Criteria row in the RetailPrice column and !={8} in the same Criteria row in the OfferPrice column.
B)10 in the Criteria row in the RetailPrice column and 8 in a different Criteria row in the OfferPrice column.
C)={10} in the Criteria row in the RetailPrice column and !={8} in a different Criteria row in the OfferPrice column.
D)10 in the Criteria row in the RetailPrice column and 8 in the same Criteria row in the OfferPrice column.

Question 61

In Microsoft Access 2016, a _________ is a query based on more than one table.

A)doubletable query
B)endtable query
C)inherittable query
D.  multitable query

Question 62

In Microsoft Access 2016, the _________ is the "one" table in a one-to-many relationship.

A)related table
B)primary table
C)secondary table
D)access table

Question 63

​ Explain database record maintenance in Microsoft Access 2016.

Question 64

In Microsoft Access 2016, _________ are used to extract data from a datasheet based on a field value.

A)conditional filters
B)common filters
C)field sorters
D)record sorters

Question 65

Explain property sheets in Microsoft Access 2016.

Question 66

In Microsoft Access 2016, _________ is the process of rearranging records in a specified order or sequence.

A)storing
B)compacting
C)sorting
D)filtering

Question 67

In Microsoft Access 2016, the _________ is the thin bar above each column in the design grid in a Query window that you click to select the entire field.

A)Menu bar
B)field selector
C)query modifier
D)Status bar

Question 68

In Microsoft Access, the _________ is the field used to determine the order of records in the datasheet.

A)common field
B)sort field
C)calculated field
D)data field

Question 69

In Microsoft Access 2016, the _________ is the "many" table in a one-to-many relationship.

A)primary table
B)secondary table
C)related table
D)access table

Question 70

In Microsoft Access 2016, the _________ divides the selected records into groups based on the values in the specified field.

A)Group By operator
B)Query by example
C)select group query
D)detail query

Question 71

In Microsoft Access 2016, _________ is used to filter a datasheet based on a selected field value in a datasheet or form.

A)filter by form
B)conditional filtering
C)autofiltering
D)filter by selection

Question 72

In Microsoft Access 2016, _________ are the conditions that determine which records are selected in a query.

A)Lookup Fields
B)criteria
C)Macros
D)modules

Question 73

​ How are calculated fields created in Microsoft Access 2016?

Question 74

In Microsoft Access 2016, a(n) _________ exists between two tables when one record in the first table matches zero, one, or many records in the second table, and when each record in the second table matches at most one record in the first table.

A)one-to-many relationship
B)many-to-many relationship
C)one-to-one relationship
D)many-to-one relationship