You want to return all Names that begin with a T from a database; which of the following will generate an error message?
T*
In the criteria row and Customer Name Column, you have the following command: Like "*D"; what will it do?
Return Customer names that end with a D
What is not a main feature of a primary key?
it contains a unique value for each column of data
____________________ is a relational database which states that table relationships must always be consistent.
Referential integrity
Of the following, which is correct
SELECT Customers.CustomerNumber, Customers.CustomerName, Customers.City, Customers.Balance
Which SQL command specifies the table(s) where the fields are located?
From
Enforcing referential integrity assures that ________.
you cannot enter a value in the foreign key if there is no corresponding value in the primary key
To limit the number of records displayed and find particular records, when a query is run, you add ________.
criteria
I want to create a query that will return information from sales reps who have the sales rep number 1 or 2.
In the criteria row I will enter 1 or 2 under the sales rep columnB
In the criteria row, I will enter "1" or "2" under the sales rep column
In the criteria row I will enter 1 under the sales rep column and in the "or "row I will enter 2 under the sales re
I want to list my Sales reps in alphabetical order by name. This can be done in the
Design View
Datasheet view
SQL view
Before you run a "Top or Bottom Values" query, you must 1st ____________ the data.
Sort
What are the basic SQL clauses?
Select
From
Where
Order By
What does the "Select" clause do?
Specifies the fields to be included in the query
What does the "From" clause do?
Specifies the table(s) where the fields are located
What does the "Where" clause do?
Sets the criteria for the rows in the results
What does the "Order by" clause do?
Determines how the rows will be sorted
What is a "LEFT JOIN
A Query that shows all rows from the table on the left and only the rows from the table on the right that match.