In MS Access, which object gives a user-friendly screen for entering and viewing one record at a time?
- A.Table
- B.Query
- C.Form
- D.Report
Correct answer
Explanation
The correct answer is C, form. A form is the object designed for data entry and viewing: it presents the fields of a single record in a neat layout with labels, boxes, drop-down lists and buttons, so the person entering data never has to work directly in the raw grid of a table. Option A, a table, is where the data is actually stored, as records in rows and fields in columns, and it can be edited in Datasheet View, but it is not a friendly entry screen. Option B, a query, is the object that asks a question of the data, selecting, sorting, filtering or changing records according to the conditions set in it. Option D, a report, is the object meant for printing and summarising, with grouping, totals and headers, and it is not used for entering data. The six Access objects to remember are tables, queries, forms, reports, macros and modules.
Read the full article: MS Access, Outlook and Office Tools: Exam Notes
Practice Questions
View allWhich program of the Microsoft Office suite is a relational database management system?
- A.MS Excel
- B.MS Access
- C.MS Publisher
- D.MS OneNote
Show answer
Access stores data in separate tables that are joined to one another through keys, which is what makes it relational, and it provides tables, queries, forms, reports, macros and modules to work with that data.
Read the full explanation →What is the file extension of a database created in MS Access 2007 and later versions?
- A..mdb
- B..accdb
- C..adb
- D..dbf
Show answer
From Access 2007 onwards, the default database format changed and files are saved with the extension.accdb, which stands for Access database and supports features such as multivalued fields and attachment data types.
Read the full explanation →In MS Access, the field that uniquely identifies each record in a table is called the ______.
- A.Foreign key
- B.Primary key
- C.Index field
- D.Lookup field
Show answer
A primary key is a field, or a combination of fields, whose value is different in every record and never left empty, so it can be used to pick out one record with certainty; an AutoNumber field is the usual choice because Access fills it in by itself.
Read the full explanation →In MS Outlook, which field is used to send a copy of a message without the other recipients seeing that address?
- A.To
- B.Cc
- C.Bcc
- D.Reply To
Show answer
Bcc stands for blind carbon copy. Everyone listed in Bcc receives the message, but their addresses are hidden from the people in the To and Cc fields and from one another, which is why it is used for circulars sent to a long list.
Read the full explanation →MS Outlook keeps its mail, calendar and contacts on the local computer in a file with which extension?
- A..pst
- B..ppt
- C..pdf
- D..pub
Show answer
The letters stand for personal storage table, and this single file holds the messages, calendar entries, contacts, tasks and notes of an Outlook account on the computer, which is why backing up the.pst file backs up the whole mailbox.
Read the full explanation →