Microsoft Access Exercise

1635 words 7 pages
Microsoft Access Exercise
Ramona Stephan
December 16, 2012
Don Shults

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


  • LAB 1 NMAP Exercise Answers
    3208 words | 13 pages
  • Chapter 07
    7197 words | 29 pages
  • Decision Support and Business Intelligence Systems 9th Edition Ch1&2 Exercise
    5929 words | 24 pages
  • Boys and Girls Club
    1745 words | 7 pages
  • Time to Practice – Week One
    933 words | 4 pages
  • Wgu Capstone
    8762 words | 36 pages
  • Advantages and Disadvantages of Bundling
    1571 words | 7 pages
  • Hrm 590 Course Project Part a
    1165 words | 5 pages
  • 1. Calculate the revised product costs for the four pens, based on the activity information collected by Dempsey
    936 words | 4 pages
  • Nursing Informatics
    2890 words | 12 pages