Microsoft Access Exercise
December 16, 2012
Microsoft Access Exercise Microsoft Access provides many functions for end users. While working in IT Support, many different situations may present from customers phoning in and requesting information or assistance. Following are three different situations that may be presented at a support desk. First, we will examine a veterinarian who wants to use Microsoft® Access® for his business, and has some questions regarding the functions of Access. Second, a man created a database to inventory his customers’ past due accounts to ensure that he receives payment. Third, a user has been using a Microsoft® Access® database and queries to track her commemorative …show more content…
In the third situation, the end user has been using a Microsoft® Access® database, and queries to track her commemorative plate collection. She recently discovered that her plates have serial numbers and decided to record these within her database. When she replaced each plate’s ID with the appropriate serial number, she was unable to use her queries. She wants to know why this has happened. She also wants to know if each serial number is unique or similar to the assigned ID number she has used in the past.
A possible cause for this situation is the way the ID was added to the database. To add new records to a database you use an append query, and to delete whole records from a database you use a delete query. You cannot run an update query in a Web browser. If you want to run an update query in a Web database, you must first open the database by using Access (“When can I edit data in a query”, n.d.)
As a better practice when creating an update query, create a select query that identifies the records that you want to update, and then convert that query to an update query that you can run to update the records. By selecting data first, you can verify that you are updating the records you want before you actually change any