ASSIGNMENT #3 !!!!

---

Abstract

For this assignment, we will create a database file in MS Access and use SQL queries to return the result using advanced queries.

---

1. Introduction

First things first, before advancing with this project we will provide knowledge about the program we are going to use and some useful information about it. According to an article written by Noah on the website ArkWare (1), “Microsoft Access is a type of database software that is used to store information for reporting, referencing and analysis. With Microsoft Access, you can analyze large amounts of data faster and more efficiently than with Excel or other types of spreadsheets.” It should be also highlighted that, MS Access is also (according to an article written by Noah on the website ArkWare) (1), “Access is most popular for its tables, forms and queries. The database tables are like spreadsheets, so you should not have much trouble using the basic functions of the program. However, it does take time to learn the full features. When setting up a database, you may list the subject matter of each column, just as you would with a spreadsheet, and add as many columns as you would like. When this is completed, each row leaves room for more data input.”

Now that we know some useful information about the program we are going to use, the next question is: and now what? Thus, for the realization of this project, we will create a database file in MS Access and use SQL queries to return the result using advanced queries. However, how do we do that?

---

2. Methodology

To complete our goal for this assignment here are the steps we will take:

1. Apart from opening a database file on MS Access, we will create different tables by clicking first on create and then on Table as shown in the picture below:

2. Now that we created the tables, we will add some data on each table in relation with what we want to add to each table as shown in the picture below:

3. After these steps, we will modify the relationships between all the tables created to your liking from clicking into Database Tools and then into Relationships.

4. After stating the relationships between tables, it is time to create queries between different tables. Thus, we will click on Create, then click on Query Design and from there, we will link two or more different tables we want as shown in the picture below:

5. After step 4, we will save the query and run it and it should be all show as the picture from down below:

---

3. Results and Conclusions

Overall, thanks to the realization of this task no we know a little bit about how MS Access works as well as some useful information about this worldwide known database program and in specific, now we have the proper knowledge about how to create a database file in MS Access and use SQL queries to return the result using advanced queries.

---

4. References

(1): Noah. “What Is Microsoft Access? A Brief Introduction for New Users.” Arkware, Arkware, 28 Oct. 2016, www.arkware.com/2016/09/16/microsoft-access-brief-introduction-new-users/.