Microsoft Access Exercise

1635 words 7 pages
Microsoft Access Exercise
Ramona Stephan
IT-206
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

Related

  • Principles of Management - Microsoft
    1029 words | 5 pages
  • Ratio Analysis for Microsoft Corp
    1774 words | 8 pages
  • Microsoft Office and Word
    3054 words | 13 pages
  • LAB 1 NMAP Exercise Answers
    3208 words | 13 pages
  • Microsoft Strategy Analysis
    4648 words | 19 pages
  • Chapter 2 Exercises & Case Exercises
    2253 words | 10 pages
  • Access Control FInal Project
    1198 words | 5 pages
  • The Competitive Advantage of Microsoft and Its Hr
    1353 words | 6 pages
  • CIS 210 - Access Control System
    1213 words | 5 pages
  • Microsoft Corporation
    4766 words | 20 pages