Create a validation rule which limits the states

Assignment Help Computer Engineering

Reference no: EM133808672

Assignment: Creating a New Database

What to do Next - Take Home Test

Next Create a New Database and the following tables using Access. subject to these business rules

A. Students and parents can have only one email address
B. All email addresses must be in a format similar to this [email protected]
C. Phone numbers must be input in this format 352.212.4477
D. Parents and students can only be from the following states: Texas, Louisiana, Mississippi, Alabama
E. We store state names with their two digit abbreviations only.
F. We can have no blanks in the database (No Nulls Allowed)
G. Students only can major in the following: Computer Information System, Accounting, Management or Marketing.
H. All table fields are labeled using this format (example Student Id is labeled Student_Id)

Do the following

A. Name the Database With the Following Name: YOUR NAME Database

B. Create one Table called Student.

a. Place in the table the following columns: Student ID, First Name, Last Name, University Street Number, University Street Name, University City, University State, University Zip Code, StudentEmail ssume for now they have only one email)

C. Create a second Table called Parent

a. In that table create the following fields: Student ID, Parent First Name, Parent Last Name, Parent email, Parent phone number, Parent Street Number, Parent Street Name, Parent City, Parent State, Parent Zip, ParentEmail (assume for now they have only one email)

D. Create a third table called Major.

a. In that major create these fields, Major ID and Major Name

E. For each field in all tables select an appropriate datatype and fill in the comments. If you are unaware of what each datatype is, please use Google to research that question

F. For each field in all tables make the field required.

G. For the tables

a. Limit the state name to 2 digits (Example: Louisiana = La)

b. Create a validation rule which limits the states to the approved 2 digit format used by the post office. The tutorial will provide you this

c. Create an input mask for the phone numbers to appear in this format 222-222-2222

d. Create a validation rule where the email address must be in this format.

Reference no: EM133808672

Questions Cloud

Begin work on the personal legislative agenda : Accessing the expertise, experience, and ideas of others allows us to fully examine topics and plans to ensure no stone is left unturned

Charlotte and Emma for the sale of the painting : Explain whether there is a valid contract between Charlotte and Emma for the sale of the painting.

Who gave the name the pre-islamic era to this era and why : Who gave the name the pre-Islamic era to this era, and why? Was this era really a backward era? And why? Briefly

Advocacy priorities for individuals with disabilities : Expanding tax credits and deductions for employers. This bill explicitly targets hiring and retaining employees who receive disability insurance benefits

Create a validation rule which limits the states : Create a validation rule which limits the states to the approved 2 digit format used by the post office. The tutorial will provide you this.

Claiming the evidence is irrelevant : The defense intends to offer evidence to show that at the time of the robbery Jeff was drunk. The prosecution objects, claiming the evidence is irrelevant

Specific performance may be available for breach of contract : Specific performance may be available for the breach of a contract to sell. To make a good faith purchase of goods similar to those in a contract is to

Explain what information you would need to take : Support your reasoning with at least three scholarly resources, one each on the FDA-approved drug, the off-label, and a non-medication intervention

How do you incorporate exercise into your daily life : How do you incorporate exercise into your daily life. You need to decide (as a pair/group) what are the best questions are that you want to ask.

User Account

All Pages