Microsoft Access Has a P2 Answer

This article examines Microsoft Access Has a P2 Answer. It presents the main facts, practical implications, and key points in a clearer, easier-to-follow format.

Understanding Microsoft Access Has a P2 Answer

• Question 1. The relationship between two tables in Access database may be.
  • One-to-many relations, one-to-one relations.
  • One-to-many relationship
  • Multiple relations - one on column A
  • Relationship one - one A
• Question 2. The data of a field is of type AutoNumber.
  • Optional users
  • Always increase
  • Always reduced
  • Access will automatically increment or randomize when a new record is created.
• Question 3. When a T table is opened, the record order will prioritize.
  • The field is selected in the Order by attribute of Table T.

  • The field selected in the Filter property of Table T.

  • 1. Do not arrange in any order
  • The field is selected as the primary key of Table T.
• Question 4. Knowing that DIEM field has Number type, only values from 0 to 10, please select the Validation Rule attribute of DIEM field.

  • > 0 or <= 10

  • > = 0 and <= 10

  • > [diem]> 0 or [diem] <= 10

  • 0 <= [diem] <= 10

• Sentence 5. The Control Source property of a Form will specify.
  • 1. The fields that the Form will bind to
  • 1. The table contains the data that the Form will bind to.

  • The fields that the Form will bind to and the data table that the Form will bind to.

  • 1. Not specified anything
• Question 6. The maximum size of a Table is.
  • 1. 1 Megabyte
  • 1. 1 KB
  • 1 Giga byte
  • Unlimited
• Question 7. In the 'Nhanvien' form to create input Textbox for HOTEN field, we must set the properties.
  • 1. Name = HOTEN

  • Set any Name and Control Source

  • ControlSource = HOTEN

  • Name = HOTEN and Control Source = HOTEN

• Question 8. Choose a false statement
  • A standalone macro cannot be attached to any object.
  • In Macro, we cannot call another macro
  • 1. In a macro can have actions with conditions.
  • 1. Individual macros can be saved under the same generic Macro group name.
• Sentence 9. SubReport
  • A small report is always at the bottom of the screen.
  • A small Report is embedded inside another Report.
  • A Report is activated as soon as another Report is activated.
  • A small Report is triggered by another Report.
• Question 10. Specify the date type input data in the form of dd/mm/yy, choose Format as.
  • Short Date
  • Medium Date
  • Long Date
  • General