在Microsoft Access中，您可以将记录添加到已作为数据的现有表中，并调整包含字段和数据的列的大小，尤其是在列中没有足够的空间来查看所有数据和字段名称的情况下。

^(Add)在Access^(Access)数据表中添加、删除记录和调整列大小

在本教程中，我们将解释如何在数据库中添加记录、如何删除数据库中的记录以及如何调整数据库中的列大小。在Microsoft Access中，数据库是收集和组织信息的工具。

1]如何在数据库中添加记录

在任意字段的一行中输入数据时，默认情况下会在上一条记录的下方自动出现一条记录。

在Microsoft Office 365中，即使用户在快捷菜单中右键单击上一条记录添加新记录或单击主页选项卡上^(Home)记录^(Record)组中的新建^{(New )}按钮，也不会再添加任何记录；它将突出显示下面的新记录。

2]如何^(How)删除数据表中的记录

有两种方法可以删除数据库表中的记录。

方法一是^{(Method one)}右键单击包含数据的记录的左端。

在快捷菜单中，单击删除记录^{(Delete Record)}。

会弹出一个消息框；单击是^(Yes)。

方法二^{(Method two)}是单击行或字段。

然后，单击记录^{(Records )}组中主页^(Home)选项卡上的删除^(Delete)按钮下拉箭头。

在删除^(Delete)按钮快捷菜单中，用户可以选择删除^(Delete)、删除^(Delete) 记录^(Record)或删除列^{(Delete Column)}

选择您的选择。

会弹出一个消息框；单击是^(Yes)。

记录被删除。

阅读^(Read)：如何在 Access 中的查询中创建计算字段^{(How to create Calculated Fields in Query in Access)}。

3]如何^(How)调整Access中的列大小

要调整列的大小，请指向字段选择器的右边界；您会看到该点将变成一个双箭头。

然后，双击或拖动字段选择器到您想要的距离。

调整数据库中的列的大小。

您可以使用相同的技术来调整数据库中所有其他列的大小。

我希望这有帮助; 如果您有任何问题，请在下方发表评论。

相关^(Related)：Mac 的免费 Microsoft Access 替代品。

How to add, delete records and resize columns in Access datasheet

In Microsoft Access, you can add records to an existing table that already as data and resize the columns that contain the fields and data, especially if there is not enough space within the columns to view all data and field names.

Add, delete records & resize columns in Access datasheet

In this tutorial, we will explain how to add records in a database, how to delete records in a database and how to resize columns in a database. In Microsoft Access, a database is a tool for collecting and organizing information.

1] How to add records in a database

When entering data into a row of any of the fields, a record will automatically appear below the previous record by default.

In Microsoft Office 365, even if the user right-clicks the previous record to add a new record from the shortcut menu or clicks the New button in the Record group on the Home tab, it will not add any more records; it will highlight the new record below.

2] How to delete records in a datasheet

There are two methods to delete a record in the database table.

Method one is to right-click the left end of the record that contains data.

In the shortcut menu, click Delete Record.

A Message box will pop up; click Yes.

Method two is to click the row or field.

Then, click the Delete button drop-down arrow on the Home tab in the Records group.

In the Delete button shortcut menu, the user can select Delete, Delete Record or Delete Column

Choose your choice.

A Message box will pop up; click Yes.

The Record is Deleted.

Read: How to create Calculated Fields in Query in Access.

3] How to resize columns in a Access

To resize a column, point to the field selector’s right boundary; you will see that the point will become a two-headed arrow.

Then, double-tap or drag the field selector to the distance you want it to be.

The column in the database is resized.

You can use the same technique to resize all the other columns in the database.

I hope this helps; if you have questions, please comment below.

Related: Free Microsoft Access alternatives for Mac.

Related posts

• NVIDIA Control Panel Access拒绝 - 不会应用设置

• 如何在Word Quick Access Toolbar上展示Spelling and Grammar tool

• 如何从Logon screen中删除Access button的Ease

• 在Chrome中为Remote Access主机启用更少的针对性身份验证

• 什么是远程访问木马？预防、检测和清除

• DHCP Client Service在Windows 11/10提供Access Denied error

• Windows无法启动Service，Error 0x80070005，Access Is Denied

• 如何Backup and Restore Quick Access Folders在Windows 10

• 无法在OS上设置新的Owner，Access在Windows 10上被拒绝

• Fix Error 1005 Access Denied message访问网站时

• Fix Access Control Entry在Windows 10中腐败错误

• 如何在Office程序中自定义Quick Access toolbar

• Outlooktools：Access Outlook Settings & Troubleshooting Tools轻松

• 免费Remote Access software清单Windows 10

• Windows 10中的快速Access不起作用或慢开放

• Use Permissions Time Machine删除File Access被拒绝错误

• TeamViewer：免费的远程访问和控制软件

• 如何使用Microsoft Access创建Report

• Access Replacer：Access button的Access Replacer：Replace Ease，具有有用的工具

• 在Windows Server中配置Remote Access Client Account Lockout