SQL commands
The first command that I learned was the ‘CREATE’ command. It creates a query. After clicking on it, there are various commands under it. Clicking on the ‘Query Design’ command. It helps in creating a new and blank query in the design view. The ‘View’ command on the left top side of the screen helps in viewing the results in either Datasheet view, SQL view, or design view. Therefore, it prompts the view that the user wants at any given time.
The ‘Run’ command helps in viewing the query results. The results come up depending on the query input in the software. Therefore, it becomes easy to analyze large amounts of data using Ms. Access. The ‘relationship’ command, which is the second last command under the table section, brings out the relationship between the data in the table. However, a user has to prompt this by defining the ID relationship and names in the different tables. All of them should match.
The ‘total’ command creates an additional row to the design grid. The row can give the sum of all the numbers in the selected columns. It can also contain any other type of information, depending on the needs of the user. I have also used the ‘delete’ command, which plays a similar function to its name. It deletes any row, columns, or data that a user does not need. The other important command used in the exercise is the ‘insert row’ command. It is under the design tab. It helps in adding another raw to the data in a case where the user wants to add some data or information.
Therefore, the seven above-mentioned SQL commands are useful when dealing with analyzing data using Ms. Access. I used them in my practice and they have proven to be essential. However, there are many other commands with different functions.