Datasheet view is a window that displays data from a table or query in row and column format where you can edit fields, add, delete data as well as search for data.

A subform is a form contained within another form or a report. Th is feature is useful to represent one-to-many relationship between tables. In the form we can show the data of the Master table and at the same time in a second form we can show related data from the transaction table.

Filter is the process of hiding all unnecessary records or displays only the records that satisfy the criteria specified.

A Field that stores a list from an existing table or query or a fixed set of values that is looked up.

The three key components of relational database design are: entities, attributes and relationship.