Tag: create table

How to Create a Table in SQL Server

Posted on by Ian

To create a table in SQL Server using the GUI:

  1. Ensuring that the right database is expanded in Object Explorer, right click on the Tables icon and select Table... from the contextual menu
  2. A new table will open in Design view. Add the columns, their data types, and column properties.
  3. Save the table (either from the File menu, or by right-clicking on the table tab and selecting Save Table1)

The table will appear in the Object Explorer under the Tables icon for the applicable database.

Continue reading →

How to Create a Table in Access

Posted on by Ian

To create a table in Microsoft Access 2013 or 2016:

  1. Click CREATE from the Ribbon
  2. Click Table

Here’s what that button looks like on the Ribbon:

Screenshot of the CREATE tab of the Ribbon in Microsoft Access 2013
Clicking the “Table” icon from the “CREATE” tab creates a new table.

Those two steps create a blank table.

Once you’ve created your table, you will need to add fields (these will contain the data). You will also need to specify the type of data that the fields will contain (eg, text, number, date, etc).

You can also add extra rules about the type of data that can be entered into each field (eg, that phone numbers should be entered this way, dates should be entered that way, etc), as well as other properties for each field.

Continue reading →