This preview shows page 1. Sign up to view the full content.
Unformatted text preview: Creating a Table in Design View Using Access 2007 Interactive Transcript This tutorial will illustrate how to create a table in Design view using Microsoft Access. Open a blank or existing database. From the Create tab, click Table Design to start creating a table in Design view. Click in the Field Name area in the first row and type the field name. Click in the Data Type field and select AutoNumber. Let’s create a description, Manufacturer’s ID number, and make this the primary key by clicking the Primary Key button. The field is now complete. Now that we have a field defined, let’s save the table. Let’s call it Manufacturers. Click the Save icon, and enter the table name. Click OK. Let’s add a field for the manufacturer’s name. Click the next line. Type in ManufactName. Notice the Data Type has automatically set itself to a Text type. Look at the Properties area – the default size for a text field is 255 characters. We may have a long manufacturer name, so we can keep the default number of field is 255 characters....
View Full Document
This note was uploaded on 05/23/2010 for the course DATABASE HR587 taught by Professor Prof.panchal during the Spring '10 term at Keller Graduate School of Management.
- Spring '10