Page 82 - Computer Class 07

8 Tables 8 Queries

8 Forms 8 Reports

Together, these objects allow you to enter, store, analyse and compile your data.

Here is a summary of the major objects in an Access database.
Table

Table is an object that is used to define and store data. When you create a new table,
Access asks you to define fields which is also known as column headings.
8 Each field must have a unique name and data type.

8 Tables contain fields or columns that store different kinds of data, such as a name

or an address and records or rows that collect all the information about a
particular instance of the subject, such as all the information about a customer or
employee etc.

8 You can define a primary key, one or more fields that have a unique value for
each record, and one or more indexes on each table to help retrieve your data

more quickly.
Query

An object that provides a custom view of data from one or more tables. Queries are a

way of searching for and compiling data from one or more tables.
8 Running a query is like asking a detailed question of your database.

8 When you build a query in Access, you are defining specific search conditions to

find exactly the data you want.
8 In Access, you can use the graphical query by example facility or you can write
Structured Query Language (SQL) statements to create your queries.

8 You can define queries to select, update, insert or delete data.

8 You can also define queries that create new tables from data in one or more
existing tables.

Form

Form is an object in a desktop database designed primarily for data input or display
or for control of application execution. You use forms to customise the presentation of
data that your application extracts from queries or tables.

8 Forms are used for entering, modifying and viewing records.

8 The reason forms are used so often is that they are an easy way to guide people

Computer-7 82 Computer-1