Page 102 - iPlus_Ver_2.0_class_7
P. 102
• Using Design Tab: You can add a logo and title to your
form by making use of the Logo and Title commands
present under the Header/Footer group in the Design
tab.
• Using Format Tab: You can change the font, size,
Logo
colour, and alignment of labels; add a background
image to the form; change the colour of the shapes;
etc using various commands present on the Format
tab.
Background
Image
i + QUERIES IN ACCESS
A query is the most important object provided by Access. It is just similar to a question and can
give you information that you might not be able to find by looking at the table directly. Using
a query, you can search for data from one or more tables by giving specific search conditions.
By using a query you are able to view the exact data that you want. You can then review, add,
change, or delete data from your database.
Access allows you to create or build a query and save it in the database so that you can run it
multiple times. The Query Design command, present under the Queries group on the Create
tab, is used to create a query.
Types of Queries
The different types of queries in Access are:
• Select Query: It retrieves data from one or more tables. It displays the record in a datasheet,
allowing users to group data and calculate sum, count, average, etc.
• Parameter Query: It is a type of select query that prompts you for the input before it runs. It
uses the input as the criteria that controls the result.
• Action Query: It creates a new table or alters your data by adding, deleting, updating, and
appending data from it.
100
iPlus (Ver. 2.0)-VII

