Question: 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

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

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!