Access+Lesson+1+summary

Home / software / microsoft access / Tutorials


 * Yugo National Bank ||
 * 1) Create a blank database and name it **Yugo National Bank1**
 * 2) Double-click Add New Field and type **AccountType**
 * 3) Add one more column named **Description**
 * 4) Change ID to **AccountTypeID**
 * 5) Save the table as **AccountTypes**
 * Watts A loan ||
 * 1) Create a blank database and name it **Watts A Loan1**
 * 2) After the default ID column, create the following additional columns: **FirstName**, **MiddleName**, **LastName**, **Address**, **City**, **State**, **ZIPCode**, **Country**, **HomePhone**, **WorkPhone**, **EmailAddress**, and **Notes**
 * 3) Rename the ID column as **CustomerID**,
 * 4) Save the table as **Customers**
 * 1) Rename the ID column as **CustomerID**,
 * 2) Save the table as **Customers**