63) To search for a three-digit number that starts with \"75\" you would enter _
ID: 3581591 • Letter: 6
Question
63) To search for a three-digit number that starts with "75" you would enter ________.
A) 75?
B) 75#
C) 75*
D) 75!
41) Which of the following is NOT true regarding table formatting?
A) In a table design, you can define a Format field property that customizes how data is displayed and printed in tables, queries, reports, and forms.
B) The Format property tells Access how data is to be displayed.
C) You can define your own custom formats for Currency and Number fields.
D) Formatting does not affect the way the data is stored.
43) Which of the following is NOT true regarding keys?
A) Each table should have a primary or a composite key to uniquely identify each of the records in the table.
B) A foreign key is a value in a table that is the primary key of another table.
C) The primary and foreign keys form the common field between tables that allow you to form a relationship between the two tables.
D) To define a foreign key, select the foreign key field and then click the Key button on the Ribbon.
44) Which of the following is NOT true regarding primary keys?
A) The primary key field is the field that identifies each record in a table.
B) When you define a primary key for a table, the field can be left blank until you have the opportunity to enter the data.
C) A common way of defining a primary key is to use a field specifically designed to identify the entity.
D) A numeric key is often assigned an AutoNumber data type that Access will fill as the data is entered.
45) Which of the following is NOT true regarding foreign keys?
A) The AutoNumber data type is typically used for foreign key fields.
B) A foreign key is a field in a table that stores a value that is the primary key in another table.
C) It is called foreign because it identifies a record in another table.
D) Foreign keys do not need to be unique in the table.
47) A university identifies a class by subject area and course number. The university has classes Math 101, Math 102, and MIS 101. It takes both subject and course number to identify a single course. The combination of the two fields is called a ________ key.
A) foreign
B) natural primary
C) composite
D) primary
57) Which of the following is NOT a step in creating a many-to-many relationship?
A) Create a junction table.
B) The junction table is on the many side of both relationships.
C) Populate the junction table after the relationships have been created.
D) Only add the keys to the junction table.
86) Which of the following is NOT true about using special operators?
A) Special operators are used to compare text values using Find & Replace along with the AND operator.
B) Special operators are used to determine whether values are between a range of values using the BETWEEN operator.
C) Special operators are used in a set of values using the IN operator.
D) Special operators are used to compare text values using wildcards using the LIKE operator.
90) In a query, if you wanted to display the number of records retrieved, you would use the ________ aggregate function.
A) Count
B) Sum
C) Average
D) Maximum
91) If you need to see a quick snapshot of statistics for a table or query, you can use the ________.
A) total row
B) aggregate row
C) Function pane
D) statistics button
Explanation / Answer
edited :
63> (B)
41> (D)
43> (D)
44> (B)
45> (A)
47> (C)
57> (D)
86> (A)
90> (A)
91> (D)
kindly give the approrpiate rating :)
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.