Start Microsoft Access; describe the Database window and the objects in an Access database. Add, edit, and delete records within a table; use the Find command to locate a specific record. Explain the importance of data validation in table maintenance; provide several examples of the way in which it is enforced. Apply a filter (by form or selection) to a table; sort a table on one or more fields. Explain how the PivotTable and PivotChart views are used to display information from a database. Describe a relational database; identify the one-to-many relationships that exist within a database.
|