Access's design view helps minimize confusion when editing tables, as it displays every field and property in a single view, allowing you to see the structure of the entire table.

Creating Tables in Design View You have created a new database in the first part of this tutorial, and you've chosen to create a table in Design View. Below is a portion of what you should have on ...

Access will display a blank Table window in ‘ Design ’ view. In the new table, for the first field, enter a field name and a data type. Read: How to Create, Edit and Delete a Table ...

Relationships link one Table to another. This article explains how to Create, Edit and Delete a Table Relationship in Microsoft Access.

Create a query from within Access that attaches to my SQL Server and retrieves the recordset. I'd likely use the same technique I applied in this thread. <BR>2.

If you've been searching for a way to use the table structure in an existing Microsoft Access database in another table, then check out this quick tip. It shows how to copy and customize the table ...