Reference no: EM131085361
TASK 1:
Create a database: LastName_FirstName_Final
1. Using Access, create two tables and name them LastName_FirstName_STUDENTS and LastName_FirstName_Degrees.
2. Create the following fields for the LastName_FirstName_STUDENTS table:
a. STUDENTID = Text (field size 6) - primary key -
b. First Name = Text (field size 25)
c. Last Name = Text (field size 25)
d. Date of Birth = Date/Time
e. Street Address = Text (field size 30)
f. City = Text (field size 20)
g. State = Text (field size 2)
h. Zip Code = Text (field size 10) Use the Input Mask Wizard to specify a nine-digit Zip Code. (Hint: At the first Input Mask Wizard Dialog Box, click Zip Code in the Input Mask list box.)
i. Phone Number =? (use Input Mask)
j. DegreelD = Text (field size 5)
3. Key in at least 7 records. Make sure you use different Zip Code and DegreelD.
4. Create the following fields for the LastName_FirstName_Degrees table:
a. DegreelD = Text (field size 5)
b. Description = Text (field size 50)
c. TotalCredit = Number
5. Key in at least 3 records. Make sure you use: BUSIN, COSCI as FINAN.
6. Save both tables.
7. Create a report showing all students First Name, Last name, DegreeID, and TotalCredit.
8. Create a query showing all students who enrolled in COSCI degree. Show the students First Name, Last Name, Phone numbers, and DegreeID. Make sure only three records showing in the query. Save query as LastName_FirstName_COSCI_STUDENTS.
|
What is the initial velocity of the ball
: A boy kicks a football with a certain initial velocity at anangle 30° above the horizontal. In 3.0 seconds, the ball reaches at its highest point in its trajectory. What is the initial velocity of the ball?
|
|
Speed of the combination after the collision
: A bullet of mass m1 = 30grams is moving at speed v1 of 200m/s and it collides head on with another (stationary) mass m2 = 10 grams. They stick together after the collision. What is the speed of the combination after the collision?
|
|
The possible range for a correlation coefficient
: Assume that you are 23 years old and that you place $3,000 year-end deposits each year into a stock index fund that earns an average of 9.5% per year for the next 17 years.
|
|
What is the magnitude of the electric field
: In a region where the electric field is uniform and points in the +x direction, the electric potential is -2000 V at x= 8 m and is +400 V at x= 2 m. What is the magnitude of the electric field?
|
|
Create report showing all students first name and last name
: Create a report showing all students First Name, Last name, DegreeID, and TotalCredit. Create a query showing all students who enrolled in COSCI degree. Show the students First Name, Last Name, Phone numbers, and DegreeID.
|
|
Lens numerical aperture in air
: A 6.0-mm-diameter microscope objective has a focal length of 9.0 mm. a. What object distance gives a lateral magnification of -40? b. What is the lens's numerical aperture in air?
|
|
Explain the reasons employees join unions
: Explain the reasons employees join unions - Describe the process by which unions organize employees and gain recognition as their bargaining agent.
|
|
Negotiate a severe curve on a rural highway
: Drivers must slow from 70 mph to 40 mph to negotiate a severe curve on a rural highway. A warning sign for the curve is visible for 100 ft. How far in advance of the curve is it necessary to post the sign to insure that vehicles are able to proper..
|
|
Write the definition of the function you defined in part a
: Write the definition of the function you defined in part a.
|