Access 2016 Quiz 1) What view normally appears when you double-click a table? (1 point) a.Datasheet...
Access 2016 Quiz
1)
What view normally appears when you double-click a table? (1 point)
a.Datasheet view
b.Form view
c.Design view
d.Layout view
2)
What type of filter displays records based on a criterion you choose? (1 point)
a.Exact Match filter
b.Selection filter
c.Toggle filter
d.Filter by Report
3)
Which of the following is not a valid criteria in a filter? (1 point)
a. Is Null
b. =>14
c. ="Fred"
d. <>125
4)
To view or modify a table's structure you would go to what view? (1 point)
a. Design
b. Form
c. Layout
d. Datasheet
5)
How many records do most forms display? (1 point)
a. All the records at the same time
b. 0 (Forms don't display records)
c. 1
d. 2
6)
To move a field you ________. (1 point)
a. right-click the column heading and select Move Column
b. left-click the column heading, then drag the field to where you want it
c. do nothing. You can't move a field
d. right-click the column heading, then drag the field to where you want it
7)
Most users enter information into a database through the use of a ________. (1 point)
a. macro
b. form
c. table in datasheet view
d. query
8)
Which method of creating a database demands the least amount of expertise in Access? (1 point)
a. Importing an Excel spreadsheet
b. Using a template
c. Creating a blank desktop database
d. Creating a custom web app
9)
If you want fewer records to display, you should use which operator in your filter? (1 point)
a. AND
b. OR
c. NOR
d. NOT
10)
What are the two ways you can view a table? (1 point)
a. Datasheet and Form views
b. Design and Datasheet views
c. Design and Layout views
d. Datasheet and Layout views
Homework Answers
Access 2016 Quiz
1) What view normally appears when you double-click a table?
Answer : a.Datasheet view
2) What type of filter displays records based on a criterion you choose?
Answer :b.Selection filter
3) Which of the following is not a valid criteria in a filter?
Answer : b. =>14
4) To view or modify a table's structure you would go to what view?
Answer : a. Design
5) How many records do most forms display?
Answer : c. 1
6) To move a field you ________
Answer : b. left-click the column heading, then drag the field to where you want it
7) Most users enter information into a database through the use of a ________.
Answer :b. form
8) Which method of creating a database demands the least amount of expertise in Access?
Answer :b. Using a template
9) If you want fewer records to display, you should use which operator in your filter?
Answer :a. AND
10) What are the two ways you can view a table?
Answer : b. Design and Datasheet views
Add Answer to:
Access 2016 Quiz
1)
What view normally appears when you double-click a table? (1
point)
a.Datasheet...
If the focus in a form moves from left to right and you want the focus...
If the focus in a form moves from left to right and you want the focus to move from top to bottom, change the _____. . a. . sort order . b. . tab order . c. . form layout . d. . focus grouping What do you change when you drag the right border of a form in Form Design view? . a. . the layout of the form . b. . the width of the form ....
1. You typically increase the decimal places from 1 to 2 for a(n) _____ field. A....
1. You typically increase the decimal places from 1 to 2 for a(n) _____ field. A. Currency B. AutoNumber C. Long Text D. Money 2. What button do you use on the Query Tools Design tab to add a field list to a query? A. Field List button B. Show Table button C. View button D. Table Names button 3. _____ view provides the most options for defining fields. A. Field Create B. Field Define C. Table Create D. Table...
(b) Form view. (c) Design view. (d) Print Preview. (a) You can group record state. (b)...
(b) Form view. (c) Design view. (d) Print Preview. (a) You can group record state. (b) You can sort records i (c) A sort can only be set (d) You can either group 5. Which of the following views provides you with the most flexibility in modifying forms and reports? (a) Design view (b) Layout view (c) Form view/Report view (d) Print Preview 6. Which of the following statements about reports is false? (a) Reports can be saved to a...
Label the elements of the Access window shown in FIGURE 10-23. FIGURE 10-23 | All Access...
Label the elements of the Access window shown in FIGURE 10-23. FIGURE 10-23 | All Access Obje « Match each term with the statement that best describes it. 9. Database 10. Object 11. Form 12. Record 13. Table 14. Field a. One row of data in a database table b. Information about one item in a particular record in a database c. An app component, such as a table or form that is saved in a database d. A collection...
Hide/Show Time Remaining Part 1 of 1- Question 1 of 38 When designing a new database,...
Hide/Show Time Remaining Part 1 of 1- Question 1 of 38 When designing a new database, the first question users should ask themselves is O A. How much information is going to be stored in this database? B. Where should this database be stored? O C. Who is going to use this database? O D. What questions should this database be able to answer? Question 2 of 38 When linking two tables in a relational database, a user will use...
1. If you want to change the size of a part of a shape relative to...
1. If you want to change the size of a part of a shape relative to the rest of the shape, what do you drag? A. Sizing handle B. Control handle C. Proportion handle D. Adjustment handle 2. Gabriella plans to print her slides on a printer that does not print in color. Which of the following actions should she do before she prints the entire presentation? A. View the presentation in grayscale. B. Print one test slide. C. Change...
Start Access. Open the downloaded Access file named exploring_acap_grader_a1_Loans.accdb. Import the exploring_acap_grader_a1_Clients.xlsx Excel workbook into a...
Start Access. Open the downloaded Access file named exploring_acap_grader_a1_Loans.accdb. Import the exploring_acap_grader_a1_Clients.xlsx Excel workbook into a table named Clients. While importing the data, make sure to select the option First Row Contains Column Headings, and select ClientID as the primary key field. After you have completed the import, open the Clients table in Design view. Change the ClientID field size to 6 and remove the @ symbol from the ClientID format property. Change the ZIP field size to 5. Change...
37. What happens when you double-click one of the graphic options in the middle panel of the Choo...
37. What happens when you double-click one of the graphic options in the middle panel of the Choose a SmartArt Graphic dialog box? a. You are prompted for the location where the graphic should be placed b. You are prompted to choose a design theme for the graphic. c. The graphic is inserted and the SmartArt Tools Design tab is displayed. d. The graphic is previewed but not inserted into the slide. e. None of above 38. To move a...
1. An _______ appears behind selected text. A) dotted line B) double-arrow point C) blue line...
1. An _______ appears behind selected text. A) dotted line B) double-arrow point C) blue line D) shaded background 2. An alternate method to open up the Word Count dialog is to click ________ on the status bar at the bottom of the Word window. A) words B) numbers C) count D) status 3. By default, when using the paste button, Word pasted the text using ________. A) source formatting B) merge formatting C) no formatting D) object formatting 4....
abc HW 17 (1) Design Layout References Mailings Review View Help Tell me what you want...
abc HW 17 (1) Design Layout References Mailings Review View Help Tell me what you want to do nada hinaw 1 Normal 1 No Spac.. Heading 1 Heading 2 Title Font Paragraph Styles 15) An asteroid of mass 58,000 kg with a negative charge of 15 uC is 180 m from a second asteroid of mass 52,000 kg with a negative charge of 11 μ What is the magnitude of the net force the asteroids exert upon each other, if...
(b) Form view. (c) Design view. (d) Print Preview. (a) You can group record state. (b) You can sort records i (c) A sort can only be set (d) You can either group 5. Which of the following views provides you with the most flexibility in modifying forms and reports? (a) Design view (b) Layout view (c) Form view/Report view (d) Print Preview 6. Which of the following statements about reports is false? (a) Reports can be saved to a...
Label the elements of the Access window shown in FIGURE 10-23. FIGURE 10-23 | All Access Obje « Match each term with the statement that best describes it. 9. Database 10. Object 11. Form 12. Record 13. Table 14. Field a. One row of data in a database table b. Information about one item in a particular record in a database c. An app component, such as a table or form that is saved in a database d. A collection...
Hide/Show Time Remaining Part 1 of 1- Question 1 of 38 When designing a new database, the first question users should ask themselves is O A. How much information is going to be stored in this database? B. Where should this database be stored? O C. Who is going to use this database? O D. What questions should this database be able to answer? Question 2 of 38 When linking two tables in a relational database, a user will use...
37. What happens when you double-click one of the graphic options in the middle panel of the Choose a SmartArt Graphic dialog box? a. You are prompted for the location where the graphic should be placed b. You are prompted to choose a design theme for the graphic. c. The graphic is inserted and the SmartArt Tools Design tab is displayed. d. The graphic is previewed but not inserted into the slide. e. None of above 38. To move a...
abc HW 17 (1) Design Layout References Mailings Review View Help Tell me what you want to do nada hinaw 1 Normal 1 No Spac.. Heading 1 Heading 2 Title Font Paragraph Styles 15) An asteroid of mass 58,000 kg with a negative charge of 15 uC is 180 m from a second asteroid of mass 52,000 kg with a negative charge of 11 μ What is the magnitude of the net force the asteroids exert upon each other, if...
Most questions answered within 3 hours.
-
An object with charge q = −4.00×10−9 C is placed in a region of
uniform electric...
asked 4 minutes ago -
A retired couple buys a new recreational vehicle (RV) for $ 50
comma 000.00 . They...
asked 2 minutes ago -
Question 1 (1 point)
What's measured in mass spectrometry?
Frequency
Atomic number
Mass
Molecular weight
Question...
asked 16 minutes ago -
Jupiter Satellite
Corporation earned $19.8 million for the fiscal year ending
yesterday. The firm also paid...
asked 22 minutes ago -
Your pizza restaurant uses the finest food ingredients to make
authentic brick-oven pizzas, and your mozarella...
asked 14 minutes ago -
How does social media affect and reflect on today’s culture?
asked 18 minutes ago -
Value-Stream Costing Objective
During the week of June 12, Harrison Manufacturing produced and
shipped 18,200 units...
asked 19 minutes ago -
The following chemical reaction occurs in a
basic solution.
Mg2+(aq) +
MnO2(aq) + OH−(aq) →
Mg(s)...
asked 32 minutes ago -
Visitor from Con Ed from a galaxy far away have placed a large
(black) ring of...
asked 37 minutes ago -
You are the CFO of Crane, Inc., a retailer of the exercise
machine Slimbody6 and related...
asked 32 minutes ago -
Since IoTs are difficult, or just about impossible, depending on
installed location, to secure, what does...
asked 40 minutes ago -
PTC is a substance that has a strong bitter tatse for some
people and is tasteless...
asked 54 minutes ago