Week2 Day 3

In class today we worked on chapter 3 in Access. Today we learned how to filter , add, change, delete, ans search for records. We learned how to format a datasheet and use queries to update a table. We also learned how to create a simple form and use a form to add records. We learned how to toggle a filter, clear a filter, and filter by form. We learned how to use the advanced filter/sort. We also learned how to update, delete, and append queries. We learned how to specify a required field, range, default value, collection of allowable values, and a format. We learned how to find unmatched or duplicate records. We also learned how to compact or repair a database.