Microsoft Access Exercise
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 plate collection. She recently discovered each plate has a serial number, and after adding the serial number to the database, her queries did not function the same. In the first situation, 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. He is ready to rid himself of the time and space these files take and has inquired about Microsoft® Access®. He wants to know about the key functions of using Microsoft® Access® and how a table, query, primary key, and a report are important to his database needs. Some of the key functions of using Microsoft Access are tables, queries, records, relationships, and reports (Shelly, Cashman, & Vermaat, 2007). The records for each animal can be stored in a database. A database is files in which you store data and include all the major key functions related to the stored data; including functions you define to automate the use of your data (Shelly, Cashman, & Vermaat, 2007). When creating the database for the veterinarian business in Microsoft Access, the database needs to contain at least one table and can contain many different tables. According to Shelly, Cashman, and
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 plate collection. She recently discovered each plate has a serial number, and after adding the serial number to the database, her queries did not function the same. In the first situation, 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. He is ready to rid himself of the time and space these files take and has inquired about Microsoft® Access®. He wants to know about the key functions of using Microsoft® Access® and how a table, query, primary key, and a report are important to his database needs. Some of the key functions of using Microsoft Access are tables, queries, records, relationships, and reports (Shelly, Cashman, & Vermaat, 2007). The records for each animal can be stored in a database. A database is files in which you store data and include all the major key functions related to the stored data; including functions you define to automate the use of your data (Shelly, Cashman, & Vermaat, 2007). When creating the database for the veterinarian business in Microsoft Access, the database needs to contain at least one table and can contain many different tables. According to Shelly, Cashman, and
References: Shelly, G.B., Cashman, T.J., & Vermaat, M.E. (2007). Introductory concepts and techniques . New York, NY: Cengage learning. Creating or modifying a primary key. (n.d.). Retrieved from http://office.microsoft.com/en-us/access-help/create-or-modify-a-primary-key-HA010341487.aspx?CTT=1 When can I edit data in a query. (n.d.) Retrieved from http://office.microsoft.com/access-help