Explain how to run an SQL query in Microsoft Access
What will be an ideal response?
To run an SQL query in Microsoft Access, start on the Create command tab. Click the Query Design button, which will display a Query window together with the Show Tables dialog box. Close the Show Tables dialog box by clicking the Close button, and then click the SQL View button on the Design command tab to switch the Query window to SQL View. An SQL statement can now be entered into the Query window. To execute the query after the SQL statement is complete, click the Run button on the Design command tab.
You might also like to view...
When a retailer purchases excess inventory of a product while it is on-deal to sell later when it is off-deal, the process is:
A) a diversion B) quantity-seeking C) forward buying D) a slotting fee
A debit has an unfavorable effect on an account
Indicate whether the statement is true or false
Lettuce, tomatoes, patty, bun, and ketchup are included in the output of making a hamburger.
Answer the following statement true (T) or false (F)
It is important to record the facts of an interaction with a customer in CRM software but not your conclusions, because:
A) it is never appropriate to make conclusions from data without consulting the research department B) recording conclusions is a breach of ethics C) coworkers could use this information to sabotage your sales D) this information could become available to the customer in the future E) the competition has access to the same databases you do