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.

I do not believe Jet (the database engine Access uses) supports table-level triggers, so you'll need to use a macro or VBA code in a form to trigger the extra record.

Add Note Launch Microsoft Access and open a database that contains one or more forms. Form names appear in the Forms section on the left side of the user interface.

Click "Next." Select "Automatically Process Replies and Add Data to the Database" and select the "Set Properties" link to open the Collecting Data Using Email Options dialog box.

Learn how to remove or add Images to Access form The attachment feature allows the user to add image files to a record such as documents, presentations, images, etc.

Microsoft announced last Friday that it is bringing Access, the personal database program from its Office productivity suite, to Office 365 Business and Business Premium plans.

A few best practices can go a long way toward protecting your Access data from careless or overly curious users. Here are some simple ways to add a few layers of security to a database.