Create a Form for a Query or Table, Edit & Delete Data, Navigate through Records, Add & delete Rows and Records in a Form in Access.

The ImportExportSpreadsheet form appears. This form allows you to set up the parameters Access needs to import your spreadsheet. Type the name of your table in the "Table name" text box.

I'm connected to and manipulating a Access Database using a VB frontend. But I'd like to add a simple table with 2 fields and populate it and I'm not sure how to go about doing this, google ...

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.

Learn how to add and remove Primary Keys from an Access database table. The primary key's purpose is to promptly associate data from multiple tables and combine that data.