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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started