Unit 2 - Components and Naming Conventions (Access Database)

Question 1

What are the components/objects of an Access Database?

Answer 1

Tables
Queries
Forms
Reports
Macros

Question 2

Briefly explain what the Tables component is used for

Answer 2

(tbl+name)

Contains data about ‘things’ that are organised into records and fields

Question 3

Briefly explain what the Queries component is used for

Answer 3

(qry+name)

Are used to select records using specific criteria

Question 4

Briefly explain what the Forms component is used for

Answer 4

(frm+name)

Are used as a user interface for entering and modifying data

Question 5

Briefly explain what the Reports component is used for

Answer 5

(rpt+name)

Are used to display data and are suitable for printing

Question 6

Briefly explain what the Macros element are used for

Answer 6

A single instruction that expands automatically into a set of instructions to perform a particular task

Question 7

Why are naming conventions used?

Answer 7

To provide a common set of rules to apply to the naming of electronic records

Question 8

What are the two main rules to follow when naming the components of your database

Answer 8

1. No spaces

2. Prefixes