QUESTION 1 A(n) _____ query changes the values in a field. a. Change Value b. Make-Table...
QUESTION 1
A(n) _____ query changes the values in a field.
| a. |
Change Value |
|
| b. |
Make-Table |
|
| c. |
Append |
|
| d. |
Update |
QUESTION 2
After running a Delete query, you cannot _____.
| a. |
save the query |
|
| b. |
undo the deletions |
|
| c. |
run another action query |
|
| d. |
view the table with the deleted records |
QUESTION 3
All the fields selected in a(n) _____ query must match fields with the same data types in the target table.
| a. |
Crosstab |
|
| b. |
Apply |
|
| c. |
Make-Table |
|
| d. |
Append |
QUESTION 4
In a datasheet, which mode do you use for changing the value of a field?
| a. |
Edit mode |
|
| b. |
Update mode |
|
| c. |
Modify mode |
|
| d. |
Navigation mode |
Homework Answers
QUESTION 1 Update QUESTION 2 undo the deletions QUESTION 3 Append QUESTION 4 Edit mode
Add Answer to:
QUESTION 1
A(n) _____ query changes the values in a field.
a.
Change Value
b.
Make-Table...
16) What does Access do to denote action queries differently in the Navigation pane? A) It...
16) What does Access do to denote action queries differently in the Navigation pane? A) It displays them in bold text. B) It displays them in a larger typeface. C) It displays them in a section called Action queries. D) It displays them using specific icons. 17) Which of the following is not a rule for using an Append query? A) Data types in both tables much match (with some exceptions). B) There must be the same number of fields...
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...
erms Matching Match the key terms with their definitions. Write the key term letter by the...
erms Matching Match the key terms with their definitions. Write the key term letter by the appropriate numbered definition k. Foreign key 1. Multitable query m. Nul a. AND condition b. Auto Number c. Caption property d. Cascade Delete Related Records e. Cascade Update Related fields f. Comparison Operator 8. Criteria row h. Data redundancy i. Data type 1. Field property o. OR condition p. Query q. Referential Integrity r. Simple Query Wizard 5. Wildcard Special character that can represent...
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 ....
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...
QUESTION 9 You plan to query data using the TRANS_HIST_V view that was created by another...
QUESTION 9 You plan to query data using the TRANS_HIST_V view that was created by another user in their schema. Which statement is true? A. The Oracle Server will retrieve the view definition from the ALL_VIEWS data dictionary view. B. The Oracle Server will retrieve data, determined by the query criteria, from the TRANS_HIST_V view. C. The Oracle Server will verify whether you have been granted access privileges to the TRANS_HIST_V view. D. The Oracle Server will automatically reset the...
Question 3:9 points Earth's Magnetic Field: The following data were recorded from the horizontal component of earth's magnetic field R: radius of the coil. N: Number of turns experiments....
Question 3:9 points Earth's Magnetic Field: The following data were recorded from the horizontal component of earth's magnetic field R: radius of the coil. N: Number of turns experiments. N 250 turns R 7.5 cm tan Bave I (mA) 2.5 4.2 9.5 14.2 25.5 16 34 45 62 16 32 45 60 a) Fill the table. (2 points) b) Use the data in the table to plot a graph between the current I and tan a (3 points) c) Determine...
Hi good day i need homework help fast please d32 1./What is the maximum length that...
Hi
good day i need homework help fast please
d32 1./What is the maximum length that a VARCHAR data type can be: a. 65535 b. 1023 C. 255 d. 32767 2.) Why are alias' used for table and columns? a. to make the names easier to understand b. to hide the column or table c. to be able to remove them from the database d. to give the appearance that they are new- 3.)What does the FIELD function allow you...
QUESTION 13 PRESENT VALUE TABLES Table A: PV of $1 (Annuity) Table B: Present Value of...
QUESTION 13 PRESENT VALUE TABLES Table A: PV of $1 (Annuity) Table B: Present Value of $1 4% 5% 6% 7% 8% 9% 10% N 4% 5% 6% 7% 8% 9% 10% 1 0.96 0.95 0.94 0.93 0.93 0.92 0.91 1 0.96 0.95 0.94 0.93 0.93 0.92 0.91 2 1.89 1.86 1.83 1.81 1.78 1.76 1.74 2 0.92 0.91 0.89 0.87 0.86 0.84 0.83 3 2.78 2.72 2.67 2.62 2.58 2.53 2.49 3 0.89 0.86 0.84 0.82 0.79 0.77 0.75...
QUESTION 1 Match the following: an SQL command that retrieves data A. Communicate B. RETRIEVE C....
QUESTION 1 Match the following: an SQL command that retrieves data A. Communicate B. RETRIEVE C. exception D. ReadFile E. STORE F. array G. try - catch block H. Connection I. Disconnect0) J. StreamReader K. Respond L. SQL M. Fork N. Query O. BlowUp P. SELECT Q. Close0 R. StreamWriter S. WriteFile T. UPDATE an SQL command that changes data ., class that can be used to read data from a file , establishing communication with a database a method...
16) What does Access do to denote action queries differently in the Navigation pane? A) It displays them in bold text. B) It displays them in a larger typeface. C) It displays them in a section called Action queries. D) It displays them using specific icons. 17) Which of the following is not a rule for using an Append query? A) Data types in both tables much match (with some exceptions). B) There must be the same number of fields...
erms Matching Match the key terms with their definitions. Write the key term letter by the appropriate numbered definition k. Foreign key 1. Multitable query m. Nul a. AND condition b. Auto Number c. Caption property d. Cascade Delete Related Records e. Cascade Update Related fields f. Comparison Operator 8. Criteria row h. Data redundancy i. Data type 1. Field property o. OR condition p. Query q. Referential Integrity r. Simple Query Wizard 5. Wildcard Special character that can represent...
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...
Question 3:9 points Earth's Magnetic Field: The following data were recorded from the horizontal component of earth's magnetic field R: radius of the coil. N: Number of turns experiments. N 250 turns R 7.5 cm tan Bave I (mA) 2.5 4.2 9.5 14.2 25.5 16 34 45 62 16 32 45 60 a) Fill the table. (2 points) b) Use the data in the table to plot a graph between the current I and tan a (3 points) c) Determine...
Hi
good day i need homework help fast please
d32 1./What is the maximum length that a VARCHAR data type can be: a. 65535 b. 1023 C. 255 d. 32767 2.) Why are alias' used for table and columns? a. to make the names easier to understand b. to hide the column or table c. to be able to remove them from the database d. to give the appearance that they are new- 3.)What does the FIELD function allow you...
QUESTION 13 PRESENT VALUE TABLES Table A: PV of $1 (Annuity) Table B: Present Value of $1 4% 5% 6% 7% 8% 9% 10% N 4% 5% 6% 7% 8% 9% 10% 1 0.96 0.95 0.94 0.93 0.93 0.92 0.91 1 0.96 0.95 0.94 0.93 0.93 0.92 0.91 2 1.89 1.86 1.83 1.81 1.78 1.76 1.74 2 0.92 0.91 0.89 0.87 0.86 0.84 0.83 3 2.78 2.72 2.67 2.62 2.58 2.53 2.49 3 0.89 0.86 0.84 0.82 0.79 0.77 0.75...
QUESTION 1 Match the following: an SQL command that retrieves data A. Communicate B. RETRIEVE C. exception D. ReadFile E. STORE F. array G. try - catch block H. Connection I. Disconnect0) J. StreamReader K. Respond L. SQL M. Fork N. Query O. BlowUp P. SELECT Q. Close0 R. StreamWriter S. WriteFile T. UPDATE an SQL command that changes data ., class that can be used to read data from a file , establishing communication with a database a method...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago