Microsoft Access 2003- Working With Forms and Reports

30 Questions | Attempts: 150
Please wait...
Question 1 / 31
🏆 Rank #--
0 %
0/100
Score 0/100

1. This type of control can be bound to a Yes/No field. It can also added to an option group.

Submit
Please wait...
About This Quiz
Microsoft Access Quizzes & Trivia

MCS- Students

2.

What first name or nickname would you like us to use?

You may optionally provide this to label your report, leaderboard, or certificate.

2. What character must you place beside a field if it is used in an expression?

Submit

3. A bound text box displays records from an underlying table or query. it is used also to display the result of a computation.

Submit

4. It also bound and unbound to an underlying record source. It is used to provide users with a list of values, that can either be bound to a field in the table, or unbound which stores values not tied in with any of the tables.

Submit

5. It is one that linked to a table or query.

Submit

6. It is used to separate the pages on a form.

Submit

7. It is used to start a new screen on a form, a new page on a printed form, or a new page of  a report.

Submit

8. It performs an action or set of action when these button are clicked.

Submit

9. This type of control is very useful when viewing records based on two tables with a one-to-many-relationship.

Submit

10. It works like a combo box, but it displayed differently. Records are displayed one at a time.

Submit

11. It is used to toggle an option, on or off. It is usually bound to a Yes/No field in the table.

Submit

12. It is used on a form to provide descriptive text for text boxes, buttons, frames, titles, or instruction.

Submit

13. This often to decorate the form to make it look better and to make the records more readable.

Submit

14. It is used to provide a limited set of alternatives on a form. It includes values can use, which can be selected by just clicking on them.

Submit

15. These are simple graphic element that you can draw on a form to add as decoration.

Submit

16. This data type stores data and time values from the year 100 through 9999.

Submit

17. It is used to display images or pictures on a form or report.

Submit

18. They key uniquely identifies each record in a table.

Submit

19. It is a query that when run displays its own dialog box prompting you for information, such as criteria for  retrieving records or a value you want to insert in a field.

Submit

20. It is used to calculate and restructure data for easier analysis of your data. It calculates the sum, average, count, or type of total for data that is grouped by two types of information- one down the left side of the data sheet and another across the top.

Submit

21. This option allows you to build a new table by entering data directly into the datasheet.

Submit

22. Unlike text data type, this can store up to maximum of 65, 535 characters.

Submit

23. It is a database object to view, change, and analyze data in different ways.

Submit

24. These are element in an expression with values that do not change.

Submit

25. This data type allows alphanumeric characters and special symbols.

Submit

26. These are values such as number, character, or date, which access evaluates exactly as written. “Carl”, 256.80, and # 26-Dec-02# or ’26-dec-02’ are examples of literals values.

Submit

27. It is most common type of query. It retrieves records from one or more tables and then displays the results in the order you want.

Submit

28. It is a sign or symbol that specifies, operator, and values that produce a result.

Submit

29. These values in an expression that are identified by number signs (#) or sign (‘) quotation mark around the element.

Submit

30. It is a sign or a symbol that specifies the type of calculation to perform within an expression. There are mathematical, comparison. Logical and reference operators.

Submit
×
Saved
Thank you for your feedback!
View My Results
Cancel
  • All
    All (30)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
This type of control can be bound to a Yes/No field. It can also added...
What character must you place beside a field if it is used in an...
A bound text box displays records from an underlying table or query....
It also bound and unbound to an underlying record source. It is used...
It is one that linked to a table or query.
It is used to separate the pages on a form.
It is used to start a new screen on a form, a new page on a printed...
It performs an action or set of action when these button are clicked.
This type of control is very useful when viewing records based on two...
It works like a combo box, but it displayed differently. Records are...
It is used to toggle an option, on or off. It is usually bound to a...
It is used on a form to provide descriptive text for text boxes,...
This often to decorate the form to make it look better and to make the...
It is used to provide a limited set of alternatives on a form. It...
These are simple graphic element that you can draw on a form to add as...
This data type stores data and time values from the year 100 through...
It is used to display images or pictures on a form or report.
They key uniquely identifies each record in a table.
It is a query that ...
It is used to calculate and restructure data for easier ...
This option allows you to build a new table by entering data directly...
Unlike text data type, this can store up to maximum of 65, 535...
It is a database ...
These are element in an expression with values that do not change.
This data type allows alphanumeric characters and special symbols.
These are values such as number, character, or date, which ...
It is most common type of query. It retrieves records from ...
It is a sign or symbol ...
These values in an expression that are identified by number ...
It is a sign or a symbol that specifies the type of ...
play-Mute sad happy unanswered_answer up-hover down-hover success oval cancel Check box square blue
Alert!