Position the right edge of the form and the bottom of the form to frame the fields evenly. Select all the text boxes again and select Format, Vertical Spacing, Make Equal to evenly space the textboxes. Selct Format, Align, Left to left align the text boxes. Hold the shift key and click each textbox to select all of them. After aligning the labels, click one of the textboxes. Left align the labels by selecting Format, Align, Left.
Select all the labels by moving to a point below the HomePhone label, click and hold the left mouse button and move the upper left corner of the select box to a point above the ContactID label. Shift-Left makes the text box more narrow. Widen the Street textbox by selecting it, holding the shift key down and pressing the right arrow. Select the State textbox and adjust it to a more narrow width by dragging the small square handle on the right border. The object on the left is a Label and the object on the right is a TextBox. You can drag the fields onto the form one at a time or hold the shift key down to select several fields. A list of the fields in tblContact appears. To add data fields to the form, select View, Field List. This makes tblContact the RecordSource for the form. Click New, Design View, and choose tblContact as the table or query where the object's data comes from. Select the Forms tab in the database window. When you finish the second record, close the table. Don't put parenthesis or dashes in the phone numbers. Open the table and enter a record with your information. Save your table design as tblContact when you close the design view. Documenting the database as you develop it not only makes it easier to maintain, but adds features that make it more user friendly. Describe each field in the Description column.
#Microsoft access database tutorial zip
Set Street to 40, City to 20, State to 2, Zip to 10, WorkPhone to 14 and HomePhone to 10. Click LastName and set its Field Size to 20. This primary key guarantees we get one and only record per ContactID.Ĭlick on FirstName and set its Field Size to 15. This tells Access to automatically generate a unique long integer value for each record that makes an excellent primary key for this table. Change the ContactID Data Type to AutoNumber. To make sure your table can be read by other applications, we avoid using spaces in field names. For our example, we will create a Contacts application that contains information you would normally keep in an address book. On the Tables tab, click New, Design View, OK. Start Access and select File, New, highlight the New Database icon and click OK. We will step through creating a form without using the form wizard.įirst we must create a new database. This tutorial is designed to help you make that jump. Congratulations! you have just started the jump from User to Developer. Eventually you will want to do something that the wizard won't do. Wizards guide you through many tasks and let you become productive in a very short time. Microsoft Access is a popular database because it is easy to use.