|
|
|
Open the Access Database Click the Blank Access database radio button The following screen will display Click Create button The new database is defined. On the left hand side of the screen are the database objects: Tables, Queries, Forms, Reports, Pages, Macros, and Modules. The database objects are created to input, edit, retrieve, display, and print data records.
Highlight Create table in Design view The screen will split into two parts. The design grid is split into rows and columns. The bottom part of the screen contains the properties.
The Field Name is the subject or heading for the table The Data Type refers to the kind of values that will be stored in this field The Description area is used for brief comments The first Field Name should be a reference to the primary key.
Type in Number Reference: For a complete explanation of the Data Types, see Tutorial on Defining Data Types Every database must have a primary key: a field that uniquely identifies each record. This field is automatically indexed with no duplicates allowed. Highlight the Number field row
The bottom of the screen will automatically change to a new set of properties Reference: For a complete description of the Field Properties, see the Tutorial Understanding field properties
Indexed: Click the black diamond
The field size is very important. Try to narrow the number down to fit the longest name you would input into the database. Special formatting for Telephone
You will see a pop-up screen message
Click Yes A pop-up screen will display with the Input Mask Wizard
Select Phone Number
Accept the default
Click the first radio button option
Click Finish The input mask is now coded in the properties section
Go back to the Input Mask Wizard and see the other options available for Social Security Number, Zip code, Dates, etc. The Input Mask options will help you format data in a standard and consistent field. Enter all your fields and then save your table. Creating the database is the longest task. February 02, 2010 Sr. Arlene Callahan
|
