Written Questions
32
.
A business sells its products online through its website. What type of database powers the website?
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?