access_2007_table_design_view_transcript

access_2007_table_design_view_transcript - Creating a Table...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

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.

Ask a homework question - tutors are online