renollka.blogg.se

Microsoft access 2013 tutorial forms
Microsoft access 2013 tutorial forms






You can even move fields around by clicking and dragging them. If you want to select multiple fields, hold the Shift key down while you select them. For example, background colors on each field, change the border color of each field, bold the labels, etc. Now feel free to format some of the other elements on the page.From the Ribbon, select a background color for the form:.In Layout view, click in a blank part of the form (i.e.Now close the Property Sheet and switch to Layout view.This just makes the form a bit more readable and more presentable, as the labels are what the user sees. Next, select the CustomerId label (the label is the one on the left - don't touch the ones on the right), and add a space so that it becomes Customer Id.We can still display the field, for the users' information, but we don't want them changing it. By locking the field users can't inadvertently (or even maliciously) change it. This field is intended to store the date that each record was first entered into the system. We have just "locked" the DateCreated field so that users can't change it. Change its value to Yes using the drop down control. On the Property Sheet, scroll down until you see the Locked option.

microsoft access 2013 tutorial forms

The Property Sheet will appear to the right of the form:

  • Click on the DateCreated field, then click Property Sheet.
  • microsoft access 2013 tutorial forms

    Click the Design view icon at the bottom right corner of Access (you can also use the icon at the top left of the Ribbon if you prefer):.Although we've been using the Views icon on the Ribbon to switch views, you can also switch views by using the icons at the bottom right of Access (screenshot below).








    Microsoft access 2013 tutorial forms