Today in class we are learning about queries. A query is what allows you to determine what columns you want to choose. It is defined in the book as a question presented in a way that access can process it. Queries allow you to create certain reports. Also, we learned how to join two tables together. In the query, there is a design view and a datasheet view that we can refer to. After you join the tables, then you can create a query. In order to make this possible, you must show a relationship between the tables using the primary key. A rule of normalization that we learned tonight is that is topic should have it own table. There should be a table category for first name, and one for last name. They two shouldn't be in the same column. It uses sequel language behind the screen to carry out and execute the question. We learned that http://www.w3schools.com/ allows us to learn more on sequel language. We were able to set certain criteria to find out specific information for certain clients in a database that we created. A wildcard is a symbol that represents any collection of charcters. The question mark is also a wildcard that represents an individual character. The parameter allows you to inout how you want the criteria. The comparison operators that we learned in this class were (<,>,>=,<= and NOT). AND and Or are considered the compoun criteria
No comments:
Post a Comment