Question: Using Microsoft SQL Server Express or Microsoft Access, design a database with one table to store the following information: Student_ID 6 digit alphanumeric string that

Using Microsoft SQL Server Express or Microsoft Access, design a database with one table to store the following information: Student_ID 6 digit alphanumeric string that must begin with a lowercase letter Student_FirstName must only contain valid alphabet characters and cannot be blank Student_LastName -- must only contain valid alphabet characters and cannot be blank Student_Major must be a selection of the following from a dropdown combo box Business Administration Computer Science Information Systems Justice Administration Psychology Student_PhoneNumber must be of the format 555-555-5555 and cannot be blank Student_EmailAddress must be of the proper email format (xxxxxx@herzing.edu) and cannot be blank Part 2 Build a Visual Basic user interface (front end) called IS171_Student_Info that allows for the following: Ability to insert a record into the database table Ability to delete a record from the database table Ability to update a record from the database table

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!