Mastering Access SQL Queries

Which SQL statement would you use in Microsoft Access to display all columns from a table named `Students`?

• SELECT * OF Students;

• SELECT * FROM Students;

• SHOW ALL FROM Students;

• DISPLAY * FROM Students;

Fill in the blank: Write the SQL query to select only the `FirstName` and `LastName` columns from the `Teachers` table.

Which SQL statement would you use to join the `Orders` table and the `Customers` table on the `CustomerID` field?

• SELECT * FROM Orders JOIN Customers ON Orders.CustomerID = Customers.CustomerID;

• SELECT * FROM Orders, Customers WHERE Orders.CustomerID = Customers.CustomerID;

• SELECT * FROM Orders INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID;

• SELECT * FROM Orders OUTER JOIN Customers ON Orders.CustomerID = Customers.CustomerID;

If you want to display all records from the `Employees` table, even if there is no matching record in the `Departments` table, which join should you use?

• INNER JOIN

• LEFT JOIN

• RIGHT JOIN

• CROSS JOIN

Fill in the blank: Write the SQL query to list all books along with their author's name, assuming `Books.AuthorID = Authors.AuthorID`.