Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

* USE VISUAL STUDIO FOR THIS ONE* 1. Create a single form that lets the user type in customer contact information. In the next projects,

*USE VISUAL STUDIO FOR THIS ONE*

1. Create a single form that lets the user type in customer contact information. In the next projects, we will add a database to this, so you want text boxes that will eventually link to fields in a table in a database. Ensure that the following is completed by the user when the submit button is clicked (if not, show a message box indicating the errors)

  • first and last name both have at least 3 letters
  • zip code is 5 numbers
  • phone is 10 numbers (you can add in or strip out hyphens--choice is yours)
  • email must exist (if you can find code that looks for @ and other relevant email features, add it)
  • if you add birth date or any date, make sure it is in the right format

If there is any way that the program can fail, add code to prevent that from happening. Once the submit button is pressed, the fields should be cleared and focus set on the first text box to get ready for the next customer entry. I'm sure you've done similar programs in your previous class, but this will prepare us for the next projects--and let you refresh your memories. There are no calculations in this program.

*THIS QUESTION BELOW REFERS TO THE QUESTION (1) ABOVE THUS, I WOULD LIKE HELP WITH THE SECOND BUT WOULD APPRECIATE IF BOTH ARE ANSWERED*

2. Create a relational database in either Access or SQL Server that has 3-4 tables. One will contain contact information to coincide with the form created in project 1. Add 1 record to each table you create. You will build on project 1, so copy the project and rename it as project 2. Add 2 forms as described below: One form--

  • Add a datagrid to the form
  • Connect to the database and bring in data from one of the tables (not the contact info table)
  • Add code as needed to ensure the user can add, edit, delete data from the datagrid--very little code is needed for this
  • Modify the datagrid so that all information is visible--change column widths, fonts, colors as needed (see my information about datagrids in the resources folder)

Second form--

  • This will be the opening form of the program
  • Add buttons so the user can open the datagrid form and the contact info form (we'll add code to that one in project 3)
  • When this form closes, so does the program

Save everything--you should have 3 forms. Make sure you add comments where needed. Zip entire program folder and attach to this assignment.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

12th edition

133544613, 978-0133544619

More Books

Students also viewed these Databases questions