Information Assignment

INFORMATION SYSTEMS In this assignment of Microsoft Access, we began working with SQL statements. The first record of the assignment required us to luff all customers with an biography sleep of greater than 200 or customers who were located in Chicago, and calculate Names in ascending allege. First, we began entering selective teaching into the database, such as Customers, Account Balance, Name, etc. We then began customizing our finale by typing in commands in the Criteria and Or fields. By modifying the query we entered entropy into the database, customized this information through commands, and viewed these satisfied conditions in an groomd table. Towards the end of the first assignment, we were able to view a SQL statement that was automatically created when we performed the QBE. In the second part of the assignment, we began soothe our own SQL statement, rather than using QBE. To create a refreshful query, we had to enter specific instructions into a SQ L window to make all customers with an Account Balance of greater than 200 and organize Names in ascending order. Following this step, we modified the SQL by including customers from Chicago.

However, we were required to put these customer names in actuate order. The last step instructed us to modify the query by displaying only the Account Balance and city columns. To do this, we had to do at the * symbol from the previously typed information, and add the Account Balance and City fields, separating them by comma. In conclusion, both these assignments showed us disparate shipway in which we can enter and customize parvenue information into the database. It in addition showed us ho w we can customize this information not only! through excel and spreadsheets, but also through SQL statements.If you want to get a full essay, order it on our website: OrderEssay.net

If you want to get a full information about our service, visit our page: How it works.