THIS POST IS “UNDER CONSTRUCTION” – PLEASE CHECK BACK SOON OR COMMENT BELOW!
Modifying the properties of an Access Form falls outside the scope of the CAT curriculum. This very simple exercise will give you some insight into how a fully-fledged database application can be so much more than a collection of tables, queries, forms and reports.
Create a Form based on one of the Tables in an Access database. By default, the completed Form allows you to add, edit, modify and delete records in the underlying table.
- Open the Form in design view. Select the Design menu tab (from the Form Design Tools section) and click on the Property Sheet button.
- On the Property Sheet panel, select Form from the drop-down box.
- On the Data tab, select Yes for the Data Entry property.
When the form opens you will able to add new records, edit and delete those new records, but not be able to view, edit or delete existing records in the underlying table.
This is just one of the many, many Access features that allow the control of data input for the purpose of ensuring the efficient, accurate capturing of data.