Access+Using+fields

Home / software / microsoft access/ Tutorials

> > > > > >
 * Practical Learning: Using Fields ||
 * 1) Click File
 * 2) Open up the database supplied called **Clarksville Ice Scream**
 * 3) To create a new table, on the Ribbon, click Create
 * 4) In the Tables section, click Table
 * 1) In the Tables section, click Table
 * 1) Click //**Click To Add**// and click Text
 * 2) When it is highlighted, type **Order Date** and press Enter
 * 1) As the menu displays in the next column, click Text
 * 2) Type **Order Time** and press Enter
 * 3) As the menu appears in the next column header, click Text
 * 4) Type **Container** and press Tab
 * 5) Press Esc
 * 1) Close the table
 * 2) When asked whether you want to save it, click Yes
 * 3) Type **Customers Orders** as the name of the table
 * 4) Click OK
 * 5) To start a new table, on the Ribbon, click Create
 * 6) Click Table
 * 7) In the Add & Delete section, click Text [[image:http://www.functionx.com/access/buttons/text1.gif width="42" height="66" caption="Text"]]
 * 8) Type **Manufacturer** and press Enter
 * 9) Press Esc
 * 10) In the Add & Delete section, click Text [[image:http://www.functionx.com/access/buttons/text1.gif width="42" height="66" caption="Text"]]
 * 11) Type **Model** and press Enter
 * 12) Press Esc
 * 13) In the Add & Delete section, click Date & Time [[image:http://www.functionx.com/access/buttons/date1.gif width="22" height="22" caption="Date And Time"]]
 * 14) Type **Acquired** **Date** and press Enter
 * 15) Press Esc
 * 16) In the Add & Delete section, click Currency [[image:http://www.functionx.com/access/buttons/currency1.gif width="50" height="66" caption="Currency"]]
 * 17) Type **Purchase Price** and press Enter
 * 18) Press Esc
 * 19) In the Add & Delete section, click Text [[image:http://www.functionx.com/access/buttons/text1.gif width="42" height="66" caption="Text"]]
 * 20) Type **Company** and press Enter
 * 21) Press Esc
 * 22) Right-click Table2 and click Save
 * 23) Set the name to **Company Assets**
 * 24) Click OK
 * 25) Click its Close button [[image:http://www.functionx.com/access/buttons/close2.gif width="24" height="24" caption="Close"]]