After completing the database assignment the student will have shown that they are able to:
Create a Microsoft Access database that includes use of the following features:
| design a table using the table wizard and then use design view to add, delete or reorder fields and to modify their type or length. | |
| enter data and navigate in both datasheet and form view | |
| create a form using the form wizard | |
| understand the difference between form design and form entry and what is entered/modified with each | |
| modify the format of forms (change field sizes, change label and field appearance: colors, borders and effects) | |
| create a report using the wizard that groups data with subtotals |