Microsoft Access 2003- Working With Forms And Reports

This type of control is very useful when viewing records based on two tables with a one-to-many-relationship.

This type of control can be bound to a Yes/No field. It can also added to an option group.

This often to decorate the form to make it look better and to make the records more readable.

These are simple graphic element that you can draw on a form to add as decoration.

It works like a combo box, but it displayed differently. Records are displayed one at a time.

It performs an action or set of action when these button are clicked.

It is used to toggle an option, on or off. It is usually bound to a Yes/No field in the table.

It is used to start a new screen on a form, a new page on a printed form, or a new page of  a report.

It is used to separate the pages on a form.

It is used to provide a limited set of alternatives on a form. It includes values can use, which can be selected by just clicking on them.

It is used to display images or pictures on a form or report.

It is used on a form to provide descriptive text for text boxes, buttons, frames, titles, or instruction.

It is one that linked to a table or query.

It also bound and unbound to an underlying record source. It is used to provide users with a list of values, that can either be bound to a field in the table, or unbound which stores values not tied in with any of the tables.

A bound text box displays records from an underlying table or query. it is used also to display the result of a computation.

This option allows you to build a new table by entering data directly into the datasheet.

They key uniquely identifies each record in a table.

This data type allows alphanumeric characters and special symbols.

Unlike text data type, this can store up to maximum of 65, 535 characters.

This data type stores data and time values from the year 100 through 9999.

It is a database object to view, change, and analyze data in different ways.

It is most common type of query. It retrieves records from one or more tables and then displays the results in the order you want.

It is a query that when run displays its own dialog box prompting you for information, such as criteria for  retrieving records or a value you want to insert in a field.

It is used to calculate and restructure data for easier analysis of your data. It calculates the sum, average, count, or type of total for data that is grouped by two types of information- one down the left side of the data sheet and another across the top.

It is a sign or symbol that specifies, operator, and values that produce a result.