Creating a Table in Design View

From NeoWiki

(Difference between revisions)
Jump to: navigation, search
Revision as of 02:51, 3 August 2007 (edit)
Lorinda (Talk | contribs)
(add Solveig Haugland link)
← Previous diff
Current revision (10:51, 29 March 2008) (edit) (undo)
( | contribs)
m (typo - add e to labeled,, remove extraneous the from point 3.3)
 
(7 intermediate revisions not shown.)
Line 1: Line 1:
-{{redbox|This article is part of the [[To Base and Back Again]] tutorial series.}}+{{TBBA Header}}
While we had an existing set of data for the bird list, the remainder of our tables are not built on existing spreadsheets. So we will design the other tables by hand. If one is creating a database with more "conventional' fields (name, address, phone number, account number, etc.) using the wizard can simplify the process. But since the wizard is not designed with fields related to birding, it is easier to create the needed tables in design view. While we had an existing set of data for the bird list, the remainder of our tables are not built on existing spreadsheets. So we will design the other tables by hand. If one is creating a database with more "conventional' fields (name, address, phone number, account number, etc.) using the wizard can simplify the process. But since the wizard is not designed with fields related to birding, it is easier to create the needed tables in design view.
#Open your database document. #Open your database document.
-#Click on the '''Tables''' icon in the left column (labled {{section|Database}}.+#Click on the '''Tables''' icon in the left column (labeled {{section|Database}}).
#Click on {{prefName|Create Table in Design View...}} icon in the {{section|Tasks}} section #Click on {{prefName|Create Table in Design View...}} icon in the {{section|Tasks}} section
#For each field: #For each field:
##type a field name ##type a field name
-##once a field name is chosen, Neo enters Text[VARCHAR] as the field type; if this is not the correct field type, click on this field type (in the same row as the field name); a drop-down menu appears; choose the correct field tpe+##once a field name is chosen, Neo enters Text[VARCHAR] as the field type; if this is not the correct field type, click on this field type (in the same row as the field name); a drop-down menu appears; choose the correct field type
-##Make the necessary adjustmennts in the {{section|Field Properties}} section below the fields list.+##Make the necessary adjustments in the {{section|Field Properties}} section below the fields list.
###be sure that you have provided sufficient length for your fields; this cannot be changed later. ###be sure that you have provided sufficient length for your fields; this cannot be changed later.
###You can specify that the field must have an entry (necessary for primary key fields). ###You can specify that the field must have an entry (necessary for primary key fields).
-###You can specify a {{prefName|Default Value}} for those cases when a field will usually (but not always) have a specific value. For example, the you could enter your own state abbreviation in the State field of the Locations table.+###You can specify a {{prefName|Default Value}} for those cases when a field will usually (but not always) have a specific value. For example, you could enter your own state abbreviation in the State field of the Locations table.
###For those tables where the primary key will be an ID field, the field type should be Integer, and {{prefName|AutoValue}} should be set to {{prefName|Yes}} ###For those tables where the primary key will be an ID field, the field type should be Integer, and {{prefName|AutoValue}} should be set to {{prefName|Yes}}
#Select the row with the field that is to be the primary key. A green triangle will appear in the left hand column. #Select the row with the field that is to be the primary key. A green triangle will appear in the left hand column.
Line 22: Line 22:
[http://searchenterpriselinux.techtarget.com/tip/0,289483,sid39_gci1148271,00.html Using the Wizard to Create a Table] [http://searchenterpriselinux.techtarget.com/tip/0,289483,sid39_gci1148271,00.html Using the Wizard to Create a Table]
:an article by Solveig Haugland. :an article by Solveig Haugland.
 +
 +{{botlangbarEN|[[Fr:Créer une Table en Mode Ébauche|Français]] [[It:Creare_una_Tabella_in_Vista_Struttura|Italiano]]}}
 + [[Category:Tips and Hints]][[Category:NeoOffice]]

Current revision

This article is part of the To Base and Back Again tutorial series.

While we had an existing set of data for the bird list, the remainder of our tables are not built on existing spreadsheets. So we will design the other tables by hand. If one is creating a database with more "conventional' fields (name, address, phone number, account number, etc.) using the wizard can simplify the process. But since the wizard is not designed with fields related to birding, it is easier to create the needed tables in design view.

  1. Open your database document.
  2. Click on the Tables icon in the left column (labeled Database).
  3. Click on Create Table in Design View... icon in the Tasks section
  4. For each field:
    1. type a field name
    2. once a field name is chosen, Neo enters Text[VARCHAR] as the field type; if this is not the correct field type, click on this field type (in the same row as the field name); a drop-down menu appears; choose the correct field type
    3. Make the necessary adjustments in the Field Properties section below the fields list.
      1. be sure that you have provided sufficient length for your fields; this cannot be changed later.
      2. You can specify that the field must have an entry (necessary for primary key fields).
      3. You can specify a Default Value for those cases when a field will usually (but not always) have a specific value. For example, you could enter your own state abbreviation in the State field of the Locations table.
      4. For those tables where the primary key will be an ID field, the field type should be Integer, and AutoValue should be set to Yes
  5. Select the row with the field that is to be the primary key. A green triangle will appear in the left hand column.
  6. Control-click or right-click on the green triangle and choose Primary Key from the contextual menu. A key icon appears in the far left column. Remember that each record of your database must have a unique entry in the primary key field.
  7. Click on the disk drive icon on the toolbar at the top of the window; this saves your changes.
  8. Close the window and return to the main database document window

External Links

Using the Wizard to Create a Table

an article by Solveig Haugland.


This article in other languages: Français Italiano
Personal tools