i
MS Access Exercise
You are working at a support desk for a company providing onsite and telephone support to customers with Microsoft Access questions. On this particular day, you are presented with the following three situations:

Situation 1:
Jack, a veterinarian, has experienced tremendous growth within his business. All animal records are shelved in folders and are sorted alphabetically by the owner’s name. Jack is ready to rid himself of the time and space these files take and has inquired about Access. He wants to know about the key functions of using Access and how a table, query, primary key, and a report are important to his database needs. For this person exploring about the Microsoft Access and the key functions, I would start with clarifying that Microsoft Access is used to make databases for all the animal records. Microsoft Access users can make tables with the customer’s advice, forms, reports on the animals, their care, and the customer’s payment history. Microsoft Access puts all the information combined composing a relationship between all the data entered. The tables made within the Microsoft Access database can include the information on the animals, and all the records of care given to each person’s animal. Microsoft has the capability to make these reports to provide an analysis of the data. The Microsoft Access database contains a query interface that lets the data to be inserted, and reports for printing. With Microsoft Access the person can change the old record filing system to the database system with gratification, and create records for the animals, the care provided, the animals owner name, address, phone numbers, and payments received or overdue balances.

Situation 2:

Frank has created a database to inventory his customers’ past due accounts to ensure that he receives payment. He has created two tables: one for