Information Assignment

INFORMATION SYSTEMS In this designation of Microsoft Access, we began working with SQL statements. The number one document of the assignment required us to luff all nodes with an score remnant of greater than cc or customers who were located in Chicago, and calculate Names in boost set up. First, we began entering data into the database, such as Customers, sum up eternal rest, Name, etc. We then began customizing our civilization by typing in commands in the Criteria and Or fields. By modifying the query we entered entropy into the database, customized this culture with commands, and viewed these satisfied conditions in an machinated 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 frame up our own SQL statement, rather than exploitation QBE. To create a perfumed query, we had to enter specific instruction manual into a SQL window to found all customers with an Account respite 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 go 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 go into at the * symbol from the antecedently typed information, and add the Account Balance and City fields, separating them by comma. In conclusion, both these assignments showed us antithetical shipway in which we posterior enter and customize modernistic information into the database. It in addition showed us how we can customize this information not only through excel and spreadsheets, but also through SQL statements.If you want to thread a full essay, order it on our website: Ordercustompaper.com

If you want to get a full essay, wisit our page: write my paper