Microsoft Access 2007- Review Exam For 3rd Year Mcs Students

50 Questions | Total Attempts: 270

SettingsSettingsSettings
Please wait...
Microsoft Access Quizzes & Trivia

To my 3rd year Students


Questions and Answers
  • 1. 
    It has rows and columns. It has rows and columns.
    • A. 

      Field

    • B. 

      Table

    • C. 

      Record

    • D. 

      None of the above

  • 2. 
    It is a category or type of information, e.g. , First Name, Last Name, Address, etc.
    • A. 

      Record

    • B. 

      Table

    • C. 

      Field

    • D. 

      None of the above

  • 3. 
    It is a set of fields for a specific item.
    • A. 

      Record

    • B. 

      Field

    • C. 

      Table

    • D. 

      None of the above

  • 4. 
    It allows you to view your data in a spreadsheet format. You can enter data in the same manner as a spreadsheet program like MS Excel 2007.
    • A. 

      Design View

    • B. 

      Datasheet view

    • C. 

      Both A and B

    • D. 

      Table in datasheet view

  • 5. 
    It is an empty table with a pre-defined but customizable format that you can immediately start using.
    • A. 

      Contacts

    • B. 

      Tasks

    • C. 

      Events

    • D. 

      Table template

  • 6. 
    A table for managing business contact information. It has fields such as Company, Last Name, First    Name, Job title, etc.
    • A. 

      Contacts

    • B. 

      Tasks

    • C. 

      Issues

    • D. 

      Events

  • 7. 
    A table for tracking tasks. It has fields such as Title, Priority, Status, etc.
    • A. 

      Contacts

    • B. 

      Tasks

    • C. 

      Issues

    • D. 

      Events

  • 8. 
    Table for tracking issues. It includes fields such as Title, Opened data, statue, etc.
    • A. 

      Contacts

    • B. 

      Tasks

    • C. 

      Issues

    • D. 

      Events

  • 9. 
    A table for managing events. It has a rich-text Memo field and a field for attachments.
    • A. 

      Contacts

    • B. 

      Tasks

    • C. 

      Issues

    • D. 

      Events

  • 10. 
    A table for managing business assets. It has fields such as Description, Category, Condition, etc.     which are crucial for assets management.
    • A. 

      Asset

    • B. 

      Events

    • C. 

      Tasks

    • D. 

      Contacts

  • 11. 
    It is advisable that the name of the table be related to its contents.
    • A. 

      Navigation Pane

    • B. 

      Rename

    • C. 

      Naming a table

    • D. 

      Enter

  • 12. 
    The default table name is called ______.
    • A. 

      Naming a table

    • B. 

      Table

    • C. 

      Both A and B

    • D. 

      None of the above

  • 13. 
    . for entries that can contain alphanumeric character and special symbols.
    • A. 

      Memo

    • B. 

      Date/ time

    • C. 

      Number

    • D. 

      Text

  • 14. 
    This data type can also contain a combination of text and numbers.
    • A. 

      Memo

    • B. 

      Date/ time

    • C. 

      Number

    • D. 

      Text

  • 15. 
    This is used for numbers that will be used for calculations.
    • A. 

      Memo

    • B. 

      Date/ time

    • C. 

      Number

    • D. 

      Text

  • 16. 
    Stores date and time values from the year 100 through 9999. a date field automatically assigns a      fields size.
    • A. 

      Memo

    • B. 

      Date/ time

    • C. 

      Number

    • D. 

      Text

  • 17. 
    For money, such as price or cost. Same as a number, but with decimal places and the currency      symbols.
    • A. 

      Currency

    • B. 

      Yes/ No

    • C. 

      AutoNumber

    • D. 

      OLE object

  • 18. 
    For automatic entry of non-repeating sequential numbers that uniquely identify a record in a table.
    • A. 

      Currency

    • B. 

      Yes/ No

    • C. 

      AutoNumber

    • D. 

      OLE object

  • 19. 
    For entries that must be answered by Yes or No, true or False, or on or off.
    • A. 

      Currency

    • B. 

      Yes/ No

    • C. 

      AutoNumber

    • D. 

      OLE object

  • 20. 
    For storing any object that can be linked or embedded in a table.
    • A. 

      Currency

    • B. 

      Yes/ No

    • C. 

      AutoNumber

    • D. 

      OLE object

  • 21. 
    For entries that contain a path to an object, file, website, or hard drive locations on your computer.
    • A. 

      Hyperlink

    • B. 

      Lookup wizard

    • C. 

      Attachment

    • D. 

      OLE object

  • 22. 
    Same as with OLE object. It can contain any supported type of file, including pictures, charts, and so      on.
    • A. 

      Hyperlink

    • B. 

      Lookup wizard

    • C. 

      Attachment

    • D. 

      OLE object

  • 23. 
    Creates a drop-down list from a specified table or from a list of entries you create.
    • A. 

      Hyperlink

    • B. 

      Lookup wizard

    • C. 

      Attachment

    • D. 

      OLE object

  • 24. 
    Stores up to 255 characters.
    • A. 

      Memo

    • B. 

      Number

    • C. 

      Date/ time

    • D. 

      Text

  • 25. 
    Stores up to 65,535 characters if you enter them manually and 2GB of data if you enter them from the program.
    • A. 

      Memo

    • B. 

      Number

    • C. 

      Date/ time

    • D. 

      Text

  • 26. 
    You can set field size with a maximum of 16 bytes of information.
    • A. 

      Memo

    • B. 

      Number

    • C. 

      Date/ time

    • D. 

      Text

  • 27. 
    Up to four decimal places. Used to store financial data.
    • A. 

      Yes/ No

    • B. 

      AutoNumber

    • C. 

      OLE object

    • D. 

      Currency

  • 28. 
    Limited to 2 GB. It can make your program run slowly.
    • A. 

      Yes/ No

    • B. 

      AutoNumber

    • C. 

      OLE object

    • D. 

      Currency

  • 29. 
    This is new to Access 2007 and works only with the .accdlb file format.
    • A. 

      Lookup Wizard

    • B. 

      Attachment

    • C. 

      Hyperlink

    • D. 

      Yes/ No

  • 30. 
    A special usage of the text data type.
    • A. 

      Yes/ No

    • B. 

      AutoNumber

    • C. 

      OLE object

    • D. 

      Lookup wizard

  • 31. 
    The number of characters you can encode in the field. This is applicable in fields with text, Number,      or AutoNumber data types.
    • A. 

      Field Size

    • B. 

      Input Mask

    • C. 

      Format

    • D. 

      Caption

  • 32. 
    To display the data using a predefined format or to enter a custom format according to your needs.
    • A. 

      Field Size

    • B. 

      Input Mask

    • C. 

      Format

    • D. 

      Caption

  • 33. 
    Provides a pattern for all data to be entered in this field.
    • A. 

      Field Size

    • B. 

      Input Mask

    • C. 

      Format

    • D. 

      Caption

  • 34. 
    The text label for the field when used in the form.
    • A. 

      Field Size

    • B. 

      Input Mask

    • C. 

      Format

    • D. 

      Caption

  • 35. 
    Specifies a value that is automatically entered into the field.
    • A. 

      Caption

    • B. 

      Default Value

    • C. 

      Field size

    • D. 

      Input Mask

  • 36. 
    Alignment of text in the control such as left, center, right, or distribute.
    • A. 

      Text align

    • B. 

      Lookup

    • C. 

      Smart tags

    • D. 

      Indexed

  • 37. 
    Offers choices for displaying fields in forms. You can choose a text box, combo, or a list.
    • A. 

      Text align

    • B. 

      Smart tags

    • C. 

      Lookup

    • D. 

      Indexed

  • 38. 
    The view allows you to enter and edit records in a table is:
    • A. 

      Datasheet View

    • B. 

      Creating List

    • C. 

      Entering Data

    • D. 

      None of the above

  • 39. 
    To enter records. Click the ____ then type the data.
    • A. 

      Form

    • B. 

      Cell

    • C. 

      Field

    • D. 

      Column

  • 40. 
    In Customizing Rows and Columns, You can customize how you view data in your table. There      may be cases where you might need to do any of the following, except:
    • A. 

      Add another field to your table

    • B. 

      Resize the rows and columns

    • C. 

      Hide/unhide, rename format

    • D. 

      Add Picture

  • 41. 
    In formatting a table for display, To modify the appearance of your datasheet, use the formatting      option which found in the:
    • A. 

      Ribbon

    • B. 

      Home Tab

    • C. 

      Insert Tab

    • D. 

      None of the above

  • 42. 
    In Inserting column/s or field/s in an Access table is similar to using in what software:
    • A. 

      Microsoft Word - Word Processing

    • B. 

      Adobe Photoshop- Desktop Publishing

    • C. 

      Microsoft Excel- Spreadsheet

    • D. 

      Facebook

  • 43. 
    To rename a column, click:
    • A. 

      Double-click the column

    • B. 

      Right click>choose rename

    • C. 

      Select any cell>Datasheet tab>choose rename

    • D. 

      All of the above

  • 44. 
    The default row height is:
    • A. 

      11-75

    • B. 

      14-25

    • C. 

      14-26

    • D. 

      None of the above

  • 45. 
    To hide columns, select:
    • A. 

      Select the column>home tab>under Records group, click More>choose Hide Columns

    • B. 

      Right Click the column>click Hide Column

    • C. 

      Double Click the column, then delete

    • D. 

      Both A and B

  • 46. 
    To close single file, press:
    • A. 

      Ctrl + W

    • B. 

      Ctrl + A

    • C. 

      Alt + F4

    • D. 

      Ctrl + U

  • 47. 
    It is a relationship that can be established when one record in a table has only one matching      record in another table.
    • A. 

      Relationship

    • B. 

      One-to-One Relationship

    • C. 

      One-to-many Relationship

    • D. 

      Many-to-many Relationship

  • 48. 
    It is an association between two tables in which one record in either table can relate to many      records in other table.
    • A. 

      Relationship

    • B. 

      One-to-One Relationship

    • C. 

      One-to-many Relationship

    • D. 

      Many-to-many Relationship

  • 49. 
    It is the most common type of relationship, it can established when one record from a table is      related to several matching records in other tables.
    • A. 

      Relationship

    • B. 

      One-to-One Relationship

    • C. 

      One-to-many Relationship

    • D. 

      Many-to-many Relationship Many-to-many Relationship Many-to-many Relationship Many-to-many Relationship Many-to-many Relationship Many-to-many Relationship Many-to-many Relationship

  • 50. 
     It is one or more fields whose value or values uniquely identify each record in a table.
    • A. 

      Ctrl key

    • B. 

      Primary key

    • C. 

      One to one

    • D. 

      Relationship