Each table appears as a spreadsheet grid called
- A.Record
- B.Datasheet
- C.Queries
- D.Tables
Show answer
Correct answer: B. Datasheet
Explanation
The correct answer is B, Datasheet. In a database such as Microsoft Access, the view that shows a table as rows and columns, looking like a spreadsheet grid, is called Datasheet view. Each row of that grid is one record and each column is one field, and the names along the top come from the field names set in Design view. Datasheet view lets you type data straight in, sort it, filter it and widen columns, while Design view is where the data type, field size and primary key are fixed. Queries and forms can also be opened in Datasheet view, so the name belongs to the display format, not to one object. Option A is wrong because a record is a single row of the grid, one complete entry, not the grid itself. Option C is wrong because a query is a saved question that pulls out selected rows; it is a database object. Option D is wrong because 'Tables' names the objects being displayed, while the question asks what the grid-like view is called. Exam tip: Access tables have two main views — Datasheet for data, Design for structure.