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'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.

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 ...

When users create an Access database, the data is stored in the table. When individuals want to add Fields to their table, they usually add fields in the Design view.

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 ...