20. Create a form to edit Merchandise information. Eventually, this table will contain thousands of entries so provide features to enable users to sort and filter the data by category and description.
Basic form is straightforward. The filter/search depends on form capabilities. The goal in this chapter is to keep it simple and avoid code if possible. Microsoft Access supports filters which might be good enough for most cases and require no additional effort. (Set the cursor in Category text box and click the filter icon to choose.) Otherwise you can add combo boxes and edit the underlying query. Answer Form: Merchandise