Access+lesson+4+summary

Home / software / microsoft access / Tutorials


 * Yugo National Bank ||
 * 1) Open the **Yugo National Bank1**
 * 2) Open the **AccountTypes** table fill it up as follows:
 * Account Type ID || Account Type || Description ||
 * 1 || Checking ||  ||
 * 2 || Saving ||  ||
 * 3 || CD ||  ||
 * 1) Print the table and close it
 * Watts A loan ||
 * 1) Create a blank database and name it **Watts A Loan1**
 * 2) Create a table with the following fields: **TransactionID** (you will rename the ID column), **TransactionNumber**, **TransactionDate**, **TransactionAmount**, and **Notes**. Save the table as **Transactions**
 * World Statistics ||
 * 1) Open the World Statistics1 database
 * 2) Use the Table button in the Tables section of the Ribbon to create a new table with the following fields: **CountryID**, **CommonName**, **InternetCode**, **LongName**, and **GovernmentType**
 * 3) Save the table as **Countries** and switch it to Design View
 * 1) Open the World Statistics1 database
 * 2) Use the Table button in the Tables section of the Ribbon to create a new table with the following fields: **CountryID**, **CommonName**, **InternetCode**, **LongName**, and **GovernmentType**
 * 3) Save the table as **Countries** and switch it to Design View