The Microsoft Access Test Has the Answer P4

This article presents Microsoft Access Test Has the Answer P4 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 P4

• Question 1. When designing a query, want to bind a control to a certain field, we select the property:
  • Control Source
  • Record Source
  • Bound column
  • Not possible
• Question 2. We can edit the data of a field in a table (Table) from:
  • Report
  • Crosstab Query
  • Append Query
  • All is wrong
• Question 3. Control Label on the form we select the font is Times New Roman, to type Vietnamese, in VietKey or UniKey, we have to select the code table:
  • VNI - WIN
  • Unicode
  • Vietware - F
  • Optional
• Sentence 4. The Rowsource Type property of Combo Box can be selected as:
  • Table/Query or Field List
  • Table/Query or Value List
  • Field List or Value List
  • All answers above
• Question 5. How many components in a Form have:
  • 2
  • 5
  • 7
  • More
• Question 6. To group in the report we use the command: View/Sorting and Grouping and then select the field to be grouped. So to group the first two characters of a Text field, what value must be set for the attribute pair?
  • Group Header and Group Interval
  • Group Footer and Group On
  • Group On and Group Interval
  • Group Interval and Keep Together
• Question 7. In the following controls, which control can be constrained (bound):
  • Text Box, Tab Control, Option Group
  • Label, Line, Rectangle
  • Check Box, Togle Button, Image
  • Option Button, Option Group, Bound Object Frame.
• Question 8. Create the command button on the form to select it to add a new record and move the cursor to a specific control then we create that command by:
  • Macro mounting has two actions: GotoRecord, GotoControl.
  • Create a command button by Wizard
  • Attaching Macro has 2 actions: AddNewRecord, GotoControl.
  • Not possible
• Question 9. On the form to filter the data according to conditions of some schools that we use macros with the Apply Filter action, what attributes do we need:
  • Filter Name
  • Where Condition
  • Both Filter Name and Where Condition
  • Other properties
• Question 10. To save students' test results to the KETQUA table, in this table, we design the DIEMTHI field to store that test score. We can choose the data type for this field:
  • Standard
  • AutoNumber
  • Fix
  • Text