Monday, November 9, 2009

Access 2007 7th Period

Access 2007 Tutorial 2

Essay

1. What are the advantages of including a primary key in a table?

2. What are the basic steps you should use when creating a new database?

3. How do you define a field in Design view?
Posted by at
Labels:

14 comments:

  1. lDecember 1, 2009 at 11:57 AM

    midjfifhg

    ReplyDelete
  2. RanaDecember 1, 2009 at 12:08 PM

    Q1: The advantages of including a primary key in a table are that it uniquely identifies each record in a table, Access does not allow duplicate values in the primary key field allowing uniqueness of the primary field, with the primary key there could be no null value, when there is a primary key access puts the data in a primary key sequence, and access responds faster to specific requests when there is a primary key.

    Q2: The basic steps when creating a database are to identify all fields needed to produce the required information, organize each piece of data into its smallest useful part, group related fields into tables, determine each table's primary key, include a common field in related tables, avoid data redundancy, and determine the properties of each field.

    Q3: You define a field in Design view by first in the Field Name box, type the name for the field, and then press the Tab key, Accept the default Text data type, or click the arrow and select a different data type for the field. Press the Tab key, enter an optional description for the field if necessary, and use the Field Properties pane to type or select other field properties, as appropriate.

    ReplyDelete
  3. LayaleeDecember 1, 2009 at 12:09 PM

    Q1: A primary key uniquely identifies each record in a table. Access does not allow duplicate values in the primary key field. When a primary key has been specified, Access forces you to the enter a value for the primary key field in every record in the table.Access displays records bt default in order by the field values of the primary key. Access responds faster to our requests for specific records based on the primary key.

    Q2:Organize each piece of data into its smallest useful part. Group related fields into tables. Determine each table's primary key. Include a common field in relaed tables. Avoid data redundancy.

    Q3:In the Field Name box, type the name for the field, and then press the Tab key. Accept the default Text data type, or click the arrow and select a different data type for the field. Press the Tab key. Enter an optional description for the field, if necessary. Use the Field Properties pane to type or select other field properties, as appropriate.

    ReplyDelete
  4. Naimeh IssaDecember 1, 2009 at 12:09 PM

    Q1: THe advantages of a primary key in a table is it uniquely identifies each record in a table, Access doesn't allow duplicate values in the primary key.Preventing duplicate values ensures uniqueness of the primary key field. ALso, with the primary key there can be no null value and when there is a primary key Access puts the data in primary key sequence. Access responds faster to specific requests when there is a primary key.

    Q2: The basic steps we should use when creating a new data base is identifying all fields needed to produce the required information, organize each piece of data into the smallest part, group related fields into the table, Determine each tables primary key, include a common field in related tables, avoid data redundancy, and determine the properties of each fields.

    Q3:You define a field i design view by first in the field name box you type the name for the field and then press the Tab key, then Accept the default text data type, or click the arrow and select a different data type for the field. Press the tab key. Next, Enter an optional description for the field, if necessary. Finally use the field properies pane to type or select other field properties.

    ReplyDelete
  5. Maram SalamahDecember 1, 2009 at 12:10 PM

    Q1: The advantages of having a primary key is that it uniquely identifies each record in a table. Access does not allow duplicate values in the primray key field.Preventing duplicate values ensures the uniqueness of the primary key field. One can enter records in any order but Access displays them by default in order by the field values of the primary key. With the primary key, there can be no null value. With a primary key in tact access reponds faster to one's requests for specific records based on the primary key.

    Q2: The steps for creating a database is first one has to organize each piece of data into its smallest useful parts. Second one should group related fields into tables. Third one should determine each table's primary key. Fourth one should include a common field in related fields. Fifth one should avoid data redundancy. Lastly one should determine the properties of each field.

    Q3:In the Field Name box, type the name for the field , and then press the Tab key. Accept the default Text data type, or click the arrow and select a different data type for the field. Press the Tab key. Enter an optional description for the field, if necessary. Use the Field Properties pane to type or select other field properties, as appropriate.

    ReplyDelete
  6. A. MajidDecember 1, 2009 at 12:16 PM

    Question 1
    A Primary key uniquely identifies each record in a table.
    Access does not allow duplicate values in the primary key field.
    When a primary key has been specified there could be no null value
    Access stores records on disk as you enter them you can enter records in any order but access displays them by defalut by the field value of the primary key.
    Access responds faster to your requests for specific records based on the primary key.

    Question # 2
    Organize each piece of data into its smallest useful part
    Group related fields into tables
    determine each tables primary key
    include a common field in related tables
    avoid data redundancy
    Determine the properties of each field


    Question # 3

    In field name box type the name for the field and then press the tab key.
    Accept the default text data type or click the arrow and select a different data type for the field press the tab key
    enter an optional description for the field if necessary
    use the field properties pane to type or select other field properties as appropriate.

    ReplyDelete
  7. MaRy-MDecember 1, 2009 at 12:16 PM

    Q1. Some advantages of including a primary key in a table are:
    -A primary key uniquely each record in a table
    -With a primary key there could be no null value
    -Access responds faster to your requests for specific records based on the primary key
    -Access displays records by default in order by the field values of the primary key. This way, you are ensured that you will later be able to work with them in a more meaningful, primary key sequence

    Q2. Basic steps for creating a new database are:
    -Identify all the fields needed to produce the required information
    -Organize each piece of data into its smallest useful part
    -Group related fields into tables
    -Determine each table's primary key
    -Include a comon field in related tables
    -Avoid data redundancy

    Q3.You define a field in design view by:
    -In the fiels Name box, type the name for the field, and then press the tab key
    -Accept the default Text data type, or click the arrow and select a different data type for the field. Press the Tab key
    -Use the Field Properties pane to type or select other field properties, as appropriate

    YAY!!!!!!! I'M DONE!!!!!!!!

    ReplyDelete
  8. haneefah cummingsDecember 1, 2009 at 12:17 PM

    1. the advantages of including a primary key in a table are numerous but some of them is that a primary key uniquely identifies each record in a table.It also has the advantage of Access responds faster if you have a primary key.
    2. Identify all the fields needed, organize data, group related fields,determined each table's primary key, include a common field, avoid data redundancy
    3. in the field name box, type the name for the field and then press the Tab key.
    accept the default text data type, or click the arrow and select a different data type for the field. Press the tab key. enter an optional desciption for the field, and use the field properties pane to type or select other other field properties

    ReplyDelete
  9. AyahDecember 1, 2009 at 12:18 PM

    Q1.) Although Access does not require a table to have a primary key, there are some advantages that a primary key can offer. The advantages that the primary key offers are: 1.)A primary key uniquley identifies each record in a table 2.)Access does not allow copying values in the primary key feild. Preventing duplicate values ensures the uniqueness of the primary key field. 3.)Access saves records on the disk as you enter them. 4.)When a primary key has been specified, Access forces you to enter a value for the primary key field in every record in the table. 5.) Acces responds faster to your requests for specific records based ib the primary key.

    Q2.)The basic steps you should use when creating a new database are: 1.)To organize each piece of data into its smallest useful part 2.)Group related fields into tables 3.)Determine each table's primary key 4.)Include a common field in related tables 5.)Avoid data redundancy 6.)Determine the properties of each field.

    Q3.) You define a field in a Design view by in the Field Name box,type the name for the field, and then press the Tab key. Then accept the default Text data type, or click the arrow and then select a different data type for the feild. Then press the Tab key. Next, enter an optional description for the field, if necessary. Lastly, use the Field Properties pane to tupe or select other field properties.

    ReplyDelete
  10. Amira Affaneh <333December 1, 2009 at 12:20 PM

    1. The advantage of including a primary key in a table is that the primary key uniquely identifies each record in a table. A primary is not madatory, but it's great if you have one. When a primary key has been specified, Access forces you enter a value for the primary key feild in every record in the table.
    2. The basic steps you should use when creating a new database are identify all the fields needed to produce the required information, organize each peice of data into its smallest useful part, group related fields into tables, determine table's primary, incude a common field in related tables,and avoid data reduncy, determine the properties of each field.
    3. In the feild Name box,type the name for the field, and then press the Tab key. Enter an optional description for the field, if necessary. Use the field properties pane to type or select other field properties, as appropies.

    ReplyDelete
  11. ManaLDecember 1, 2009 at 12:23 PM

    A primary key identifies each record in a table and you cannot get 2 primary keys in a table when a primary key is specified you have to add a value in the feild if you dont then it will have a null value when you have a primary key it puts the values in order a primary key makes your quieres and your requests faster.
    The baisic steps you should use when creating a new data base are identify all the feilds needed to produce the required information, organize each part of database into its smallest useful part, group related feilds in a table, determine the primary key, include a common key in related tables, and avoid redudancy.
    You define a key in design view by typing the feild name then press tab exept the default text data typeor any different format you want then press tab if you want you can add a discription use the feild property pane to select other feild properties

    ReplyDelete
  12. Reem NazzalDecember 1, 2009 at 12:23 PM

    The advantages of including a primary key in a table is that it uniquely identifies each record in a table. Access does not allow duplicate values in the primary key field. When a pirmary key has been specified, access forces you to enter a value for the primary key field in every record in the table.That is called entity intergrity. Access stores records in disk as you enter them. It also responds faster to your request for specific records based on the primary key. The basic steps you should use when creating a new database are identify all the fields needed to produce the required information, organize each piece of data into smallest useful part, group related fields into tables, determine each tables primary key, include a common field in related tables, and avoid data redundancy. Ti define a field in a design view is in the field name box, type the name for the field, and press the tab key, accept the default text data type or click the arrow and select a different data type for the field. Press the tab key, enter an optional description for the field, if necessary, then use the fields properties pane to type or select other fields properties, as appropriate.

    ReplyDelete
  13. w.majidDecember 1, 2009 at 12:28 PM

    1.the advantage is that the primary key identifies each record in each table.a primary key is not mandatory but good to have one.when a primary key is used access responds faster.

    2.when creating a database the basic steps are that you should use are identify all the fields needed for requered table's primary key, include a common field, avoid data redundancy.
    3. in the field name box, type the name for the field and then press the Tab key.
    accept the default text data type, or click the arrow and select a different data type for the field. Press the tab key. enter an optional desciption for the field, and use the field properties pane to type or select other other field propertiesinformation,organize each peice of data into its smallest part, group related field into tables,determi

    ReplyDelete
  14. Fatemeh MirbagheriDecember 1, 2009 at 12:37 PM

    1. The advantages of including a primary key in a table is that it identifies each record in a table, it does not allow duplicate values in the primary key field, Access forces you to enter a value for the primary key field in every record in the table called the entity integrity, Access stores records on disks as they are entered, and there is faster responce to your requests for specific records based on the primary key.

    2. The basic steps you should use in creating a new database is: -identifying all the fields
    needed to produce the
    required information.
    data into its smallest
    -organizing each piece
    of data into its
    smallest useful part.
    - Grouping related
    fields into tables.
    - Determining each
    table's primary key.
    - Including a common
    field in related
    tables.
    - Avoiding data
    redundancy.

    3. You define a field in design view by:
    1) In the field box, type the name for
    the field, and then press the tab key.
    2) Accept the default text data type, or
    click the arrow and select a differnt
    data type for the field. Press the tab
    key.
    3) Enter an optional description for the
    field, if needed.
    4) Use the field prpoerties pane to type or
    select other field properties, as
    appropriate.

    ReplyDelete

Subscribe to: Post Comments (Atom)