The purpose of this tutorial is to show how to use Microsoft SQL Server Management Studio Express to (1) create Microsoft SQL Server Express database, (2) create database tables, (3) add data to tables, and show the data in tables.

1] Open Microsoft SQL Management Studio, or Microsoft SQL Management Studio Express. Using the mouse, right mouse click on Databases --> Select New Database ...   (See Below!)
 

2] Name the database TU.  Using the mouse, select/push the OK button.  (See Below!)

1] Expand the TU database. Right mouse click on Tables and select New Table ... (See Below!)

2] Add fields FirstName, LastName, ID, Gender, SpecialtyID, and About to your new database table; you can see the data types in the screen capture below. The SpecialtyID field in an integer; in order to get the MSSQL database to auto number, set the Identity Specification to Yes.  Using the mouse, select/push the OK button.  (See Below!)

3] Now that the database table is defined, it is time to save the Table.  Using the mouse, hold down the File Menu --> Select Save Table_1  (See Below!)

4] Name the table Faculty.  Using the mouse, select/push the OK button.  (See Below!)

5] You can see that the Faculty Table has now been added to the TU database.  (See Below!)

1] Right mouse click on Tables and select New Table ... (See Below!)

2] Add fields SpecialtyID, and Description to your new database table; you can see the data types in the screen capture below. The SpecialtyID field in an integer; in order to get the MSSQL database to auto number, set the Identity Specification to Yes.  Using the mouse, select/push the OK button.  (See Below!)

3] Now that the database table is defined, it is time to save the Table.  Using the mouse, hold down the File Menu --> Select Save Table_1  (See Below!)

4] Name the table Specialty.  Using the mouse, select/push the OK button.  (See Below!)

10] You can see that the Specialty Table has now been added to the TU database.  (See Below!)

 

1] Right mouse click on the Specialty Table --> Select Open Table  (See Below!)

2] Add records Networking, Database, Simulation, Parallel Processing, Artificial Intelligence, Graphics, and Theory  (As Illustrated Below!)

1] Right mouse click on the Faculty Table --> Select Open Table  (See Below!)

2] Add the records for Eggen, Hicks, Massingil, Myers, and Lewis to the table.  (As Illustrated Below!)

Tutorial: Visual Studio Windows Application - Forms - Basic Forms

Tutorial: Visual Studio Windows Application - Forms - Buttons & Color Picker

Tutorial: Visual Studio Windows Application - Forms - Menu Driven Application With Multiple Forms

Tutorial : Visual Studio Windows Application - Forms - MenuStrip Driven Application

Tutorial: Visual Studio Windows Application - Forms - Passing-Data Between Parent Child Forms

Tutorial: Visual Studio Windows Application - Adding A Web Browser Component To A Database Form

Tutorial: Microsft SQL Server Express- 2008 Advanced (With Server Management Studio) Express Install

Tutorial: MSSQL Database Construction With Server Management Studio

Tutorial: MSSQL Database Import, Export, & Backup With Server-Management-Studio

Tutorial: Visual Studio Windows Application - Forms - MSSQL Connections & ComboBoxes

Tutorial: Visual Studio Windows Application - Forms - MSSQL GUI Connections & DataGrids

Tutorial: Tutorial: Tutorial: Visual Studio Windows Application - MSSQL Connections To A Library Application

Tutorial: Visual Studio Windows Application - Forms - Custom MSSQL Record Lock-Out System For Multi-User LibraryApp - 1
[Database Configuration, Database Authentication, Generic Database Utilities, Etc.]