Access+Lesson+5+summary

Home / software / microsoft access / Tutorials


 * Yugo National Bank ||
 * 1) Open the Yugo National Bank1
 * 2) From the resources that accompany these lessons, import the yugo_national_bank_customers.txt file (it is a text file). Specify that the top row will provide the columns names. Let the wizard create a primary key and accept all defaults. After importing, rename the table as **Customers**. Open the table in Datasheet View and change the name of the first column from ID to **CustomerID**
 * Watts A Loan ||
 * 1) Open the Watts A Loan1 database
 * 2) Use the Table button of the Tables section of the Ribbon to create a new table. Replace ID with **EmployeeID**. Use the Add New Field column to create the following additional columns **FirstName**, **LastName**, **Title**, **WorkPhone**, **Address**, **City**, **State**, **ZIPCode**, **Country**, and **HomePhone**. Save the table as **Employees** and add the records to it
 * 1) Open the Watts A Loan1 database
 * 2) Use the Table button of the Tables section of the Ribbon to create a new table. Replace ID with **EmployeeID**. Use the Add New Field column to create the following additional columns **FirstName**, **LastName**, **Title**, **WorkPhone**, **Address**, **City**, **State**, **ZIPCode**, **Country**, and **HomePhone**. Save the table as **Employees** and add the records to it