Computer - Mock Test 68

Question 671

The following database object can you import from one MS-Access database to another?

A) Queries B) Tables C) Forms D) All of the above

---

No Details

Question 672

The type of query extract the data and put them into separate table?

A) A parameter query B) A make-table query C) An update query D) A crosstab query

---

No Details

Question 673

You can keep the sum([Sales]) to calculate the totals for each month in?

A) the report footer section B) the page footer section C) the month group footer section D) the summary section

---

No Details

Question 674

What is the propose to a sub datasheet?

A) To provide a hierarchical view of related tables or queries in a single window B) To display grouped data in a report C) To display summarized dat1⃣ D) All of the above

---

No Details

Question 675

To display sales grouped by country, region, and salesperson, all at the same time?

A) Use the Sort Descending command B) Use the Pivot table view command C) Use the find command on specified groups D) All of above

---

No Details

Question 676

What is the purpose of the description column in Table Design View?

A) To define the data type applied to each field within the table B) To describe the data that should be entered in each field C) To enter lookup data that the field should refer to. D) None of the above

---

No Details

Question 677

The checking operation performed on input data is called the?

A) Validation of data B) Verification of data C) Cross check D) Control of data

---

No Details

Question 678

What is the memo data type field used for?

A) To add table B) To store objects created in other programs C) For long text entries D) For shout text entries of no more than 255 characters

---

No Details

Question 679

How can you display sales grouped by country, region, and salesperson, all at the same time?

A) Use the Sort Descending command B) Use the Pivot table view command C) Use the find command on specified groups D) All of above

---

No Details

Question 680

The filter by selection feature allows you to filter?

A) Those records that match an entity in a field B) Records based on a criterion you specify C) Records that meet any of several criteria you specify D) All of above

---

No Details