A business sells its products online through its website. What type of database powers the website?
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?
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?
Describe the similarities between Access and Excel.
Describe the main features of Access.
Why would you use Access in a business environment?
How does the query grid (as opposed to using the Query Wizard) help you build and edit queries?
What is a query, and how can queries help a user understand their data?
How are relationships used in queries?
Why is it important to have the ability to add new records to an imported dataset?
Why should an Access user pay attention to the data entry symbols when changing records in a dataset?
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.
Why is it important to review and customize reports even after Access automatically generates them?
When might it be more appropriate to use Layout View rather than Design View in creating a new form?