33 .
A business needs to analyze its sales figures for the past two years. What type of system holds the historical data that could be used in analytics?
34 .
Why is it advantageous for a database to be able to model real-world relationships in data, such as the relationship between a customer and their purchase history?
35 .
Describe the similarities between Access and Excel.
36 .
Describe the main features of Access.
37 .
Why would you use Access in a business environment?
38 .
How does the query grid (as opposed to using the Query Wizard) help you build and edit queries?
39 .
What is a query, and how can queries help a user understand their data?
40 .
How are relationships used in queries?
41 .
Why is it important to have the ability to add new records to an imported dataset?
42 .
Why should an Access user pay attention to the data entry symbols when changing records in a dataset?
43 .
Give an example of a case in which it may be more efficient to use the Datasheet View of a table instead of using queries to examine records.
44 .
Why is it important to review and customize reports even after Access automatically generates them?
45 .
When might it be more appropriate to use Layout View rather than Design View in creating a new form?