Question

question 5
1 pts
in microsoft access, if i want to create a combo box that will show the customerid, firstname and lastname fields from my customer table, which select statement is correct?
select customerid, firstname, lastname;
select customerid, firstname, lastname from employee;
select customerid, firstname, lastname from customer;
select customerid, firstname, lastname from customers;

Explanation:

To create a combo box in Microsoft Access showing fields from the Customer table, the SELECT statement must include the correct table name (Customer) and the desired fields (CustomerID, FirstName, LastName).

• The first option lacks a FROM clause to specify the table.
• The second option uses the Employee table instead of Customer.
• The fourth option uses "Customers" (plural) instead of the correct table name "Customer" as per the problem's context.
• The third option correctly selects the fields from the Customer table.

Answer:

C. SELECT CustomerID, FirstName, LastName FROM Customer;