The Microsoft Access Test Has the Answer P5

This article presents Microsoft Access Test Has the Answer P5 in a clear, structured format. It helps readers review key concepts, test their understanding, and learn from the material.

Understanding Microsoft Access Test Has the Answer P5

• Question 1. When using the Form Wizard tool to create a Form, how many forms of Form can be selected?
  • 2
  • 3
  • 4
  • More
• Question 2. When creating a Form, what components may not need to be used?
  • Form Header/Footer
  • Page Header/Footer
  • Detail
  • Both sentences (a), (b) are correct
• Question 3. While designing Form/Report, we will select the Textbox object (text box) to put in Form/Report instead of selecting Label object) when we want:
  • Display image
  • Assign the default value
  • Change the Font
  • Show a string
• Question 4. When designing a Report, if you want all Text box objects to be aligned in horizontal rows, after selecting those text boxes, we do:
  • Go to Fortmat command, select Align/left
  • Enter the Format command, select Align/top.
  • Go to the Edit command, select Align/horizontal.
  • Enter the View command, select Align/Bottom.
• Question 5. In Access 2000, we can execute the following types of queries:
  • Straight query
  • Horizontal query
  • Cross queries
  • All is wrong
• Question 6. Suppose there is a Report named "BaoCao", in this Report there is a textbox with attribute Name of SOLG, want to access this textbox, we choose:
  • [BaoCao]! [SOLG]
  • [BaoCao]! [SOLG]
  • [Reports]! [BaoCao]! [SOLG]
  • [Report]! [BaoCao]! [SOLG]
• Question 7. To move the cursor to a control and set the value of this control to 100, in the design window Macro we choose the following Action pairs:
  • GotoLast and SetmenuItem
  • GotoRecord and SetValue
  • GoToControl and SetValue
  • GoToControl and SetExpression
• Question 8. Please point out the wrong statements in the following statements:
  • In a macro we can call another macro
  • An independent macro cannot be attached to any object.
  • In a macro, actions can be accompanied by conditions.
  • In a macro, you can create different action groups.
• Question 9. We can use MS Access software to:
  • Management in the Web
  • Manage reports
  • File management
  • All is wrong
• Question 10. Suppose the database has 2 tables, each table has 4 fields, the relationship between these two tables can be:
  • One-to-many relationship
  • One-to-one relationship
  • Could not set up a relationship
  • A and B are correct