Assignment p
Solomon Kane
MSAccess-Assignment4-Chapter8Worksheet.docxMSAccess - Assignment 4 – Chapter 8 (30 pts)
Instructions : Add your SQL command and results (using copy/paste and screen capture) to each question. Do NOT remove any existing content or images from this file. You MUST include both your SQL Command and Results from running that command in your response to each question.
1. (10 pts) List the guide number, first name, and last name for all guides. The first name should appear in lowercase letters and the last name should appear in uppercase letters. NOTE: MSAccess uses the functions LCASE and UCASE whereas Oracle uses LOWER and UPPER. Mod1218
Put your SQL command and results here:
2. (10 pts) Every guide receives their first review 6 months after their hire date. List the guide’s last name, first name, and hire date and his/her first review date. Use REVIEW_DATE as the column title. NOTE: MSAccess uses the function DATEADD whereas Oracle uses the function ADD_MONTHS.
Put your SQL command and results here:
3. (10 pts) Repeat the previous question but display the guides’ names as first name followed by last name (for example, Rita Boyers). Use NAME as the column title for the guides’ names. NOTE: MSAccess uses the ‘&’ symbol instead of the two vertical bars (‘||’) that Oracle uses.
Put your SQL command and results here:
MSAccess
-
Assignment 4
–
Chapter 8
(30 pts)
Instructions
:
Add your SQL
command
and results (
using copy/paste and screen capture
) to each
question.
Do NOT
remove
any existing content or images from this file.
You
MUST
include both your
SQL
C
ommand
and
Results
from running that command in your response to each question.
1.
(10
pts)
List the guide number, first name, and last name for all guides. The first name
should
appear in lowercase letters and the last name should appear in uppercase letters
.
NOTE: MSAccess uses the functions
LCASE
and
UCASE
where
as
Oracle uses LOWER and UPPER.
Mod1218
Put your SQL command and results here:
2
.
(10
pts)
Every guide receives their first review 6 months after their hire date.
List the
guide’s last name, first name,
and
hire date and his/her first review date.
Use
REVIEW_DATE as
the column title
.
NOTE: MSAccess uses the function
DATEADD
whereas Oracl
e
uses the
function
ADD_MONTHS
.
MSAccess - Assignment 4 – Chapter 8 (30 pts)
Instructions: Add your SQL command and results (using copy/paste and screen capture) to each
question. Do NOT remove any existing content or images from this file. You MUST include both your SQL
Command and Results from running that command in your response to each question.
1. (10 pts) List the guide number, first name, and last name for all guides. The first name
should appear in lowercase letters and the last name should appear in uppercase letters.
NOTE: MSAccess uses the functions LCASE and UCASE whereas Oracle uses LOWER and UPPER. Mod1218
Put your SQL command and results here:
2. (10 pts) Every guide receives their first review 6 months after their hire date. List the
guide’s last name, first name, and hire date and his/her first review date. Use REVIEW_DATE as
the column title. NOTE: MSAccess uses the function DATEADD whereas Oracle uses the
function ADD_MONTHS.
