How would I have to modify this query to get it to run correctly?

Let's say my author name column in the table "authors" (in the database "WEEK1_Q1_Q2_ACCESS2000.mdb" attached here) was named: author name (not author_name, as it is currently named) This is OK to do (to use "whitespace" in a column or table name), but how would I have to modify this query to get it to ...continues

Access - Wildcards:

Here's what Access says about searching for wildcards: When using wildcard characters to search for other wildcard characters such as an asterisk (*), question mark (?), number sign (#), opening bracket ([), or hyphen (-), you must enclose the item you're searching for in brackets. If you're searching for an exclamation ...continues

Query Return Results

I attached a database. In it is a table named Table1 with these values: COLUMN 1 COLUMN 2 E 5 F 6 G 7 H 8 I 9 J 10 K 11 L 12 A ...continues

Why is Structured Query Language (SQL) such an important tool?

Why is Structured Query Language (SQL) such an important tool? Explain Structured Query Language’s role in the database world. http://databases.about.com/od/sql/a/sqlbasics.htm

SQL Queries

Using the attached database, please show how to do the following: 1. Using a join, get the full details of all the students who work on the mid-term exam assignment. 2. Get the assignment names (duplicates eliminated) being worked on by students at Central University. 3. Get the last names of all the students who are work ...continues

Queries in Access

I notice when writing queries that Access will add in a semicolon at the end of my query. Its just one of those Access things right? We don't have to remember to write the semicolon, as Access adds it in for us correct. The only time this is significant to know is in a situation like this - in a UNION query We may end up cu ...continues

Queries

I'm not sure I follow this stuff exactly. I must be missing something. When I run the query to show below I get a little pop up box that says "Enter Parameter Value" then authors.author name I must be doing something different? Maybe? SELECT authors.author name > FROM authors > WHERE authors.author name ...continues

Running a Query

Why wont this query run? SELECT authors.author_name FROM authors WHERE authors.author_name Like *twain*;

ACCESS 2000

(Note: cut and paste the SQL answers for questions 1 and 2 into a word document. 1. Write the SELECT FROM WHERE code that will select the row from the authors table in the attached WEEK1_Q1_Q2_ACCESS2000 database that has “twain, mark” NOTE: You can use: SELECT * ...continues

Access 2000 Database

Use the attached WEEK2_ACCESS2000.mdb database I just need the SQL code, which can be cut and pasted into a word document. 1. Perform an inner join between the BOOKS table and the ORDER_LINES table. Show the titles from the BOOK table and quantity column from the ORDER_LINES table ------------------------------------- ...continues