Create Datasheet View Table: Create Table (Table) in Access 2016

This updated guide examines Create Datasheet View Table: Create Table (Table) in Access 2016 and organizes the essential facts, background, and practical takeaways in clear American English.

Create the Datasheet View table

Let's try to create the first table, storing basic information of Company employees as follows:

School's nameDatatypes NhanvienID AutoNumber Ten Short Text Ho Short Text Diachi1 Short Text Diachi2 Short Text Short Text Thanhpho Short Text Mabuudien Short Text Dienthoai Short Text

According to the table above, we have the Short Text data type that applies to all data fields. Next, open an empty database in Access.

Create Datasheet View Table: Create Table (Table) in Access 2016 — contextual image 1

This is the area we will work with. When opening an empty database, Access automatically in the Datasheet View table mode .

Now that we switch to the Field tab, you'll see that the ID field is automatically set to the AutoNumber data type, which is the unique ID and the primary key in this table.

Create Datasheet View Table: Create Table (Table) in Access 2016 — contextual image 2

The ID field is already created, now we rename it to suit our requirements. Click Name & Caption in the Ribbon and you will see a dialog box appear.

Create Datasheet View Table: Create Table (Table) in Access 2016 — contextual image 3

Create Datasheet View Table: Create Table (Table) in Access 2016 — contextual image 4

Change the name of this field to NhanvienID to match the created table. Enter other optional information if you want and click OK .

Create Datasheet View Table: Create Table (Table) in Access 2016 — contextual image 5

Now let's add some fields by clicking Click to add .

Create Datasheet View Table: Create Table (Table) in Access 2016 — contextual image 6

Select the Short Text data type and enter a name in all fields.

Create Datasheet View Table: Create Table (Table) in Access 2016 — contextual image 7

When all fields are fully added, click the Save icon to bring up the Save As dialog box, enter the table name into the Table Name for the newly created table.

Create Datasheet View Table: Create Table (Table) in Access 2016 — contextual image 8

You may wonder, the prefix tbl stands for table . Click OK and you will see the table appear in the navigation pane.

Create Datasheet View Table: Create Table (Table) in Access 2016 — contextual image 9

Create the Design View table

In the example above Tipsmake created the Datasheet View table. Now we will create another table using Table Design View on a project, including the following fields:

School's nameDatatypes DuAnID AutoNumber TenDuAn Short Text BienTap Short Text TacGia Short Text TinhTrang Short Text HopDong Attachment TimeBatdau Date / Time Time Date / Time NganChang Currency Write Long Text

Next go to the Create tab .

Create Datasheet View Table: Create Table (Table) in Access 2016 — contextual image 10

Click Table View , you can see this interface field name and data type will be placed side by side, completely different from Datasheet View.

Create Datasheet View Table: Create Table (Table) in Access 2016 — contextual image 11

Now we need to set DuAnID as the primary key for this table, select DuAnID and click the Primary Key option in the ribbon.

Create Datasheet View Table: Create Table (Table) in Access 2016 — contextual image 12

You can now see a small key icon that will display next to that field.

Next, save and name this table.

Create Datasheet View Table: Create Table (Table) in Access 2016 — contextual image 13

Click OK. You can also edit this panel to the Datasheet View format by clicking the View button in the left corner of the Ribbon

Create Datasheet View Table: Create Table (Table) in Access 2016 — contextual image 14

If you want to edit this or any specific field, you can edit it directly in this form, without having to go back to Design View to change it. For example, update the TinhTrang field as shown below.

Create Datasheet View Table: Create Table (Table) in Access 2016 — contextual image 15

Click Ok to see the changes.

Create Datasheet View Table: Create Table (Table) in Access 2016 — contextual image 16

Previous article: Data types in Access 2016

Next lesson: Working with Table in Access 2016

FAQ

What is Create Datasheet View Table: Create Table (Table) in Access 2016 about?

It provides a structured overview of Create Datasheet View table, explains the main context, and highlights practical takeaways for readers.

Why does this topic matter?

Understanding the main concepts helps readers evaluate the issue, avoid common mistakes, and make better-informed decisions.

How should readers use this information?

Use the guidance as a practical starting point, confirm details that may have changed, and follow current product, safety, or security recommendations.