Answered You can hire a professional tutor to get the answer.

QUESTION

I need help with this assignment in (MS access) but there isn't any way to submit the work that I have done so far, I have the file created but

I need help with this assignment in (MS access) but there isn't any way to submit the work that I have done so far, I have the file created but having some trouble finishing, please advise if there a way to upload to help with this assignment., mostly having trouble with numbers 9, 11, 14 An answers is needed ASAP

Createa table named STUDENTS with the following fields. If a field is marked as not required, it needs to be a part of the table, but the user does not have to enter data into that particular field. Do not change the field names, data types or data sizes - follow directions as specified below):

1.StudentId - autonumber - unique id/primary key

2.StudentFirstName - text(20)

3.StudentMiddleName - text(20-not required)

4.StudentLastName - text(30)

5.BirthDate - date

6.Major - text(50)

7.Minor - text(50-not required)

8.CertificateProgram - text(50-not required)

9.ClassLevel - Freshman, Sophomore, Junior, Senior, Graduate

10.GPA - decimal number with 3 decimal points between 0 & 4.000 (for example 3. 456)

11.SemesterHoursCompleted - number between 0 & 180

12.AdmissionDate - date

13.GraduationDate - date (not required)

14.Creat at least 5 records in the STUDENTS table created above. All values must be meaningful and within the data type and range as specified in the table

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question