Workshop
The Workshop includes quiz questions that are designed to help you test your understanding of the material covered and activities to help put what you've learned to practice. You can find the answers to the questions in the section immediately following the quiz.
Quiz
| 1: | How many characters can a database name contain? |
| A1: | 255. |
| 2: | What is the industrywide naming convention for forms? |
| A2: | Beginning the form name with the tag frm. |
| 3: | What are the two categories of tables that the Table Wizard provides? |
| A3: | Business and Personal. |
| 4: | The sort order of the query underlying a report determines the sort order of the report (True/False). |
| A4: | False. The sort order designated in the report overrides the sort order designated in the underlying query. |
| 5: | It is generally more efficient to base a form or report on a query than on a table (True/False). |
| A5: | True. |
Activities
Practice using the Database Wizard, Table Wizard, Simple Query Wizard, Form Wizard, and Report Wizard. Build a Customer table and an Order table. Add records to each. Practice using the Simple Query Wizard to build queries that retrieve specific records from the tables. Use the Form Wizard to build data entry forms for each table. Finally, use the Report Wizard to build reports that show the data entered into each table.
