In the Design View: How to Create and Edit Tables


show more Creating and editing tables in Design view provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training show less
please wait ...

Creating and editing tables in Design view

Access 2010's Table Design View is the most powerful place to create your tables. Click on the Create button and then on Table Design. This Design View has the most detail for table construction. In addition to all the features on the Table Tools Field's Ribbons, it has many more customizable field properties. So we'll build a table from scratch here. And in the next lesson, we'll look at the tables we built to add in our field properties, down here. So our next table is our Products table. Two Trees Olive Oil sells olive oil, both to retail stores and wholesale to restaurants.

The fields we'll need to create are the item SKU, the name, the size, our cost, the retail price and our profit margin. So this view is a list view. I think of it like building your house. Here's where we lay the foundation, build the structure and hang the drywall. So the first thing we need is our ID field. Because this is a Product, let's type in SKU. The SKU will be a combination of type ...

Creating and editing tables in Design view
Video duration: 2m 41s 3h 30m Beginner

Viewers:

Creating and editing tables in Design view provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training

please wait ...