Access+data+entry+on+a+form

Home / software / microsoft access / Tutorials

> || Ernestine Aarons || A-682-638-146 || 6044 Lolita Drive || Silver Spring || MD || 20904 || > || Raymond Simms || 629-49-2746 || 815 Arundela Rd NE || Washington || DC || 20008 || > || Johnny Edmondson || 837-62-5860 || 10696 Great Alberta Crt || Alexandria || VA || 21233 || > || Albert Faughty || F-374-590-749-205 || 702 Mechanics Drv || College Park || MD || 20707 ||
 * Practical Learning: Form Data Entry ||
 * 1) To create a new database, click File and click New
 * 2) Set the Name to **BCR1** and and click Create
 * 3) Double-click ID and type **CustomerID**
 * 4) Right-click Click to Add and click Text
 * 5) Type **Full Name** and press Enter
 * 6) In the menu that appears, click Text, type **Driver's License #** and press Enter
 * 7) In the menu that appears, click Text, type **Address** and press Tab
 * 8) In the menu that appears, click Text, type **City** and press Enter
 * 9) In the menu that appears, click Text, type **State** and press Tab
 * 10) In the menu that appears, click Text, type **ZIP Code** and press Enter
 * 11) To save the table, right-click Table1 and click Close
 * 12) When asked whether you want to save it, click Yes
 * 13) Set the Name to **Customers** and press Enter
 * 14) To create a new form, on the Ribbon, click Create
 * 15) In the Forms section, click click Form Wizard
 * 16) In the Tables/Query combo box of the first page of the Form Wizard, select Table: Customers
 * 17) Click the Select All button [[image:http://www.functionx.com/access2007/buttons/selectall2.gif width="30" height="20"]] and click Next
 * 18) Accept the Columnar Layout and click Next
 * 19) In the style page, select Paper and click Next
 * 20) Accept the suggested name of the form as Customers and click Finish
 * 21) Click the text box on the right side of Full Name and type  **Ernestine Aarons**
 * 22) Press Tab and type **A-682-638-146**
 * 23) Press Enter and type **6044 Lolita Drive**
 * 24) Moved to the next record
 * 25) Click the text box on the right side of Full Name and type  **Raymond Simms**
 * 26) Click the Next Record button [[image:http://www.functionx.com/access2007/buttons/nextrec1.gif width="16" height="16"]] to get to the next record
 * 27) Click the text box on the right side of Driver's License # and type **837-62-5860**
 * 28) Click the Previous Record button [[image:http://www.functionx.com/access2007/buttons/prevrec1.gif width="16" height="16"]] twice to return to the first record
 * 29) Complete the form with the following records:
 * **Full Name** || **Driver's License #** || **Address** || **City** || **State** || **ZIP Code** ||
 * **Full Name** || **Driver's License #** || **Address** || **City** || **State** || **ZIP Code** ||
 * 1) To close the form, click its close button [[image:http://www.functionx.com/access/buttons/close2.gif width="24" height="24" caption="Close"]]