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.The Property Sheet will appear to the right of the form:
Click on the DateCreated field, then click Property Sheet.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):.Use standard abbreviations, such as Num for Number, Amt for Amount, and Qty for Quantity, and use them consistently throughout the database.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).Use concise field names that are easy to remember and reference, and that won’t take up a lot of space in the table datasheet.Capitalize the first letter of each word in a field name that combines multiple words, for example Visit.A field name cannot begin with a space.), exclamation mark (!), grave accent (`), and square brackets () A field name can consist of up to 64 characters, including letters, numbers, spaces, and special characters, except for the period (.Keep the following guidelines in mind when you assign field names: ) Decision Making: Naming Fields in Access Tables One of the most important tasks in creating a table is deciding what names to specify for the table’s fields. Creating a Table in Datasheet View XP (Cont.
0 kommentar(er)
