Access is part of the office suite and is used to build simple software. If you are new to Access, the multiple choice questions below will help you add more useful knowledge.
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 click on 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: