When you have sensitive data that shouldn't be edited by just anyone, give people the ability to see, but not change the data in your database with read-only forms. Laurie Ulrich shows you how to control the rights users have within your forms, so you can
- [Instructor] If you're not the only person…using your database, you may find that you want to restrict…other users' ability to edit, delete, or add data…in your database.…One good way to prevent that is to create a form…that shows people what they need to see,…but doesn't allow them to edit the data…viewed through the form.…In design view of the form,…display the property sheet and choose form…from the drop list.…On the data tab, change the allow additions,…deletions, and edit settings to no.…
Also, set data entry to no.…Save the form and test it.…The new record button is now dimmed…and any attempt to change the data…in the existing records is ignored.…
Author
Laurie Ann Ulrich
Released
2/27/2019- Planning your database
- Building tables
- Setting field properties
- Creating relationships
- Creating forms for data entry
- Finding data with queries
- Updating records with queries
- Building better reports
Skill Level Intermediate
Duration
Views
-
Introduction
-
1. Planning
-
Storyboarding1m 6s
-
-
2. Building a Table
-
3. Field Properties
-
Using input masks1m 19s
-
-
4. Relationships
-
Editing relationships1m 4s
-
5. Data Entry
-
Fast forms with subforms1m 12s
-
Create combo and list boxes1m 27s
-
Adjusting tab order in forms1m 15s
-
-
6. Queries
-
Finding missing data1m 7s
-
7. Reports
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Creating read-only forms