There are 2 parts to this week’s assignment.
Download the attached instruction details.
The objective is to perform the same tasks; first, by issuing SQL commands, and then by using MS Access (use the graphical interface to perform the tasks).
Part A SQL (70%); by following the detailed instructions you will Create a table, Insert data into that table, and use Select commands to select and display data from the table.
Submit one Word document, which includes the text of the SQL commands, and screen captures of the commands along with the Web site’s feedback.
Part B MS Access (30%): use MS Access to create the same tables, load the same content and perform the same Queries.
The MS Access database is submitted.
Two files will be submitted – a word document for Part A and an Access database for Part B.
INFO321 WEEK 3 Assignment
Page 1 of 3
Use SQL commands to Create a table, Insert data into that table and Select data from that table.
Complete the same tasks using MS Access (graphic user interface).
Part A SQL Commands (70%)
Read all Part A instructions before beginning
Go to http://www.sqlcourse.com/create.html , click on the links on the left to review
Table Basics, Creating Tables, Inserting into a table, and Drop a table. There is a description of each
command, the format (syntax) used by the Web site, and examples.
You should also review the Select command instructions (which includes the “Where” clause) at
Then return to the “Standalone SQL interpreter” found on the http://www.sqlcourse.com/create.html
site (the link is on the left of the Web site page) to enter and submit your SQL commands.
(The SQL interpreter on the sqlcourse2.com page only supports the Select command and uses
It is recommended that you submit and execute one SQL command at a time.
For each task below:
a) Label each Task to match the instruction
b) Construct the SQL command (include the text of each command in your formal submission)
c) Paste the SQL command onto the Web site (Standalone SQL Interpreter page)
click on the Submit Query button to execute the command
d) Capture the entire response display (either the Window or the entire screen) and paste it below the
SQL command text
If you have difficultly – send the SQL command text and response capture to the instructor for
Let’s Begin the SQL Portion of the Exercise:
Task 1 – Use the SQL Create command to create a table with the below specifications
The table name should be your last name plus a unique number
Use the following to name each field (column); with a matching data type
EmployeeID 10 numeric digits (no decimal points)
SSN up to 11 characters (SSN = social security number)
fName up to 12 characters
lName up to 12 characters
Position up to 12 characters
Salary 10 maximum numeric digits (including 2 decimal digits)
PhoneNum 12 characters.
Task 2 – Use the Insert command to insert the records / data below:
Submit one record at a time (easier to correct any mistakes)
INFO321 WEEK 3 Assignment
Page 2 of 3
100, 111-11-0607, John, Smith, Manager, 35000.75, 800-350-0000
200, 333-22-0607, John, Jones, Associate, 25000.00, 202-999-0000
300, 444-44-0607, Sally, Smith, Manager, 46500.00, 303-999-0000
Insert one more record – you determine the content, EXCEPT it must use your name for the first name
(fName) and last name lName), and a Salary of 36900.
Use the Select * command to list all fields for all records in the table.
Use a Select command to list the EmployeeID, fName, lName, Position, and Salary fields for all
employees with a last name of Smith.
Use a Select command to list the EmployeeID, fName, lName, Position, Salary and PhoneNum fields
for all employees with a salary greater than 20000.
Use a Select command to list the EmployeeID, fName, lName, Position and Salary fields for all
Employees with a Salary greater than 30000 and less than 45000.
Submit this part of the assignment in a word document. Name your document Last_Name_SQLWeb
A description of the most common SQL problems can be found at the end of these instructions.
Contact the instructor with any questions.
Part B Access Database (30%)
Perform the same tasks using MS Access
A) Create the table (same field names and field types as in Part A) Do not worry about specifying
exact field lengths, or decimal points.
No primary key is required.
B) Enter (type) the same data as in Part A
C) Create and Save a Query created for Task 3 above with the name Query C
D) Create and Save a Query created for Task 4 above with the name Query D
E) Create and Save a Query created for Task 5 above with the name Query E
F) Create and Save a Query created for Task 6 above with the name Query F
Name the Access database Last Name_Assignment3 (i.e. Smith_ Assignment3).
Ensure you attach and submit BOTH files (a word document for Part A and an Access
database for Part b)
EmployeeID SSN fName lName Position Salary PhoneNum
100 111-11-0607 John Smith Manager 35000.75 800-350-0000
200 333-22-0607 John Jones Associate 25000.00 202-999-0000
300 444-44-0607 Sally Smith Manager 46500.00 303-999-0000
INFO321 WEEK 3 Assignment
Page 3 of 3
Common SQL problems
A) Table and field names are case sensitive, and should not include spaces.
B) Another common error is “Invalid character used in command” – this means you have used an
illegal character. Character fields should be enclosed in single quote marks. Sometimes an incorrect
single quote is generated by Word (this seems to be associated with the keyboard used). You can
determine the “value” of a character in Word by selecting it and then pressing the ALT + X (the letter x)
keys. That will display the value of the character. It should have a value of 0027. If you have the wrong
value – go to the SQL Web site an copy one of the single quotes from an “Example” and use that in your
C) Declaring a field to be numeric, and using single quotes in a Select statement (for the field’s value)
seems to generate a Something Went Wrong error message, or even worse it may blank the field. I
suggest you double check whether you are using character or numeric fields – and ensure the Select
statement field is consistent with the Insert statement.
D) The Insert command does not display the contents of the record entered into the table.
The site will return a “SQL Command executed” message.
This is “not” an error
Use Select * From YourTableName to display all records in the table.
E) If the above does not localize the problem I suggest starting again: use the DROP TABLE command to
delete your table. Then use the Create command to reestablish the table. Then use an INSERT command
to load only the first field. If that works then add the second field name (and a value), and so on. Each
INSERT will add a new record – which has values only in the specified fields. Once you master the Insert
command, then DROP the table and use the INSERT command to load a record with all fields and values.
Why Choose Us
College Research Papers
We offer professionally written research papers to our clients. We ensure all instructions are followed and that your custom paper is perfect. For a custom research paper, we have expert writers to help you. They will write your paper and earn you good grades
Professional Academic Writers
Are you looking for professional essay writers? Do you need custom paper writers to do your assignment? College essays online is packed with experienced writers who will handle your write my essay request. Order today to get quality services
Free Unlimited Revisions
Do you feel like your paper did not meet the requirements? Is there some instructions that have been skipped? Do not panic. Resubmit your essay for free and unlimited revisions. College essays online work to ensure our clients are satisfied.
Do you have an urgent essay and you don't know what to do? Do you have very little to do your assignments. Visit our online essay writing service for assistance. We have professional essay writers who will take your urgent paper. We have the best turn-around timein the market
If you are looking for a place to find original and plagiarism-free papers, visit collegessaysonline.com. We write your essay from scratch following your instructions. We ensure that every requirement is met, be it quality, delivery time, instructions etc.
24/7 Customer Support
If you have any concern or request, contact us anytime. We have a large team of customer support that are available 24/7. If it's a revision, send the revision file and any additional instructions and we will take care. Do not hesitate, Place an order with us today!
Are you looking for help with an argumentative essay? Do you have difficulties writing an argumentative essay? College essays online is here to help you. We will write a custom essay that meets your requirements. Do not feel overwhelmed, visit our cheap college essay website for professional academic writing help.
Do you need help with a reflection paper? Are you feeling challenged when writing a reflective essay? Are you looking for someone to write my reflection essay help? College essay writers have the answer to your problems. Submit your reflective paper assignment and let our paper writers do the difficult work.
If you are looking for someone to write an award winning scholarship essay, you landed at the right place. Our custom essay writers are professionals and have a 10 year experience. We will write a scholarship paper that will impress the scholarship committee. Hurry to get 25% discount.
Are you looking for a critical analysis essay help? Do you need an online essay writing service to write your critical thinking essay? Visit our college essay website for help. We have professional essay writers who will develop a perfect critical essay for you.
Ethics is a prominent subject in many schools. Professors often ask students to reflect on a topic on ethics and write an essay. This requires a lot of research and knowledge. If you have been assigned an ethical research essay, contact essay writers at college essays online for assistance.
A narrative essay requires a student to tell a story about something. It might be historical or a present narration. This type of essay follows certain rules and instructions. When you face challenges writing a narrative paper, visit our narrative essay writing service.