Some options include restricting the length of data (under Field Size), setting a default value (which we've just done), specifying whether it is a required field, and more. These options can be used to further specify exactly what type of data can be entered into the database as well as any constraints or defaults that you'd like to set against each field. You can see that we have configured just two of many options in this pane. We have also specified a format for all dates that are stored in this field. This means that, whenever a new record is entered, this field will automatically be populated with the current date and time. We have just set a default value for the DateCreated field. Also click in the Format field and select General Date from the contextual menu: Click on the DateCreated field, then in the bottom pane, enter =Now() in the Default Value field. You are now looking at your Customers table in Design view. At this point, Access will ask you to name and save the table you just created.Click on the View icon at the top left (just under the File menu).The following steps demonstrate how to switch to Design view. So it's good to familiarize yourself with this concept early on. This is where you set up and configure your tables, forms, reports, etc.Īs you continue working with MS Access, you will find yourself switching between Design view and Datasheet view (or in the case of forms, Layout view) often. What Is Design View?ĭesign view enables you to design and set up your database (kind of a "behind the scenes" view of your database). We can also view the table in Design view.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |