MS-Access XP

1. MS-Access XP Lesson 5

2. Creating a Query with Expression Builder Eg. Consider the following table. Table Name: Overtime Fields & 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.

3. Creating a Query with Expression Builder • Select queries from objects bar • Double click on create a query in design view • Add overtime table to query design window • Select Emp No, OT Hours fields • Right click on next field and select build • Select tables and select overtime table • Double click on OT Hours field and add field to the expression • Type the remaining part of the expression [Overtime]![OT Hours]*30 and click ok • Rename Expr1(field name) as OT Amount • Save and Run the query

4. Creating a Form in Design View • Select forms from objects bar • Double click on create from in design view • Right click on form and add form header and footer if necessary • Right click on form area and select properties • Select format tab sheet and select option to back color (background color) • Add controls to form such as labels, text boxes and buttons • Click on save button and enter name and click ok

5. Adding Labels to Form • Open design view of a form • Select tool box from view menu • Click on label tool in a tool box • Drag and draw the label on a form • Type caption of a label • Select black squares on edge of a label and resize the label • Select hand mark of a cursor and move the label on a form

6. Changing Properties of a Label • Select label object • Right click on a label and select properties • Select format tab sheet • 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,

7. Adding Text Boxes to Form • Open design view of a form • Select tool box from view menu • Click on text box tool in a tool box • Drag and draw the text box on a form • Select black squares on edge of a text box and resize the label • Select hand mark of a cursor and move the text box on a form

8. Changing Properties of a Text Box • Select text box object • Right click on a text box and select properties • Select format tab sheet • 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, • Select data tab sheet • Select options to input mask, default value, validation rule and validation text

9. Assigning Control Source of a Text Box • View menu, Properties menu item • Select form from combo box • Select data tab sheet • Select appropriate table or query as record source of a form • Close properties dialog • Select text box object • Right click on a text box and select properties • Select data tab sheet • Select appropriate field as control source • Close properties dialog

10. Adding Command Button to a Form • Open design view of a form • Select tool box from view menu • Click on command button tool in a tool box • Drag and draw the command button on a form • Select category, action and click next • Select text or picture as caption of a button • Click next • Enter button name and click finish