SQL videos

Question 2

what does access use in the backend

Answer 2

SQL!

Question 3

most basic SQL query

Answer 3

Select one field
From one table

Question 4

SELECT * FROM tales

Answer 4

Gives u all the fields

Question 5

SELECT * FROM table
WHERE

what does where clause mean

Answer 5

helps you limit the data

Question 6

SELECT * FROM table
WHERE
ORDER BY

what does order by clause mean

Answer 6

helps you sort the data

Question 7

How do you put in a criteria like names starting w B?

why star?

Answer 7

LIKE “B*”

so you can get every ending that begins w B

Question 8

HOW DO you put in a criteria for # of characters

Answer 8

LIKE “?????..”

number of ? is number of characters

Question 9

How do you put in a criteria for books with titles a-m

Answer 9

LIKE “[A-M]*”

Question 10

how to run a query for multpiple tables?

Answer 10

drag them both into the work area

put in the criteria at the bottom regularly

Question 11

select statement with and/or condition

Answer 11

SLECT * FROM
WHERE — OR—

Question 12

Show all products and corresponding supplier info

Answer 12

SELECT
FROM
WHERE suppliers = products

Question 13

Show all products and the corresponding category info

Answer 13

SELECT Categories.CategoryID,CategoryName,ProductName,Inventory
FROM Categories, Products
WHERE Categories.CategoryID=Categories.CategoryID

Question 14

slide 15-23 on week 10 slide