MS-Access XP

Lesson 5

Creating a Query with Expression Builder

Eg. Consider the following table.Table Name: OvertimeFields & Data types: Emp No (Number), OT Hours (Number)

OT rate per hour for each employee is Rs. 30.

Create a query to select Emp No, OT Hours and finding OT Amount using expression builder.

Creating a Query with Expression Builder1. Select queries from objects bar2. Double click on create a query in design view3. Add overtime table to query design window4. Select Emp No, OT Hours fields5. Right click on next field and select build6. Select tables and select overtime table7. Double click on OT Hours field and add field to the expression8. Type the remaining part of the expression

[Overtime]![OT Hours]*30 and click ok9. Rename Expr1(field name) as OT Amount10. Save and Run the query

Creating a Form in Design View1. Select forms from objects bar2. Double click on create from in design view3. Right click on form and add form header and footer if necessary4. Right click on form area and select properties5. Select format tab sheet and select option to back color (background color)6. Add controls to form such as labels, text boxes and buttons7. Click on save button and enter name and click ok

Adding Labels to Form1. Open design view of a form2. Select tool box from view menu3. Click on label tool in a tool box4. Drag and draw the label on a form5. Type caption of a label6. Select black squares on edge of a label and resize the label7. Select hand mark of a cursor and move the label on a form

Changing Properties of a Label1. Select label object2. Right click on a label and select properties3. Select format tab sheet4. Select options to caption, back color (background color), border style, border color, border width, fore color

(font color), font name, font size, font weight (bold), font italic, font underline, text align,

Adding Text Boxes to Form1. Open design view of a form2. Select tool box from view menu3. Click on text box tool in a tool box4. Drag and draw the text box on a form5. Select black squares on edge of a text box and resize the label6. Select hand mark of a cursor and move the text box on a form

Changing Properties of a Text Box1. Select text box object2. Right click on a text box and select properties3. Select format tab sheet4. Select options to caption, back color (background color), border style, border color, border width, fore color (font color),

font name, font size, font weight (bold), font italic, font underline, text align, 5. Select data tab sheet6. Select options to input mask, default value, validation rule and validation text

Assigning Control Source of a Text Box1. View menu, Properties menu item2. Select form from combo box3. Select data tab sheet4. Select appropriate table or query as record source of a form5. Close properties dialog6. Select text box object7. Right click on a text box and select properties8. Select data tab sheet9. Select appropriate field as control source10. Close properties dialog

Adding Command Button to a Form

1. Open design view of a form2. Select tool box from view menu3. Click on command button tool in a tool box4. Drag and draw the command button on a form5. Select category, action and click next6. Select text or picture as caption of a button7. Click next8. Enter button name and click finish