Results 1 to 9 of 9
  1. #1
    catzjenn is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Apr 2013
    Posts
    5

    desperate for homework help in access

    1. Which object would you use to enter, delete, or modify data?
    Criteria
    Form
    Query
    Table

    2. Which object would you use to retrieve customers who live in Germany and the United States?
    Criteria
    Form
    Query
    Table

    3. To design a report you should do all of the following EXCEPT
    draw a paper design of the report.
    identify all sources of data, fields and groups.
    input the data.
    select a reporting tool.

    4. Filters are used to do all of the following EXCEPT
    a filter can be removed by selecting Remove Filter from the Sort & Filter group.
    all records in a table will be displayed if all of the filters are removed.
    filter effects are cumulative.
    it does not matter whether you apply a filter or a sort first.

    5. A Report section that is used to summarize grouped field data is
    detail.
    group header.
    group footer.
    report footer.

    6. A field that uniquely identifies each record in a table is a
    link.
    relationship.
    primary key.
    foreign key.

    7. Which of the following should be considered when designing a database?
    How calculated fields are used
    Store data in its smallest parts
    The relationship between attribute keys
    The relationships between records

    8. All of the following apply to the relationships image found below EXCEPT
    a one-to-many relationship is found between the Suppliers table and the Products table.
    a relationship exists between the two primary keys of the Suppliers table and the Products table.
    one table is not joined to the two other tables.
    the primary key for the Categories table is CategoryID.

    9. All of the following summarize characteristics of a PivotTable EXCEPT
    can display information that is typically found in Datasheet totals.
    can only be created from a table.
    data is organized and summarized in an easy-to-read view.
    is created by dragging fields from a field list into appropriate drop zones.

    10. Which of the following does NOT describe a caption property?
    A label can substitute for a field name in Datasheet View.
    The caption appears in Datasheet View, Form, and Report.
    The label allows spaces between words.
    The label can be used in place of a field name in an expression.


    11. Which of the following does NOT describe the following one-to-one relationship?
    The tables must have exactly the same fields.
    The Employees and NewEmployees tables use the same primary key.
    More tables can be joined to either table.
    It may be used for security reasons to protect data availability.



    12. Which form type displays records in a tabular format similar to a Datasheet view but has more editing options such as adding graphics?
    Datasheet Form
    Multiple Items Form
    Split Form
    Subform

    13. Clicking on the form tool will open a(n)
    existing form.



    new form in design view.

    new form in layout view.

    wizard to design a form.

    14. Which of the following describes a poor design consideration for a form?
    Arrange controls closely together or in a sequence that is easy to read by the user.
    Each form should have a different theme.
    Make labels descriptive and clear.
    Right-align labels followed by a colon and left-align bound controls.

    15. Which of the following expressions is NOT correct?
    Cost: [Price] * [Qty]
    DiscountAmt = [Price] * [Qty] * [Discount]
    PrPerSqFt: [SalePr] / [SqFt]
    Sales: [GP] * [Qty]

    16. Which term best describes demographics?
    It is a bar code on a card that contains information about you.
    It defines population into segmented groups such as age, income, gender, and race.
    It is the quantity of merchandise a store will purchase.
    It is tracking customer purchases.

    17. Which of the following statements best describes data mining?
    It is the determining of future volume of sales.
    It is the predicting of future customer buying behavior.
    It is identifying patterns or relationships through a process of analyzing large quantities of data.
    It is tracking customer purchasing behavior.

    18. The Switchboard Manager is an Access utility that is used
    by all database users.
    to create and manage the menu items for a switchboard.
    to make certain objects unavailable to some users and available to others.
    to manage and optimize the database.

    19. An encrypted file is
    created by scrambling the content.
    protected by a password.
    saved with a specific file extension.
    unreadable if it is opened through a tampering tool or another program.

    20. All of the following are true when a user creates their own self-signed digital signature EXCEPT
    a time stamp is not required to go through a commercial service or local server for processing.
    a time stamp will prove when the file was last used.
    it is created through another software application.
    it will prove that the creator owns the database.

    21. To examine the efficiency and performance of an Access database, you should
    migrate the database out of Access and into a larger DBMS.
    move the database to its own dedicated server.
    redesign your database applying 3NF principles.
    use the Performance Analyzer and Table Analyzer to optimize the performance of the database.

    22. Which of the following is NOT true of a ship date field?
    A ship date is considered a constant.
    A ship date would be defined as a date/time field.
    A ship date would be defined as a calculated field.
    Date arithmetic can be applied to a ship date field.


  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    What good would it do you if we do your homework for you?

  3. #3
    catzjenn is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Apr 2013
    Posts
    5
    I would like to know that I have the correct answers I have already tried to answer each question.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You did not indicate your answers in your post.

  5. #5
    catzjenn is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Apr 2013
    Posts
    5
    1. Which object would you use to enter, delete, or modify data?
    Criteria
    Form
    Query
    Table

    2. Which object would you use to retrieve customers who live in Germany and the United States?
    Criteria
    Form
    Query
    Table

    3. To design a report you should do all of the following EXCEPT
    draw a paper design of the report.
    identify all sources of data, fields and groups.
    input the data.
    select a reporting tool.

    4. Filters are used to do all of the following EXCEPT
    a filter can be removed by selecting Remove Filter from the Sort & Filter group.
    all records in a table will be displayed if all of the filters are removed.
    filter effects are cumulative.
    it does not matter whether you apply a filter or a sort first.

    5. A Report section that is used to summarize grouped field data is
    detail.
    group header.
    group footer.
    report footer.

    6. A field that uniquely identifies each record in a table is a
    link.
    relationship.
    primary key.
    foreign key.

    7. Which of the following should be considered when designing a database?
    How calculated fields are used
    Store data in its smallest parts
    The relationship between attribute keys
    The relationships between records

    8. All of the following apply to the relationships image found below EXCEPT

    a one-to-many relationship is found between the Suppliers table and the Products table.
    a relationship exists between the two primary keys of the Suppliers table and the Products table.
    one table is not joined to the two other tables.
    the primary key for the Categories table is CategoryID.

    9. All of the following summarize characteristics of a PivotTable EXCEPT
    can display information that is typically found in Datasheet totals.
    can only be created from a table.
    data is organized and summarized in an easy-to-read view.
    is created by dragging fields from a field list into appropriate drop zones.

    10. Which of the following does NOT describe a caption property?
    A label can substitute for a field name in Datasheet View.
    The caption appears in Datasheet View, Form, and Report.
    The label allows spaces between words.
    The label can be used in place of a field name in an expression.


    11. Which of the following does NOT describe the following one-to-one relationship?

    The tables must have exactly the same fields.
    The Employees and NewEmployees tables use the same primary key.
    More tables can be joined to either table.
    It may be used for security reasons to protect data availability.



    12. Which form type displays records in a tabular format similar to a Datasheet view but has more editing options such as adding graphics?
    Datasheet Form
    Multiple Items Form
    Split Form
    Subform

    13. Clicking on the form tool will open a(n)
    existing form.

    new form in design view.

    new form in layout view.

    wizard to design a form.

    14. Which of the following describes a poor design consideration for a form?
    Arrange controls closely together or in a sequence that is easy to read by the user.
    Each form should have a different theme.
    Make labels descriptive and clear.
    Right-align labels followed by a colon and left-align bound controls.

    15. Which of the following expressions is NOT correct?
    Cost: [Price] * [Qty]
    DiscountAmt = [Price] * [Qty] * [Discount]
    PrPerSqFt: [SalePr] / [SqFt]
    Sales: [GP] * [Qty]

    16. Which term best describes demographics?
    It is a bar code on a card that contains information about you.
    It defines population into segmented groups such as age, income, gender, and race.
    It is the quantity of merchandise a store will purchase.
    It is tracking customer purchases.

    17. Which of the following statements best describes data mining?
    It is the determining of future volume of sales.
    It is the predicting of future customer buying behavior.
    It is identifying patterns or relationships through a process of analyzing large quantities of data.
    It is tracking customer purchasing behavior.

    18. The Switchboard Manager is an Access utility that is used
    by all database users.
    to create and manage the menu items for a switchboard.
    to make certain objects unavailable to some users and available to others.
    to manage and optimize the database.

    19. An encrypted file is
    created by scrambling the content.
    protected by a password.
    saved with a specific file extension.
    unreadable if it is opened through a tampering tool or another program.

    20. All of the following are true when a user creates their own self-signed digital signature EXCEPT
    a time stamp is not required to go through a commercial service or local server for processing.
    a time stamp will prove when the file was last used.
    it is created through another software application.
    it will prove that the creator owns the database.

    21. To examine the efficiency and performance of an Access database, you should
    migrate the database out of Access and into a larger DBMS.
    move the database to its own dedicated server.
    redesign your database applying 3NF principles.
    use the Performance Analyzer and Table Analyzer to optimize the performance of the database.

    22. Which of the following is NOT true of a ship date field?
    A ship date is considered a constant.
    A ship date would be defined as a date/time field.
    A ship date would be defined as a calculated field.
    Date arithmetic can be applied to a ship date field.


  6. #6
    catzjenn is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Apr 2013
    Posts
    5
    I have corrected this.

  7. #7
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    FYI, I deleted your duplicate threads. Please don't post the same question multiple times.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  8. #8
    catzjenn is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Apr 2013
    Posts
    5
    someone please help!!

  9. #9
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    As a starter, I'm going to suggest you revisit questions 1,3,5,7 & 12.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Help me with microsoft access homework!
    By claudia_lovez_u in forum Access
    Replies: 1
    Last Post: 06-30-2012, 05:46 AM
  2. Replies: 6
    Last Post: 02-24-2012, 01:57 PM
  3. In desperate need of help with my project
    By Jasmine0305 in forum Access
    Replies: 5
    Last Post: 02-11-2012, 05:06 PM
  4. Desperate Dan
    By Andyjones in forum Access
    Replies: 0
    Last Post: 01-27-2012, 07:09 PM
  5. Replies: 2
    Last Post: 10-08-2011, 10:38 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums