Creating a university grade system on Microsoft access.
Not what you're looking for?
Must be created in Microsoft Access
Create the following tables for a "University Grade System".
Courses
Majors
Student Info
Courses Taken
Courses Table:
Course (This is the key and is a six letter text field)
Advisor (This is a required 40 letter text field)
Extension (This is a required four digit extension field)
Put the following data into the table
MTH100 Robert Rubenstein 1375
CSS200 Suzy Simpson 1476
BUS101 Ed Espinoza 1567
SOC404 Fred Fong 1577
Majors Table:
Create a table with a primary key to identify the following majors:
Business
Computer Information
Math
Student Info Table:
Student ID (Automatically Generated sequential number)
FirstName (12 character text field)
MiddleInitial (1 character text field)
LastName (15 character text field)
Phone (Use appropriate mask)
Socsec (Use appropriate mask for social security number)
Major (Must already be in "Majors" table to be accepted)
Birthdate (Use appropriate mask for date)
Year in School (FR, SO, JR, SR)
Courses Taken Table;
Create a table that will store information about each student that took a course and what grade they received. The information should include the semester of completion.
Create an input form with appropriate form controls for each of the tables listed above (four) and put in at least ten records in the Student Info Table and at least twenty records in the Courses Taken table.
Purchase this Solution
Purchase this Solution
Free BrainMass Quizzes
Word 2010: Tables
Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.
Excel Introductory Quiz
This quiz tests your knowledge of basics of MS-Excel.
Java loops
This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.
Basic Computer Terms
We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.
Javscript Basics
Quiz on basics of javascript programming language.