Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access training - old data entry

Forum home » Delegate support and help forum » Microsoft Access Training and help » access training - Old Data Entry

access training - Old Data Entry

ResolvedVersion Standard

Julie has attended:
Access Introduction course

Old Data Entry

How can we make ex pupil data available but read only .

RE: Old Data Entry

Create a form from a query with Ex Pupil data in it.
Go to the Design view of the form
Double click on the top left square of the form to get the properties box.
Click on the DATA tab.
Set "Allow Filters, Allow Additions, Allow Edits, Allow Deletions" to NO.

Save and test in form view

This will allow the user to view the information, but not make any changes.

Access tip:

Change The Default Font in Access 2003

You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set.

To change the default font:

1.From the menu bar select Tools.
2.Click Options.
3.Go to the Datasheet tab:
4.In the Default font section select your preferred font from the list of fonts e.g. Arial.
5.Select your preferred size from the size menu e.g. 12.
6.Click Apply.

Click on the Tables/queries tab:
1.In the Query Design font section select your preferred font from the list of fonts e.g. Arial.
2.Select your preferred size from the size menu e.g. 12.
3.Click Apply.
4.Click OK.

The default font for Access has now been changed.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.