Free Essay

Lab Report

In: Science

Submitted By simmonsjo33
Words 10463
Pages 42
1 ) Create a new query in Query Design, including the Employee Info and Sales by Employee tables. Add the First Name and Last Name fields from the Employee Info table, and the Quarter and Actual Sales fields from the Sales by Employee table (in that order). Run the query. Ribbon 1. | Click the CREATE tab. | 2. | On the CREATE tab, in the Queries group, click Query Design. | 3. | In the Show Table dialog box, with the Employee Info table selected, click Add. | 4. | Click the Sales by Employee table and then click Add. | 5. | Click Close in the Show Table dialog box. | 6. | In the query design window, in the Employee Info table, double-click the First Name field. | 7. | In the query design window, in the Employee Info table, double-click the Last Name field. | 8. | In the query design window, in the Sales by Employee table, double-click the Quarter field. | 9. | In the query design window, in the Sales by Employee table, double-click the Actual Sales field. | 10. | On the DESIGN tab, in the Results group, click Run. | | Keyboard 1. | Press ALT (or F10, or F6 two times), C, and then QD. | 2. | In the Show Table dialog box, with Employee Info selected press ALT+A (or ENTER or TAB to select the Add button, and then press ENTER (or A or SPACEBAR)). | 3. | Press S (or use ARROW keys) to select the Sales by Employee table, and then press ALT+A (or ENTER or TAB to select the Add button, and then press ENTER (or A or SPACEBAR)). | 4. | Press ESC (or ALT+F4 or ALT+C or TAB to select Close, and then press ENTER (or C or SPACEBAR)). Alternatively, | 5. | In the query design window, in the Employee Info table, click the First Name field, and then press ENTER. | 6. | In the query design window, in the Employee Info table, click the Last Name field, and then press ENTER. | 7. | In the query design window, in the Sales by Employee table, click the Quarter field, and then press ENTER. | 8. | In the query design window, in the Sales by Employee table, click the Actual Sales field, and then press ENTER. | 9. | Press ALT (or F10, or F6 until the Ribbon is selected), JQ, G. Or, press ALT (or F10, or F6 until the Ribbon is selected) H, W, H (or ENTER, or SPACEBAR). | | Ribbon (2) 1. | On the CREATE tab, in the Queries group, click Query Design. | 2. | In the Show Table dialog box, click Close (or click the Close (X) button). | 3. | Click and drag the Employee Info table from the Navigation Pane to the query window. Release the mouse button. | 4. | Click and drag the Sales by Employee table from the Navigation Pane to the query window. Release the mouse button. | 5. | In the query design window, in the Employee Info table, drag the First Name field to the first column in the query design grid. Release the mouse button. | 6. | In the query design window, in the Employee Info table, drag the Last Name field to the first empty column in the query design grid. Release the mouse button. | 7. | In the query design window, in the Sales by Employee table, drag the Quarter field to the first empty column in the query design grid. Release the mouse button. | 8. | In the query design window, in the Sales by Employee table, drag the Actual Sales field to the first empty column in the query design grid. Release the mouse button. | 9. | On the DESIGN tab, in the Results group, click Run. Alternatively, right-click in the design window (or on the query tab) and from the shortcut menu, click Datasheet View (or press H). Or, on the HOME tab, in the Views group, click the top half of the View button, or click View, Datasheet View. Or, click Datasheet on the status bar. | | Ribbon (3) 1. | On the CREATE tab, in the Queries group, click Query Design. | 2. | In the Show Table dialog box, on the Tables tab (or the Both tab), double-click the Employee Info table (or click the Employee Info table, and then click the Add button). | 3. | On the Tables tab (or the Both tab), double-click the Sales by Employee table (or with the Employee Info table selected, click the Add button). | 4. | Click Close (or click the Close (X) button). | 5. | In the first column of the query design grid, with the insertion point in the Field row, type Employee Info.F, press ENTER or TAB (or click in any other cell). | 6. | If necessary, click in the Field row of the second column. Type Employee Info.L, press ENTER (or TAB or click in any other cell). | 7. | If necessary, click in the Field row of the third column. Type Sales by Employee.Q , press ENTER (or TAB or click in any other cell). | 8. | If necessary, click in the Field row of the fourth column. Type Sales by Employee.A, press ENTER (or TAB or click in any other cell). | 9. | On the DESIGN tab, in the Results group, click Run. Alternatively, right-click in the design window (or on the query tab) and from the shortcut menu, click Datasheet View (or press H). Or, on the HOME tab, in the Views group, click the top half of the View button, or click View, Datasheet View. Or, click Datasheet on the status bar. | | Ribbon (4) 1. | On the CREATE tab, in the Queries group, click Query Design. | 2. | In the Show Table dialog box, click the Close button (or click the Close (X) button). | 3. | On the DESIGN tab, in the Query Setup group, click the Show Table button. Alternatively, right-click in the query window, and from the shortcut menu click Show Table (or press T). Alternatively, press ALT (or F10, or F6 three times), JQ, and then ST. | 4. | In the Show Table dialog box, on the Tables tab (or the Both tab), double-click the Employee Info table (or with Employee Info the table selected, click the Add button). | 5. | On the Tables tab (or the Both tab), double-click the Sales by Employee table (or click the Employee Info table, and then click the Add button). | 6. | Click Close (or click the Close (X) button). | 7. | In the query design window, in the Employee Info table, double-click the First Name field. | 8. | In the query design window, in the Employee Info table, double-click the Last Name field. | 9. | In the query design window, in the Sales by Employee table, double-click the Quarter field. | 10. | In the query design window, in the Sales by Employee table, double-click the Actual Sales field. | 11. | On the DESIGN tab, in the Results group, click Run. | | Ribbon (5) 1. | On the CREATE tab, in the Queries group, click Query Design. | 2. | In the Show Table dialog box, double-click the Employee Info table. | 3. | Click Close (or click the Close (X) button). | 4. | Click and drag the Sales by Employee table from the Navigation Pane to the query window. Release the mouse button. | 5. | Click in the Table row in the first column of the query design grid, and then type Employee Info. | 6. | Click in the Field row in the first column of the query design grid, and then type F. With First Name autocompleted in the cell, press ENTER (or TAB or click in any other cell). | 7. | Click in the Table row in the second column of the query design grid, type Employee Info. | 8. | Click in the Field row in the second column of the query design grid, and then type L. With Last Name autocompleted in the cell, press ENTER (or TAB or click in any other cell). | 9. | Click in the Table row in the third column of the query design grid, type Sales by Employee. | 10. | Click in the Field row in the third column of the query design grid, and then type Q. With Quarter autocompleted in the cell, press ENTER (or TAB or click in any other cell). | 11. | Click in the Table row in the fourth column of the query design grid, type Sales by Employee. | 12. | Click in the Field row in the fourth column of the query design grid, and then type A. With Actual autocompleted in the cell, press ENTER (or TAB or click in any other cell). | 13. | On the DESIGN tab, in the Results group, click Run. Alternatively, right-click in the design window (or on the query tab) and from the shortcut menu, click Datasheet View (or press H). Or, on the HOME tab, in the Views group, click the top half of the View button, or click View, Datasheet View. Or, click Datasheet on the status bar. | | | | | 2 ) Add 1st to the criteria for the Quarter field. Sort the query by the Actual Sales field in ascending order. Save the query as Employee Commissions_1st Qtr. Run the query. Ribbon 1. | On the HOME tab, in the Views group, click the View arrow, and then click Design View. | 2. | Click in the Criteria row for the Quarter field and type 1st. | 3. | Click in the Sort row (third row) under the Actual Sales field, click the drop-down arrow, and select Ascending from the list. | 4. | Click Save on the Quick Access Toolbar. | 5. | Type Employee Commissions_1st Qtr as the Query Name in the Save As dialog box. | 6. | Click OK. | 7. | On the DESIGN tab, in the Results group, click Run. | | Ribbon (2) 1. | On the HOME tab, in the Views group, click the top half of the View button. Alternatively, right-click the query tab, and from the shortcut menu, click Design View (or press D). Alternatively, on the status bar, click the Design View button. | 2. | Click in the Criteria row for the Quarter field and type 1st (or "1st" or =1st or ="1st"). Press ENTER--optional. | 3. | Double-click in the Sort row (third row) under the Actual Sales field until Ascending appears. | 4. | Click Save on the Quick Access Toolbar. Alternatively, click the FILE tab, and then click Save.
Or, click the FILE tab, click Save As, click Save Object As and then double-click Save Object As (or click the Save As button). Or, right-click the Query1 tab and from the shortcut menu, click Save (or press S). | 5. | Type Employee Commissions_1st Qtr as the Query Name in the Save As dialog box. | 6. | Click OK. | 7. | On the DESIGN tab, in the Results group, click Run. Alternatively, right-click in the design window (or on the query tab) and from the shortcut menu, click Datasheet View (or press H). Or, on the HOME tab, in the Views group, click the top half of the View button, or click View, Datasheet View. Or, click Datasheet on the status bar. Or, double-click the query in the Navigation Pane (or right-click and then click Open). | | Keyboard 1. | Press ALT (or F10, or F6 until the Ribbon is selected), H, W, and then D. | 2. | Use the TAB and/or ARROW keys to select the third row (the Sort row) under the Actual Sales field, press ALT+ DOWN ARROW, use ARROW keys to select Ascending and press ENTER (or type A, or a). | 3. | Navigate to the Criteria row for the Quarter field and type 1st (or "1st" or =1st or ="1st"). Press ENTER--optional. | 4. | Press CTRL+S. Or, press ALT+1 (or press ALT (or F10, or F6 until the Ribbon is selected), F, S (or F, A, O, B, ENTER (or SPACEBAR)) . Alternatively, press ALT (or F10, or F6 until the Ribbon is selected), F, A, O, B, A. Alternatively, press F12. | 5. | Type Employee Commissions_1st Qtr as the Query Name in the Save As dialog box. | 6. | Press ENTER (or TAB to OK and press ENTER (or SPACEBAR). | 7. | Press ALT (or F10, or F6 until the Ribbon is selected), JQ, G. Or, press ALT (or F10, or F6 until the Ribbon is selected) H, W, H (or ENTER, or SPACEBAR). Or, with the query selected in the Navigation Pane, press ENTER (or right-click and press O). | | | | | 3 ) Switch to Design view, add a new field named Commission that multiplies the Actual Sales field by .025. Press ENTER. Run the query. Save the query. Ribbon 1. | On the HOME tab, in the Views group, click the View arrow, and then click Design View. | 2. | Click in the top row of the first empty field and type Commission: [Actual Sales]*.025. | 3. | Press ENTER. | 4. | On the DESIGN tab, in the Results group, click Run. | 5. | Click Save on the Quick Access Toolbar. | | Ribbon (2) 1. | On the HOME tab, in the Views group, click the top half of the View button. Alternatively, right-click the query in the Navigation Pane, and from the shortcut menu, click Design View. Alternatively, right-click the query tab, and from the shortcut menu, click Design View (or press D). Alternatively, on the status bar, click the Design View button. | 2. | Click the first row of the first empty column of the query, and on the DESIGN tab, in the Query Setup group, click Builder. Alternatively, right-click the first row of the first empty column of the query, and from the shortcut menu, click Build. | 3. | In the middle column of the Expression Builder dialog box, double-click the Actual Sales field, (or in the left column, double-click the database button (a03h1EmployeeSales), double-click the Tables button, click the Sales by Employee table, and then in the middle column, double-click Actual Sales. In the left column, click the Operators folder then in the right column, double-click the Multiplication (*) operator button. | 4. | Type .025 (or 0.025) | 5. | In the Expression box, at the beginning of the expression, type Commission: and then click OK. | 6. | On the DESIGN tab, in the Results group, click Run. Alternatively, right-click in the design window (or on the query tab) and from the shortcut menu, click Datasheet View (or press H). Or, on the HOME tab, in the Views group, click the top half of the View button, or click View, Datasheet View. Or, click Datasheet on the status bar. Or, double-click the query in the Navigation Pane (or right-click and then click Open). | 7. | Click Save on the Quick Access Toolbar. Alternatively, click the FILE tab, and then click Save.
Or, right-click the query tab and from the shortcut menu, click Save (or press S). Or, click the FILE tab, click Save As, click Save Object As and then double-click Save Object As (or click the Save As button). Type Employee Commissions_1st Qtr as the Query Name in the Save As dialog box. Click OK. | | Right-Click 1. | On the HOME tab, in the Views group, click the View arrow, and then click Design View. | 2. | Right-click in the first row of the first empty column of the query, and from the shortcut menu, click Zoom. Alternatively, press SHIFT+F2 (or SHIFT+F10, and then Z). | 3. | In the Zoom dialog box, type Commission: [Actual Sales]*.025 (or Commission: [Actual Sales]*0.025 or Commission: Sales by Employee![Actual Sales]*.025). Click OK (or, press TAB to select OK, and then press ENTER (or SPACEBAR). | 4. | On the DESIGN tab, in the Results group, click Run. Alternatively, right-click in the design window (or on the query tab) and from the shortcut menu, click Datasheet View (or press H). Or, on the HOME tab, in the Views group, click the top half of the View button, or click View, Datasheet View. Or, click Datasheet on the status bar. Or, double-click the query in the Navigation Pane (or right-click and then click Open). | 5. | Click Save on the Quick Access Toolbar. Alternatively, click the FILE tab, and then click Save.
Or, right-click the query tab and from the shortcut menu, click Save (or press S). Or, click the FILE tab, click Save As, click Save Object As and then double-click Save Object As (or click the Save As button). Type Employee Commissions_1st Qtr as the Query Name in the Save As dialog box. Click OK. | | Keyboard 1. | Press ALT (or F10, or F6 until the Ribbon is selected), H, W, and then D. Alternatively, press F6 to select the Navigation Pane and Press Tab and Arrow Keys to Select Query, and then press CTRL+ENTER (or SHIFT+F10, and then D). | 2. | In the first row of the first empty column of the query, type Commission: [Actual Sales]*.025 (or Commission: [Actual Sales]*0.025 or Commission: Sales by Employee![Actual Sales]*.025). Press ENTER (or DOWN ARROW or TAB or click in any other cell). | 3. | Press ALT (or F10, or F6 until the Ribbon is selected), JQ, G. Or, press ALT (or F10, or F6 until the Ribbon is selected) H, W, H (or ENTER, or SPACEBAR). Or, with the query selected in the Navigation Pane, press ENTER (or right-click and press O). | 4. | Press CTRL+S. Or, press ALT+1 (or press ALT (or F10, or F6 until the Ribbon is selected), F, S (or F, A, O, B, ENTER (or SPACEBAR)) . Alternatively, press ALT (or F10, or F6 until the Ribbon is selected), F, A, O, B, A. Alternatively, press F12. Type Employee Commissions_1st Qtr as the Query Name in the Save As dialog box. Press ENTER (or TAB to OK and press ENTER (or SPACEBAR)). | | Keyboard (2) 1. | Press ALT (or F10, or F6 until the Ribbon is selected), H, W, and then D. Alternatively, press F6 to select the Navigation Pane and Press Tab and Arrow Keys to Select Query, and then press CTRL+ENTER (or SHIFT+F10, and then D). | 2. | In the first row of the first empty column of the query, press ALT (or F10, or F6 until the Ribbon is selected), JQ, and then B (Or press SHIFT+F10, and then B, or CTRL+F2). | 3. | Press TAB to select the middle column, DOWN ARROW to select Actual Sales, and then press SPACEBAR. Type *. | 4. | Type .025 (or 0.025). | 5. | In the Expression box, at the beginning of the expression (press HOME), type Commission: then press TAB to select OK, and then press ENTER (or SPACEBAR). Alternatively, type the expression as Commission: [Actual Sales]*.025 (or Commission: [Actual Sales]*0.025 or Commission: Sales by Employee![Actual Sales]*.025). Press TAB to select OK, and then press ENTER (or SPACEBAR). | 6. | Press ALT (or F10, or F6 until the Ribbon is selected), JQ, G. Or, press ALT (or F10, or F6 until the Ribbon is selected) H, W, H (or ENTER, or SPACEBAR). Or, with the query selected in the Navigation Pane, press ENTER (or right-click and press O). | 7. | Press CTRL+S. Or, press ALT+1, (or press ALT (or F10, or F6 until the Ribbon is selected), F, S (or press F12, or press ALT (or F10, or F6 until the Ribbon is selected), F, A, O, B, ENTER (or SPACEBAR)) . Alternatively, press ALT (or F10, or F6 until the Ribbon is selected), F, A, O, B, A. Type Employee Commissions_1st Qtr as the Query Name in the Save As dialog box. Press ENTER (or TAB to OK and press ENTER (or SPACEBAR)). | | | | | Show Student Actions
Ribbon: (Correct Action)
Show Table Dialog: Event performed on list item is: 1 ()
Show Table Dialog: Event performed on list item is: 1 ()
Show Table Dialog: Event performed on list item is: 2 ()
OK button clicked (Correct Action)
Relationship Board: undefined/* Element Selected ()
Show Table Dialog: Event performed on list item is: 1 ()
Show Table Dialog: Event performed on list item is: 1 ()
Show Table Dialog: Event performed on list item is: 2 ()
OK button clicked (Correct Action)
Relationship Board: undefined/* Element Selected ()
Cancel button clicked (Correct Action)
Relationship Board: Employee Info/First Name Element Selected ()
Relationship Board: Employee Info/First Name Element Selected ()
Query Design Board: all requested fields dropped (Correct Action)
Relationship Board: Employee Info/Last Name Element Selected ()
Relationship Board: Employee Info/Last Name Element Selected ()
Query Design Board: all requested fields dropped (Correct Action)
Relationship Board: Sales by Employee/Quarter Element Selected ()
Relationship Board: Sales by Employee/Quarter Element Selected ()
Query Design Board: all requested fields dropped (Correct Action)
Relationship Board: Sales by Employee/Actual Sales Element Selected ()
Relationship Board: Sales by Employee/Actual Sales Element Selected ()
Query Design Board: all requested fields dropped (Correct Action)
Ribbon: (Correct Action)
Ribbon: Design ViewD (Correct Action)
Query Design Board: Cell Value Changed (Correct Action)
Query Design Board: Cell Value Changed (Correct Action)
Ribbon: Save (Correct Action)
SaveAs Dialog: File Name changed to E ()
SaveAs Dialog: File Name changed to E ()
SaveAs Dialog: File Name changed to E ()
SaveAs Dialog: File Name changed to Em ()
SaveAs Dialog: File Name changed to Em ()
SaveAs Dialog: File Name changed to Emp ()
SaveAs Dialog: File Name changed to Emp ()
SaveAs Dialog: File Name changed to Empl ()
SaveAs Dialog: File Name changed to Empl ()
SaveAs Dialog: File Name changed to Emplo ()
SaveAs Dialog: File Name changed to Emplo ()
SaveAs Dialog: File Name changed to Employ ()
SaveAs Dialog: File Name changed to Employ ()
SaveAs Dialog: File Name changed to Employe ()
SaveAs Dialog: File Name changed to Employe ()
SaveAs Dialog: File Name changed to Employee ()
SaveAs Dialog: File Name changed to Employee ()
SaveAs Dialog: File Name changed to Employee ()
SaveAs Dialog: File Name changed to Employee ()
SaveAs Dialog: File Name changed to Employee C ()
SaveAs Dialog: File Name changed to Employee C ()
SaveAs Dialog: File Name changed to Employee C ()
SaveAs Dialog: File Name changed to Employee Co ()
SaveAs Dialog: File Name changed to Employee Co ()
SaveAs Dialog: File Name changed to Employee Com ()
SaveAs Dialog: File Name changed to Employee Com ()
SaveAs Dialog: File Name changed to Employee Comm ()
SaveAs Dialog: File Name changed to Employee Comm ()
SaveAs Dialog: File Name changed to Employee Commi ()
SaveAs Dialog: File Name changed to Employee Commi ()
SaveAs Dialog: File Name changed to Employee Commis ()
SaveAs Dialog: File Name changed to Employee Commis ()
SaveAs Dialog: File Name changed to Employee Commiss ()
SaveAs Dialog: File Name changed to Employee Commiss ()
SaveAs Dialog: File Name changed to Employee Commissi ()
SaveAs Dialog: File Name changed to Employee Commissi ()
SaveAs Dialog: File Name changed to Employee Commissio ()
SaveAs Dialog: File Name changed to Employee Commissio ()
SaveAs Dialog: File Name changed to Employee Commission ()
SaveAs Dialog: File Name changed to Employee Commission ()
SaveAs Dialog: File Name changed to Employee Commissions ()
SaveAs Dialog: File Name changed to Employee Commissions ()
SaveAs Dialog: File Name changed to Employee Commissions_ ()
SaveAs Dialog: File Name changed to Employee Commissions_ ()
SaveAs Dialog: File Name changed to Employee Commissions_ ()
SaveAs Dialog: File Name changed to Employee Commissions_1 ()
SaveAs Dialog: File Name changed to Employee Commissions_1 ()
SaveAs Dialog: File Name changed to Employee Commissions_1s ()
SaveAs Dialog: File Name changed to Employee Commissions_1s ()
SaveAs Dialog: File Name changed to Employee Commissions_1st ()
SaveAs Dialog: File Name changed to Employee Commissions_1st ()
SaveAs Dialog: File Name changed to Employee Commissions_1st ()
SaveAs Dialog: File Name changed to Employee Commissions_1st ()
SaveAs Dialog: File Name changed to Employee Commissions_1st Q ()
SaveAs Dialog: File Name changed to Employee Commissions_1st Q ()
SaveAs Dialog: File Name changed to Employee Commissions_1st Q ()
SaveAs Dialog: File Name changed to Employee Commissions_1st Qt ()
SaveAs Dialog: File Name changed to Employee Commissions_1st Qt ()
SaveAs Dialog: File Name changed to Employee Commissions_1st Qtr ()
SaveAs Dialog: File Name changed to Employee Commissions_1st Qtr ()
SaveAs Dialog - OK button clicked (Correct Action)
Ribbon: (Correct Action)
Ribbon: Design ViewD (Correct Action)
Query Design Board: Cell Value Changed (Incorrect Action)
Ribbon: (Incorrect Action)
Ribbon: (Correct Action)
Show Table Dialog: Event performed on list item is: 1 ()
Show Table Dialog: Event performed on list item is: 1 ()
Show Table Dialog: Event performed on list item is: 2 ()
OK button clicked (Correct Action)
Relationship Board: undefined/* Element Selected ()
Show Table Dialog: Event performed on list item is: 1 ()
Show Table Dialog: Event performed on list item is: 1 ()
Show Table Dialog: Event performed on list item is: 2 ()
OK button clicked (Correct Action)
Relationship Board: undefined/* Element Selected ()
Cancel button clicked (Correct Action)
Relationship Board: Employee Info/First Name Element Selected ()
Relationship Board: Employee Info/First Name Element Selected ()
Query Design Board: all requested fields dropped (Correct Action)
Relationship Board: Employee Info/Last Name Element Selected ()
Relationship Board: Employee Info/Last Name Element Selected ()
Query Design Board: all requested fields dropped (Correct Action)
Relationship Board: Sales by Employee/Actual Sales Element Selected ()
Relationship Board: Sales by Employee/Actual Sales Element Selected ()
Query Design Board: wrong field dropped (Incorrect Action)
Relationship Board: Sales by Employee/Quarter Element Selected ()
Relationship Board: Sales by Employee/Quarter Element Selected ()
Query Design Board: all requested fields dropped (Correct Action)
Relationship Board: Sales by Employee/Actual Sales Element Selected ()
Query Design Board: all requested fields dropped (Correct Action)
Ribbon: (Correct Action)
Ribbon: Design ViewD (Correct Action)
Query Design Board: Cell Value Changed (Correct Action)
Query Design Board: Cell Value Changed (Correct Action)
Ribbon: (Incorrect Action)
Ribbon: Save (Correct Action)
SaveAs Dialog: File Name changed to E ()
SaveAs Dialog: File Name changed to E ()
SaveAs Dialog: File Name changed to E ()
SaveAs Dialog: File Name changed to Em ()
SaveAs Dialog: File Name changed to Em ()
SaveAs Dialog: File Name changed to Emp ()
SaveAs Dialog: File Name changed to Emp ()
SaveAs Dialog: File Name changed to Empl ()
SaveAs Dialog: File Name changed to Empl ()
SaveAs Dialog: File Name changed to Emplo ()
SaveAs Dialog: File Name changed to Emplo ()
SaveAs Dialog: File Name changed to Employ ()
SaveAs Dialog: File Name changed to Employ ()
SaveAs Dialog: File Name changed to Employe ()
SaveAs Dialog: File Name changed to Employe ()
SaveAs Dialog: File Name changed to Employee ()
SaveAs Dialog: File Name changed to Employee ()
SaveAs Dialog: File Name changed to Employee ()
SaveAs Dialog: File Name changed to Employee ()
SaveAs Dialog: File Name changed to Employee C ()
SaveAs Dialog: File Name changed to Employee C ()
SaveAs Dialog: File Name changed to Employee C ()
SaveAs Dialog: File Name changed to Employee Co ()
SaveAs Dialog: File Name changed to Employee Co ()
SaveAs Dialog: File Name changed to Employee Com ()
SaveAs Dialog: File Name changed to Employee Com ()
SaveAs Dialog: File Name changed to Employee Comm ()
SaveAs Dialog: File Name changed to Employee Comm ()
SaveAs Dialog: File Name changed to Employee Commi ()
SaveAs Dialog: File Name changed to Employee Commi ()
SaveAs Dialog: File Name changed to Employee Commis ()
SaveAs Dialog: File Name changed to Employee Commis ()
SaveAs Dialog: File Name changed to Employee Commiss ()
SaveAs Dialog: File Name changed to Employee Commiss ()
SaveAs Dialog: File Name changed to Employee Commissi ()
SaveAs Dialog: File Name changed to Employee Commissi ()
SaveAs Dialog: File Name changed to Employee Commissio ()
SaveAs Dialog: File Name changed to Employee Commissio ()
SaveAs Dialog: File Name changed to Employee Commission ()
SaveAs Dialog: File Name changed to Employee Commission ()
SaveAs Dialog: File Name changed to Employee Commissions ()
SaveAs Dialog: File Name changed to Employee Commissions ()
SaveAs Dialog: File Name changed to Employee Commissions_ ()
SaveAs Dialog: File Name changed to Employee Commissions_ ()
SaveAs Dialog: File Name changed to Employee Commissions_ ()
SaveAs Dialog: File Name changed to Employee Commissions_1 ()
SaveAs Dialog: File Name changed to Employee Commissions_1 ()
SaveAs Dialog: File Name changed to Employee Commissions_1s ()
SaveAs Dialog: File Name changed to Employee Commissions_1s ()
SaveAs Dialog: File Name changed to Employee Commissions_1st ()
SaveAs Dialog: File Name changed to Employee Commissions_1st ()
SaveAs Dialog: File Name changed to Employee Commissions_1st ()
SaveAs Dialog: File Name changed to Employee Commissions_1st ()
SaveAs Dialog: File Name changed to Employee Commissions_1st Q ()
SaveAs Dialog: File Name changed to Employee Commissions_1st Q ()
SaveAs Dialog: File Name changed to Employee Commissions_1st Q ()
SaveAs Dialog: File Name changed to Employee Commissions_1st Qt ()
SaveAs Dialog: File Name changed to Employee Commissions_1st Qt ()
SaveAs Dialog: File Name changed to Employee Commissions_1st Qtr ()
SaveAs Dialog: File Name changed to Employee Commissions_1st Qtr ()
SaveAs Dialog - OK button clicked (Correct Action)
Ribbon: (Correct Action)
Ribbon: Design ViewD (Correct Action)
Query Design Board: Cell Value Changed (Correct Action)
Ribbon: Save (Incorrect Action) | | 2) | AC Step 3.1.2: Format and Save Calculated Results | Application: Access | Page Number: 749 | Scenario: Assessment Scenario 1 | | | Score:0.00Time Taken:00:26(mm:ss) | Status : Incomplete | | Show All | Hide all | 1 ) In Design view of the Employee Commissions_1st Qtr_Formatted query, format the Commission calculated field as Currency with two decimal places, and add a caption of 1st Qtr Commission (no period). Press ENTER. Ribbon 1. | Click in the calculated field, and on the DESIGN tab, in the Show/Hide group, click Property Sheet. | 2. | In the Property Sheet, with the Format set to Currency, click the Decimal Places box, select the existing value, and type 2. | 3. | Click in the Caption box, and type 1st Qtr Commission (no period). | 4. | Press ENTER. | | Ribbon (2) 1. | Click in the calculated field, and on the DESIGN tab, in the Show/Hide group click Property Sheet. | 2. | In the Property Sheet, click the Decimal Places box, select the existing value, press DELETE or BACKSPACE, or CTRL+X--optional, and type 2. Click in the Caption box, and type 1st Qtr Commission (no period). Press ENTER. | | Right-Click 1. | Right-click the calculated field, and then from the shortcut menu, click Properties. | 2. | In the Property sheet, click the Decimal Places box, select the existing value, press DELETE or BACKSPACE, or CTRL+X--optional, and type 2. | 3. | Click in the Caption box, and type 1st Qtr Commission. Press ENTER. | | Keyboard 1. | Use ARROW keys to select the calculated field. Press ALT+ENTER (or SHIFT+F10, press P two times, and then press ENTER (or SPACEBAR)). | 2. | In the Property Sheet, click the Decimal Places box, select the existing value, press DELETE or BACKSPACE, or CTRL+X--optional, and type 2. | 3. | Click in the Caption box, and type 1st Qtr Commission. Press ENTER. | | Keyboard (2) 1. | Use ARROW keys to select the calculated field. Press ALT (or F10, or F6 until ribbon is selected), JQ, and then HP. | 2. | In the Property Sheet, click the Decimal Places box, select the existing value, press DELETE or BACKSPACE, or CTRL+X--optional, and type 2. | 3. | Click in the Caption box, and type 1st Qtr Commission. Press ENTER. | | | | | 2 ) Run the query, and then save the query. Ribbon 1. | On the DESIGN tab, in the Results group, click the Run button. | 2. | Click Save on the Quick Access Toolbar. | | Ribbon (2) 1. | On the DESIGN tab, in the Results group, click Run. Alternatively, right-click in the design window (or on the query tab) and from the shortcut menu, click Datasheet View (or press H). Or, on the HOME tab, in the Views group, click the top half of the View button, or click View, Datasheet View. Or, click Datasheet on the status bar. Or, double-click the query in the Navigation Pane (or right-click and then click Open). | 2. | Click Save on the Quick Access Toolbar. Alternatively, click the FILE tab, and then click Save.
Or, right-click the query tab and from the shortcut menu, click Save (or press S). Or, click the FILE tab, click Save As, click Save Object As and then double-click Save Object As (or click the Save As button). Type Employee Commissions_1st Qtr_Formatted as the Query Name in the Save As dialog box. Click OK. | | Keyboard 1. | Press ALT (or F10, or F6 until Ribbon is selected), JQ, G. Or, press ALT (or F10, or F6 until Ribbon is selected) H, W, H (or ENTER, or SPACEBAR). Or, with the query selected in the Navigation Pane, press ENTER (or right-click and press O). | 2. | Press CTRL+S. Or, press ALT+1 (or press ALT (or F10, or F6 until Ribbon is selected), F, S (or press F12, or press ALT (or F10, or F6 until Ribbon is selected), F, A, O, B, ENTER (or SPACEBAR)). Alternatively, press ALT (or F10, or F6 until Ribbon is selected), F, A, O, B, A. Type Employee Commissions_1st Qtr_Formatted as the Query Name in the Save As dialog box. Press ENTER (or TAB to OK and press ENTER (or SPACEBAR)). | | | | | Hide Student Actions
Ribbon: Close (Incorrect Action)
Ribbon: Close (Incorrect Action) | | 3) | AC Step 3.1.3: Recover from Common Errors | Application: Access | Page Number: 750 | Scenario: Assessment Scenario 1 | | | Status : Unattempted | | Show All | Hide all | 1 ) Create a new column in the query with the following formula: Wrong Commission: [xActual Sales]*[Rate]. Ribbon 1. | Click in the top row of the first empty field and type Wrong Commission: [xActual Sales]*[Rate]. Press ENTER (or TAB). | | Ribbon (2) 1. | Click the first row of the first empty column of the query, and on the DESIGN tab, in the Query Setup group, click Builder. Alternatively, right-click the first row of the first empty column of the query, and from the shortcut menu, click Build. | 2. | In the middle column of the Expression Builder dialog box, double-click the Actual Sales field, (or in the left column, double-click a03h1EmployeeSales.accdb, double-click the Tables button, click the Sales by Employee table, and then in the middle column, double-click Actual Sales). Type an "x" before Actual Sales, in the left column, click the Operators folder then in the right column, double-click the Multiplication (*) operator button. | 3. | Type [Rate]. | 4. | In the Expression box, at the beginning of the expression, type Wrong Commission: and then click OK. | | Right-Click 1. | Right-click in the first row of the first empty column of the query, and from the shortcut menu, click Zoom. Alternatively, press SHIFT+F2 (or SHIFT+F10, and then Z). | 2. | In the Zoom dialog box, type Wrong Commission: [xActual Sales]*[Rate] (or Wrong Commission: [Sales by Employee]![xActual Sales]*[Rate]). Click OK (or, press TAB to select OK, and then press ENTER (or SPACEBAR). | | Keyboard 1. | In the first row of the first empty column of the query, type Wrong Commission: [xActual Sales]*[Rate] (or Wrong Commission: [Sales by Employee]![xActual Sales]*[Rate]). Press ENTER (or DOWN ARROW or TAB or click in any other cell). | | Keyboard (2) 1. | In the first row of the first empty column of the query, press ALT (or F10, or F6 until the ribbon is selected), JQ, and then B (or press SHIFT+F10, and then B or CTRL+F2). | 2. | Press TAB to select the middle column, DOWN ARROW to select Actual Sales, and then press SPACEBAR. Type "x" before Actual Sales. Type *. | 3. | Type [Rate]. | 4. | In the Expression box, at the beginning of the expression (press HOME), type Wrong Commission: then press TAB to select OK, and then press ENTER (or SPACEBAR). Alternatively, type Wrong Commission: [xActual Sales]*[Rate] (or Wrong Commission: [Sales by Employee]![xActual Sales]*[Rate]). Press TAB to select OK, and then press ENTER (or SPACEBAR). | | | | | 2 ) Run the query. Enter 100000 in the first parameter box and .03 in the second. Notice that all results display $3,000 Ribbon 1. | On the DESIGN tab, in the Results group, click Run. | 2. | Type 100000 in the Enter Parameter Value box. | 3. | Press ENTER. | 4. | Type .03 in the second Enter Parameter Value box. | 5. | Press ENTER. | | Keyboard 1. | Press ALT (or F10, or F6 until the ribbon is selected), JQ, G. | 2. | Type 100000 in the Enter Parameter Value box. Press ENTER. Type .03 in the second Enter Parameter Value box. Press ENTER (or TAB to OK, and then press ENTER (or SPACEBAR)). | | Ribbon (2) 1. | On the DESIGN tab, in the Results group, click the top half of the View button (or click the View and then click Datasheet View). | 2. | Type 100000 in the Enter Parameter Value box. Press ENTER (or click OK). Type .03 in the second Enter Parameter Value box. Press ENTER (or click OK, or TAB to OK, and then press ENTER (or SPACEBAR)). | | Keyboard (2) 1. | Press ALT (or F10, or F6 until the ribbon is selected), JQ, W, H. | 2. | Type 100000 in the Enter Parameter Value box. Press ENTER. Type .03 in the second Enter Parameter Value box. Press ENTER (or TAB to OK, and then press ENTER (or SPACEBAR)). | | Ribbon (3) 1. | On the HOME tab, in the Views group, click the top half of the View button (or click View and then click Datasheet View). | 2. | Type 100000 in the Enter Parameter Value box. Press ENTER. Type .03 in the second Enter Parameter Value box. Press ENTER (or TAB to OK, and then press ENTER (or SPACEBAR)). | | Keyboard (3) 1. | Press ALT (or F10 or F6 until the ribbon is selected), H, W, H. | 2. | Type 100000 in the Enter Parameter Value box. Press ENTER. Type .03 in the second Enter Parameter Value box. Press ENTER (or TAB to OK, and then press ENTER (or SPACEBAR)). | | Right-Click 1. | Right-click the query tab (or in the top pane of the query design window) and from the shortcut menu, click Datasheet View (or press H). | 2. | Type 100000 in the Enter Parameter Value box. Press ENTER. Type .03 in the second Enter Parameter Value box. Press ENTER (or TAB to OK, and then press ENTER (or SPACEBAR)). | | | | | 3 ) Switch to Design view, and change the Wrong Commission formula to read Commission: [Actual Sales]*[Rate]. Run the query and enter .03 in the parameter box when prompted. The query will now display the correct results. Ribbon 1. | On the HOME tab, in the Views group, click the View arrow, and then click Design View. | 2. | In the calculated field, modify the formula to Commission: [Actual Sales]*[Rate]. Delete the x before Actual Sales. Press ENTER. | 3. | On the DESIGN tab, in the Results group, click Run. | 4. | Type .03 in the Enter Parameter Value box. Click OK or press ENTER (or TAB to OK, and then press ENTER (or SPACEBAR)). | | Ribbon (2) 1. | On the HOME tab, in the Views group, click the top half of the View button. Alternatively, right-click the query in the Navigation Pane, and from the shortcut menu, click Design View. Alternatively, right-click the query tab, and from the shortcut menu, click Design View (or press D). Alternatively, on the status bar, click the Design View button. | 2. | Click the calculated field, and on the DESIGN tab, in the Query Setup group, click Builder. Alternatively, right-click the calculated field of the query, and from the shortcut menu, click Build. Or, press ALT (or F10, or F6 until the ribbon is selected), JQ, and then B (or press SHIFT+F10, and then B or CTRL+F2). | 3. | In the Expression Builder, modify the formula to Commission: [Actual Sales]*[Rate]. | 4. | Click OK (or TAB to OK and press ENTER (or SPACEBAR)). | 5. | On the DESIGN tab, in the Results group, click Run. Alternatively, right-click in the design window (or on the query tab) and from the shortcut menu, click Datasheet View (or press H). Or, on the HOME tab, in the Views group, click the top half of the View button, or click View, Datasheet View. Or, click Datasheet on the status bar. Or, double-click the query in the Navigation Pane (or right-click and then click Open). | 6. | Type .03 in the Enter Parameter Value box. Click OK or press ENTER (or TAB to OK, and then press ENTER (or SPACEBAR)). | | Keyboard 1. | Press ALT (or F10, or F6 three times), H, W, and then D. Alternatively, press F6 to select the query in the Navigation Pane, and then press CTRL+ENTER (or SHIFT+F10, and then D). | 2. | Select (or click in) the calculated field, press SHIFT+F2 (or SHIFT+F10, and then Z). Alternatively, right-click in the calculated field, and from the shortcut menu, click Zoom. | 3. | In the Zoom dialog box, modify the formula to Commission: [Actual Sales]*[Rate]. Click OK (or TAB to OK and press ENTER (or SPACEBAR)). | 4. | Press ALT (or F10, or F6 until the ribbon is selected), JQ, G. Or, press ALT (or F10, or F6 until the ribbon is selected) H, W, H (or ENTER, or SPACEBAR). Or, with the query selected in the Navigation Pane, press ENTER (or right-click and press O). | 5. | Type .03 in the Enter Parameter Value box. Click OK or press ENTER (or TAB to OK, and then press ENTER (or SPACEBAR)). | | | | | Hide Student Actions | | 4) | AC Step 3.1.4: Verify the Calculated Results | Application: Access | Page Number: 751 | Scenario: Assessment Scenario 1 | | | Status : Unattempted | | Show All | Hide all | 1 ) Verify the copied calculated results of the Employee Commissions_2nd Qtr query in the Excel worksheet. Type =C2*.03 in cell E2 and press ENTER. Keyboard 1. | Click cell E2 and type =C2*.03. | 2. | Press ENTER. | | Other (4) 1. | Click cell E2 and then type =. | 2. | Click cell C2. | 3. | Type * (multiplication sign) .03. | 4. | Click Enter to the left of the Formula Bar. | | Keyboard (8) 1. | Click cell E2 and in the cell or in the Formula Bar type =C2*.03 or =(C2*.03). | 2. | Press ENTER (or TAB, or click the Enter button on the Formula Bar). | | | | | 2 ) Copy the formula from cell E2 and simultaneously paste it into cells E3 to E11. Compare the results in column D (from the Access query) to column E. The numbers should be the same. Ribbon 1. | Click cell E2, then on the HOME tab, in the Clipboard Group, click Copy. | 2. | Select cells E3 through E11 (or E2:E11), and on the HOME tab, in the Clipboard Group, click Paste. | | Ribbon (2) 1. | Click cell E2, then on the HOME tab, in the Clipboard group, click the Copy button. | 2. | Select cells E3 through E11 (or E2:E11), and on the HOME tab, in the Clipboard group, click the Paste arrow, and then from the menu, click Paste (or Formulas, or Formulas & Number Formatting, or Keep Source Formatting, or No Borders, or Keep Source Column Widths). | | Right-Click 1. | Click cell E2, right-click, and then from the shortcut menu, click Copy. | 2. | Select cells E3 through E11 (or E2:E11), right-click, and then from the shortcut menu, click Paste (or Formulas). | | Keyboard 1. | Select cell E2, press ALT (or F10, or F6 two times), H, C, and then C. Alternatively, press CTRL+C. | 2. | Select cells E3 through E11 (or E2:E11), and press ALT (or F10, or F6 two times), H, V, P (or F, or O, or K, or B, or W). Alternatively, press CTRL+V. | | Other 1. | Click cell E2, point to the fill handle in the lower right corner of cell E2, and then drag the fill handle to cell E11. | | Ribbon (4) 1. | Select cell E2, select cells E2:E11, then on the HOME tab, in the Editing group, click the Fill button, and then click Down. Alternatively, press ALT (or F10, or F6 two times), H, FI, and then D. | | Other (2) 1. | Click cell E2. In the lower-right corner of cell E2, double-click the Fill handle. | | | | | Hide Student Actions | | 5) | AC Step 3.2.1: Use the Expression Builder to Add and Modify a Field | Application: Access | Page Number: 758 | Scenario: Assessment Scenario 1 | | | Status : Unattempted | | Show All | Hide all | 1 ) Use the Expression Builder to change the Commission column to a field named Qtr 2 Commission. Modify the formula so it multiplies the Actual Sales by .03. Ribbon 1. | Click the Commission calculated field, and on the DESIGN tab, in the Query Setup group, click Builder. | 2. | In the Expression box, change the formula to read: Qtr 2 Commission: [Actual Sales]*.03 (or 0.03, or .030). | 3. | Click OK. | | Ribbon (2) 1. | Click the calculated field, and on the DESIGN tab, in the Query Setup group, click Builder. Alternatively, right-click the calculated field, and from the shortcut menu, click Build. Or, press ALT (or F10, or F6 until the Ribbon is selected), JQ, and then B (or press SHIFT+F10, and then B or CTRL+F2). | 2. | In the Expression Builder, modify the formula to Qtr 2 Commission: [Actual Sales]*.03. | 3. | Click OK (or TAB to OK and press ENTER (or SPACEBAR)). | | Keyboard 1. | Select (or click in) the calculated field, press SHIFT+F2 (or SHIFT+F10, and then Z). Alternatively, right-click in the calculated field, and from the shortcut menu, click Zoom. | 2. | In the Zoom dialog box, modify the formula to Qtr 2 Commission: [Actual Sales]*.03. | 3. | Click OK (or TAB to OK and press ENTER (or SPACEBAR)). | | Keyboard (2) 1. | Select or click in the calculated field. In the Commission calculated field, modify the formula to Qtr 2 Commission: [Actual Sales]*.03. Press ENTER. | | | | | Hide Student Actions | | 6) | AC Step 3.2.2: Use Built-in Functions | Application: Access | Page Number: 759 | Scenario: Assessment Scenario 1 | | | Status : Unattempted | | Show All | Hide all | 1 ) The employees will receive three payments instead of a single quarterly commission check. Add a new column to the query. The field should calculate the value of the payments using a rate of 0.06/3, 3 payment periods, a present value of the Actual Sales field, and 0 for the future value and type. Change the field name to Payment. Ribbon 1. | Click the first row of the first empty column of the query, and on the DESIGN tab, in the Query Setup group, click Builder. | 2. | In the left column of the Expression Builder dialog box, double-click the Functions icon. | 3. | In the left column of the Expression Builder dialog box, click Built-In Functions. | 4. | In the middle column of the Expression Builder dialog box, click Financial. | 5. | In the right column of the Expression Builder dialog box, double-click Pmt. | 6. | In the Pmt function, click the rate argument placeholder and type 0.06/3. | 7. | Click the num_periods argument and type 3. | 8. | Double-click the present_value argument. | 9. | In the left column of the Expression Builder dialog box, click the Employee Payments icon. | 10. | In the middle column of the Expression Builder dialog box, double-click the Actual Sales field name. | 11. | Click the future_value argument and then type 0. | 12. | Click the type argument and then type 0. | 13. | Press HOME to move the insertion point to the beginning of the expression and type Payment: to the left of the Pmt function. | 14. | Click OK. | | Ribbon (2) 1. | Click the first row of the first empty column of the query, and on the DESIGN tab, in the Query Setup group, click Builder. Alternatively, right-click the first row of the first empty column of the query, and from the shortcut menu, click Build. | 2. | In the Expression box, enter Payment: Pmt(0.06/3,3, [Actual Sales],0,0) (or Payment: Pmt(0.06/3,3,[Actual Sales])). | 3. | Click OK, or press TAB to select OK, and then press ENTER (or SPACEBAR). | | Right-Click 1. | Right-click in the first row of the first empty column of the query, and from the shortcut menu, click Zoom. Alternatively, press SHIFT+F2 (or SHIFT+F10, and then Z). | 2. | In the Zoom dialog box, enter Payment: Pmt(0.06/3,3, [Actual Sales],0,0) (or Payment: Pmt(0.06/3,3,[Actual Sales])). | 3. | Click OK, or press TAB to select OK, and then press ENTER (or SPACEBAR). | | Keyboard 1. | In the first row of the first empty column of the query, press ALT (or F10, or F6 until the Ribbon is selected), JQ, and then B (or press SHIFT+F10, and then B or CTRL+F2). | 2. | In the Expression Builder dialog box, press ALT+X (or TAB to select the Expression Elements column). Use ARROW keys (or press F) to select Functions. Click the plus sign to the left of Functions (or double-click the Functions icon). | 3. | Press DOWN ARROW (or B) to select Built-In Functions. | 4. | Press ALT+C (or TAB to select the Expression Categories column), and then use ARROW keys (or press F) to select Financial - optional. | 5. | Press ALT+V (or TAB to select the Expression Values column), and then use ARROW keys (or press P) to select Pmt. Double-click the Pmt function. | 6. | With the insertion point in the Expression box, use ARROW keys to select <<rate>>, and then type 0.06/3 (or .06/3). Alternatively, use ARROW keys to select <<rate>>, press DELETE (or BACKSPACE), and then type 0.06/3. | 7. | Use ARROW keys to select <<num_periods>>, and then type 3 (or 3.0 or 3.00). Alternatively, use ARROW keys to select <<num_periods>>, press DELETE (or BACKSPACE), and then type 3 (or 3.0 or 3.00). | 8. | Use ARROW keys to select <<present_value>>. Press DELETE (or BACKSPACE) - optional. | 9. | Type A (or [A) and from the auto-correct list, double-click Actual Sales (or use ARROW keys to select Actual Sales, and then press ENTER). | 10. | Use ARROW keys to select <<future_value>>, and then type 0 (or 0.0 or 0.00). Alternatively, use ARROW keys to select <<future_value>>, press DELETE (or BACKSPACE), and then type 0 (or 0.0 or 0.00). | 11. | Use ARROW keys to select <<type>>, and then type 0 (or 0.0 or 0.00). Alternatively, use ARROW keys to select <<type>>, press DELETE (or BACKSPACE), and then type 0 (or 0.0 or 0.00). | 12. | Use ARROW keys to move the insertion point to the beginning of the expression, and type Payment:. | 13. | Press TAB to select OK, and then press ENTER (or SPACEBAR). | | Keyboard (2) 1. | In the first row of the first empty column of the query, press ALT (or F10, or F6 until the Ribbon is selected), JQ, and then B (or press SHIFT+F10, and then B or CTRL+F2). | 2. | In the Expression Builder dialog box, type P and from the auto-correct list, double-click Pmt (or use ARROW keys to select Pmt, and then press TAB). | 3. | Type 0.06/3, (or .06/3, or 0.06/3.0, or 0.06/3.00, or .06/3.0, or .06/3.00,). | 4. | Type 3, (or 3.0, or 3.00,). | 5. | Type [Actual Sales])--closing parenthesis is optional. | 6. | Use ARROW keys to move the insertion point to the beginning of the expression, and type Payment:. | 7. | Press TAB to select OK, and then press ENTER (or SPACEBAR). | | | | | 2 ) Format the field as Currency and press ENTER. Revise the Payment field to add a negative sign before the Actual Sales field. Run the query. Ribbon 1. | With the calculated field selected, on the DESIGN tab, in the Show/Hide group, click Property Sheet. | 2. | In the Property Sheet, click the Format box. In the Format box, click the drop-down arrow, and click Currency. Press ENTER. | 3. | On the DESIGN tab, in the Query Setup group, click Builder. | 4. | In the Expression box, type a minus sign (-) to the left of [Actual Sales]. | 5. | Click OK. | 6. | On the DESIGN tab, in the Results group, click Run. | | Ribbon (2) 1. | With the calculated field selected, on the DESIGN tab, in the Show/Hide group, click Property Sheet. Alternatively, right-click the calculated field, and then from the shortcut menu, click Properties. | 2. | In the Property Sheet, click the Format box. In the Format box, click the drop-down arrow, and click Currency. Press ENTER. | 3. | On the DESIGN tab, in the Query Setup group, click Builder. Alternatively, right-click the calculated field (Payment) of the query, and from the shortcut menu, click Build. | 4. | In the Expression box, type a minus sign (-) to the left of [Actual Sales]. Click OK. | 5. | On the DESIGN tab, in the Results group, click Run. Alternatively, right-click in the design window (or on the query tab) and from the shortcut menu, click Datasheet View (or press H). Or, on the HOME tab, in the Views group, click the top half of the View button, or click View, Datasheet View. Or, click Datasheet on the status bar. Or, double-click the query in the Navigation Pane (or right-click and then click Open). | | Keyboard 1. | With the calculated field selected, press ALT+ENTER (or SHIFT+F10, press P two times, and then press ENTER (or SPACEBAR)). | 2. | In the Property Sheet, click the Format box. In the Format box, click the drop-down arrow, and click Currency (or press ALT+DOWN ARROW, ARROW to select Currency, press ENTER (or type C)). Press ENTER. | 3. | In the query design grid, type a minus sign (-) to the left of [Actual Sales]. Alternatively, press ALT (or F10, or F6 until the Ribbon is selected), JQ, and then B (or press SHIFT+F10, and then B or CTRL+F2). In the Expression box, type a minus sign (-) to the left of [Actual Sales] and TAB to OK, press ENTER (or SPACEBAR). | 4. | Press ALT (or F10, or F6 until the Ribbon is selected), JQ, G. Or, press ALT (or F10, or F6 until the Ribbon is selected) H, W, H (or ENTER, or SPACEBAR). Or, with the query selected in the Navigation Pane, press ENTER (or right-click and press O). | | | | | Hide Student Actions | | 7) | AC Step 3.3.1: Add Aggregate Functions to Datasheets | Application: Access | Page Number: 768 | Scenario: Assessment Scenario 1 | | | Status : Unattempted | | Show All | Hide all | 1 ) In Datasheet view, display the Totals row, the sum for the actual sales, and the average of the Payment column. Ribbon 1. | On the HOME tab, in the Records group, click Totals. | 2. | Click in the Total row of the Actual Sales column. Click the arrow, and then click Sum. | 3. | Click in the Total row of the Payment column. Click the arrow, and then click Average. | | Keyboard 1. | Press ALT (or F10, or F6 three times), H, T. | 2. | Use the TAB and/or ARROW keys to select the Total row in the Actual Sales column, press ALT+DOWN ARROW, press DOWN ARROW until Sum is selected and then press ENTER. | 3. | Use the TAB and/or ARROW keys to select the Total row in the Payment column, press ALT+DOWN ARROW, press DOWN ARROW until Average is selected and then press ENTER. | | | | | 2 ) Save and close the query. Toolbar 1. | Click Save on the Quick Access Toolbar. | 2. | Right-click the Employee Payments tab, and from the shortcut menu, click Close. | | Ribbon (2) 1. | Click Save on the Quick Access Toolbar. Alternatively, click the FILE tab, and then click Save.
Or, right-click the query tab and from the shortcut menu, click Save (or press S). Or, click the FILE tab, click Save As, click Save Object As and then double-click Save Object As (or click the Save As button). Type Employee Payments as the Query Name in the Save As dialog box. Click OK | 2. | Right-click the Employee Payments tab, and from the shortcut menu, click Close (or Close All). Alternatively, in the upper-right corner of the query, click the Close (x) button. | | Keyboard 1. | Press CTRL+S. Or, press ALT+1 (or press ALT (or F10, or F6 three times), F, S. Alternatively press F12 (or press ALT (or F10, or F6 three times), F, A, O, B, ENTER (or SPACEBAR)) . Alternatively, press ALT (or F10, or F6 three times), F, A, O, B, A. Type Employee Payments as the Query Name in the Save As dialog box. Press ENTER (or TAB to OK and press ENTER (or SPACEBAR)). | 2. | Right-click the Employee Payments tab, press C (or press C two times), and then press ENTER (or SPACEBAR). | | | | | Hide Student Actions | | 8) | AC Step 3.3.2: Create a Totals Query with Grouping and Conditions | Application: Access | Page Number: 769 | Scenario: Assessment Scenario 1 | | | Status : Unattempted | | Show All | Hide all | 1 ) In Design view, display the Total Row. Change the Commission Total row to Sum. Set the Actual Sales Total row to Where, and the Criteria of the Actual Sales value to >=10000. Run the query. Ribbon 1. | On the QUERY TOOLS DESIGN tab, in the Show/Hide group, click Totals. | 2. | Click in the Commission column Total row. Click the Group By arrow in the Commission column Total row and select Sum. | 3. | Click in the Actual Sales column Total row. Click the Group By arrow in the Actual Sales column Total row and select Where. | 4. | Type >=10000 in the Criteria row of the Actual Sales column. | 5. | On the QUERY TOOLS DESIGN tab, in the Results group, click Run. | | Ribbon (2) 1. | On the QUERY TOOLS DESIGN tab, in the Show/Hide group, click Totals. Alternatively, right-click in the query design grid, click Totals. Click in the Commission column Total row Click the Group By arrow in the Commission column Total row and select Sum. Click in the Actual Sales column Total row. Click the Group By arrow in the Actual Sales column Total row and select Where. Type >=10000 in the Criteria row of the Actual Sales column. | 2. | On the DESIGN tab, in the Results group, click Run. Alternatively, right-click in the design window (or on the query tab) and from the shortcut menu, click Datasheet View (or press H). Or, on the HOME tab, in the Views group, click the top half of the View button, or click View, Datasheet View. Or, click Datasheet on the status bar. Or, double-click Employee Commissions_All Qtrs in the Navigation pane, or right-click the query and click Open. | | Keyboard 1. | Press ALT (or F10, or F6 until the Ribbon is selected), JQ, SO. | 2. | Select the Actual Sales column Total row and type W or Where. Type >=10000 in the Criteria row of the Actual Sales column. Select the Commission column Total row and type S or Sum. | 3. | Press ALT (or F10, or F6 until the Ribbon is selected), JQ, G. Or, press ALT (or F10, or F6 until the Ribbon is selected) H, W, H (or ENTER, or SPACEBAR). Alternatively, press F6 to select Employee Commissions_All Qtrs in the Navigation pane and press ENTER ((or right-click and press O). | | | | | Hide Student Actions | | 9) | AC Step 3.3.3: Add a Calculated Field to a Totals Query | Application: Access | Page Number: 772 | Scenario: Assessment Scenario 1 | | | Status : Unattempted | | Show All | Hide all | 1 ) In the first blank column, add a new column named Time on Job that displays the difference between Now() and Hire Date. Divide the result by 365.25 to calculate the number of years the employee has worked. Ribbon (2) 1. | Click in the first row of the first empty column and type Time on Job: (Now()-[Hire Date])/365.25 and then press ENTER to create a new calculated field. Alternatively, type Time on Job: (Now()-[Employee Info]![Hire Date])/365.25 and then press ENTER. | | Ribbon 1. | Click in the first row of the first empty column of the query. | 2. | On the DESIGN tab, in the Query Setup group, click Builder. | 3. | In the Expression Builder dialog box, type Time on Job: (Now(). In the Expression Builder dialog box, click the Operators folder in the left column. In the right column, double-click the - (minus sign) icon. Alternatively, type -. | 4. | Click Employee Commissions_All Qtrs query in left column (if necessary). In the middle column of the Expression Builder dialog box, double-click the Hire Date field. | 5. | Type )/365.25 | 6. | Click OK. | | Right-Click 1. | Right-click on the first row of the first empty column of the query, and from the shortcut menu, click Build. | 2. | In the Expression Builder dialog box, type Time on Job: (Now() Type the minus (-) operator (or in the bottom left column, click the Operators folder. In the right column, double-click the Minus (-) operator). | 3. | Click Employee Commissions_All Qtrs query in left column (if necessary). In the middle column, double-click the HireDate field (or type [Hire Date]). | 4. | Type )/365.25. Click OK. | | Keyboard 1. | In the first row of the first empty column of the query, press ALT (or F10, or F6 until ribbon is selected), JQ, and then B. | 2. | Type Time on Job: (Now()-[Hire Date])/365.25 to create a new calculated field. Alternatively, type Time on Job: (Now()-[Employee Info]![Hire Date])/365.25. Press TAB to select OK, and then press ENTER (or SPACEBAR). | | Keyboard (2) 1. | In the first row of the first empty column of the query, press ALT (or F10, or F6 until ribbon is selected), JQ, and then B. Alternatively, press CTRL+F2 (or SHIFT+F10, and then B). | 2. | In the Expression Builder dialog box, type Time on Job: (Now()- | 3. | Press TAB to select the middle column, press H (or DOWN ARROW) to select Hire Date, and then and then press SPACEBAR. | 4. | Type )/365.25. Press TAB to select OK, and then press ENTER (or SPACEBAR). | | Keyboard (3) 1. | In the first row of the first empty column of the query, right-click, and from the shortcut menu, click Zoom (or press SHIFT+F10, and then Z). | 2. | Type Time on Job: (Now()-[Hire Date])/365.25 to create a new calculated field. Alternatively, type Time on Job: (Now()-[Employee Info]![Hire Date])/365.25. Click OK, or press TAB to select OK, and then press ENTER (or SPACEBAR). | | | | | 2 ) Run the query. Ribbon 1. | On the QUERY TOOLS DESIGN tab, in the Results group, click Run. | | Ribbon (2) 1. | On the QUERY TOOLS DESIGN tab, in the Results group, click the top half of the View button (or click the View button and then click Datasheet View). | | Ribbon (3) 1. | On the HOME tab, in the Views group, click the top half of the View button (or click the View button and then click Datasheet View). | | Right-Click 1. | Right-click the query tab (or in the top pane of the query design window) and from the shortcut menu, click Datasheet View (or press H). | | Right-Click (2) 1. | Right-click the query in the Navigation Pane, and from the shortcut menu, click Open. | | Keyboard 1. | Press ALT (or F10, or F6 until ribbon is selected), JQ, G. | | Keyboard (2) 1. | Press ALT (or F10, or F6 until ribbon is selected), JQ (or H), W, H (or ENTER or SPACEBAR). | | | | | | |

Similar Documents

Free Essay

Lab Report Instructions

...London School of Engineering and Materials Science Laboratory report writing instructions DEN101 - Fluid Mechanics 1 Flow Rate Measurement Experiment A. Student Student Number: 1234567 Version 2.0, 27 November 2010 Template for Word 97-2003 Abstract This document explains what is expected in your Fluids 1 lab report. The sections that should be covered are outlined and a structure you could follow is proposed. Detailed advice on how to edit the report is given. The document concludes with the marking criteria for this lab report. Table of Contents Abstract 2 1. Introduction 3 1.1. Writing 3 1.2. Editing and formatting 3 1.3. Content of the introduction 4 2. Background and theory 4 3. Apparatus 4 4. Test 4 5. Experimental procedure 4 6. Results 5 7. Discussion 5 8. Conclusions 5 9. References 5 10. Appendix A: Marking criteria 6 Introduction Before starting to write a report, you should think about what is your audience. Am I writing for colleagues who want a lot of detail how it is done, or am I writing for my boss who just wants an executive summary as he has no time for details? In general, there is not a single type of audience and we have to make our writing suitable for the detailed read, as well as the fast perusal. To understand what is required from you in this report, please have a look at the marking criteria in the Appendix. 1 Writing To......

Words: 2017 - Pages: 9

Free Essay

Lab Report

...Lab 6: How to Write a Lab Report (1) Atta, S., M. Ikbal, A. Kumar, and N. D. Pradeep Singh. 2012. Application of photoremovable protecting group for controlled release of plant growth regulators by sunlight. Journal of Photochemistry and Photobiology B: Biology 111:39-49. --This article shows that sunlight is the key requirement for plant growth. It explains how sunlight helps in releasing plant growth regulators in plants which enhances plant growth. This article is helpful for my lab report because we provided sunlight to our plants which makes their development faster. (2) Ikram-ul-Haq, Z. A., G. M. Taseer, M. U. D. Mukesh, and S. Ali. 2011. Effects of different fruit juices used as carbon source on cucumber seedling under in-virto cultures. African Journal of Biotechnology 10:7404-7408. --This article shows how fruit juices help plants to grow better because of the sugar that fruit juices contain. They used strawberry and apple juices, but they were not as good as orange and grape juices, regarding their effect on plant growth. This article is helpful for my lab report because we used orange juice to measure its effect on the growth of our plants. (3) Einset, J.W. 1978. Citrus tissue culture: stimulation of fruit explants cultures with orange juice. Plant Physiology 62:885-888. --This article shows the effect of orange juice on plant growth. It explains how using high concentrations of citric acid does not enhance the plant growth, but using...

Words: 299 - Pages: 2

Premium Essay

Lab Report

...Lab Report Using Gravitational Force as a Measurement Tool Answer the following questions about the results of this activity. Record your answers in the boxes. Send your completed lab report to your instructor. Don’t forget to save your lab report to your computer! Activity 1 Record your data from Activity 1 in the boxes below. Enter the data for the sample you used in each trial (5000 rpm, 10000 rpm, etc…) in the appropriate columns and the corresponding g-force, number of layers, and position of layers position results. You will need to use the following formula to assist with your laboratory report: • G-force =0 00001118 x radius of centrifuge arm x (rpm)2 • The radius of the centrifuge arm for this instrument is 10 cm. | | | | | | |Speed |5000 rpm |10000 rpm |15000 rpm |20000 rpm | | |2795 |1180 |2655 |4720 | |G-force | | | | | | | |4 |5 |3 | |Number of......

Words: 436 - Pages: 2

Free Essay

Lab Report

...Crowder-Gross Lab 2 Report 3-In this activity you learn open Server Manager and then see what all the different things it can do. For instance, if you are working in Active Directory, you can create a new user account, set up a shared folder, or change to a different domain. What are the topics for additional information? The topics for additional information overview of print services, migrate print servers, control printer driver security, update printer drivers, and resources for print management. Note Installation Results The results showed that the installation attempts failed. 3-3 For this section you use ServerManagerCmd.exe to install the Print Services role, query the installed roles and features, and then remove the Print Services role. ServerManagerCmd.exe is designed to help the installation of multiple servers and for the server administrator who prefers to work from the command line. Record observations about the purpose of each tab Advance tab- shows what properties are available for the network adapter Driver tab- shows detail of the driver Details tab-shows device description Resources tab- shows the range of the resources Power management- shows different ways to save power Are any resources conflicts reported? How would you solve a resource conflict? There are not any conflicts reported. 3-10 This activity is done to learn where to configure the system and user environment variables and at the same time determine which ones......

Words: 318 - Pages: 2

Free Essay

Lab Report

...To do Lab Report for Single and Double Replacement reactions : This is a formal lab report. It must be typed or written by hand with blue or black ink. Make sure that you include the following: 1. Title 2. List of Materials 3. Safety that includes MSDS risk assessment for all the materials used ( instructions were given to you already and they are in Moodle) 4. Pre-lab questions 5. Data Tables with the results obtained ( observations and predictions) 6. Post Lab: Part I : Single Replacement Reactions a. For every reaction that took place you must write the balanced chemical equation b. Which metal reacted the most? c. Rank your metals from more to least active Part II: Double replacement Reactions a. For every reaction where you observed precipitate, write the complete balanced molecular equation, the complete ionic equation and the net ionic equation; use the solubility rules to identify the precipitate and the states of matter of each substance participating in the reaction. b. Which cation produced the most number of precipitates? c. Write general rules of solubility that you observed. 7. Final Conclusion and error analysis To do Lab Report for Single and Double Replacement reactions : This is a formal lab report. It must be typed or written with blue or black ink. Make sure that you include the following: 1. Title 2. List of Materials 3. Safety that includes MSDS risk assessment for all the materials used (......

Words: 374 - Pages: 2

Premium Essay

Lab Report

...Why do we keep a lab notebook? In the ‘real world’, you will be expected to record what you do and how you do it, with the data clearly identifiable. There are 2 reasons for this: • Any scientific experiment is only considered valid if it can be repeated by someone else using your notebook. • If you develop a new product or process, your notebook becomes a legal document that can be scrutinized in a court of law, especially in cases of patent infringement. In order to meet these requirements, certain conditions must be met: • Notebooks shall have bound pages, loose-leaf and spiral bound are not acceptable. • All pages must be numbered prior to use. This will show if any pages have been removed that contained data that might compromise interpretation of your conclusions. • All data shall be entered chronologically. Do not leave empty pages to insert information later. If you finish with a large expanse of blank page, put a line through it to show that it will not be used. • All notes are to be made in indelible pen – pencil will be penalized. If you make a mistake, just draw a single line through it, not a childish scribble to hide all traces! • All data will be recorded in your lab notebook at the moment it is generated. No notes shall be written on scraps of paper or memorized for later. Other notes about the lab notebook: All pre-lab and experimental work is hand-written in your lab notebook. ......

Words: 1389 - Pages: 6

Free Essay

Lab Reports

...C8057 (Research Methods in Psychology): Writing Laboratory Reports Writing Lab Reports & APA Format Structure and Content of a Laboratory Report This following provides a brief overview of the structure and content of various elements in a laboratory report, based on APA guidelines. The APA publication manual can be referred to for more detail. The purpose of a lab report is to communicate research in a clear, systematic and standardised way. Primarily, a lab report should communicate the following things: → Why did I bother? Why did I do this experiment and why is it an interesting contribution to science? → How did I do it? How did I carry out this research (this should be detailed enough so that the experiment could be replicated precisely)? → What did I find? What were the results of your study? → So What? What do your findings mean in terms of your hypotheses and what theoretical contribution do they make? IMPORTANT! The advice that we give you in this handout is not inflexible, it is a guide! For example, when we say that the title should be fewer than 15 words, the world will not end if your title is 16 words. So, please use your common sense. In case you don’t have any, the snail of sense will appear to give you some advice. Format There are several sections to a lab report: → Title → Abstract → Introduction → Method o o o o o → Results → Discussion → References → Appendix (Optional) Title Your title should ideally be fewer than 15 words. A good title alerts the......

Words: 7238 - Pages: 29

Free Essay

Lab Reports

...04.03 Periodic Table - Lab Report Please complete the following lab report for assignment 04.03 Introduction to the Periodic Table. Take notes on the properties of the three types of elements. Metals|Good conductors of heat and electricity. Metal are ductile, and malleable. Not only have that metals also had a distinct shiny look which is called metallic luster.| Nonmetals|Poor in conducting heat and electricity generally as insulators, only at room temperature. Non-metals can be either solids or gases; they are neither ductile nor malleable. They are mainly either opaque or transparent.| Metalloids|Moderate at conducting heat and electricity, only solid at room temperature, can be ductile and malleable only to varying degrees. How at metallic luster in varying degrees.| Fill in the following data table as you complete the activity. Material|Conductivity(strong, moderate, none)|Ductility(ductile or not ductile)|Appearance(bright shine, moderate shine, or no shine)| 1|The light is bright.|Can be drawn into wire.|Shines brightly.| 2|The light is dim.|Can be drawn into wire|Shines moderately.| 3|There is no light.|Cannot be drawn into wire|Does not shine.| 4|The light is bright.|Can be drawn into wire.|Shines brightly.| Identify each of the following as a metal, nonmetal, or metalloid. Please use complete sentences to describe the observations that led you to identify each. Material 1: Metal- Because it can be drawn into wire, shines brightly, and the......

Words: 357 - Pages: 2

Free Essay

Lab Report

...Lab 1: Introduction Metric System Prefixes (to put in front of basic units): k = kilo = 1000 x c = centi = 1/100 of (which is 10-2 of) m = milli = 1/1000 of (which is 10-3 of) ( = micro = 1/1,000,000 of (which is 10-6 of) n = nano = 1/1,000,000,000 of (which is 10-9 of) (d = deci = 1/10 of ) [pic] (Note: The way to read the numbers above, for example, is: There are 1000 nm in one (m. There are 1000 (m in one mm.. etc.) To convert from one metric unit to a different metric unit (a different prefix): 1. First, decide how many places to move the decimal point (the number of 0’s in the chart above indicates the number of places to move the decimal point). 2. Next you need to decide whether to move the decimal point left or right. To decide this, think about which is the smaller unit. (The smaller the unit is, the more of them you need to get the same amount. e.g. pennies vs. dollars) NOTE: Here is another way to write the conversions, using distance (the meter is the basic unit for distance) as an example: 0.001 km = 1 m = 10 dm = 100 cm = 1000 mm = 1,000,000 (m = 1,000,000,000 nm The “staircase” method: One more way to remember about sliding decimal points when converting between prefixes in the metric system! [pic] Move the decimal point 3 places for every step you move on the “staircase”, and in the same direction traveled on the staircase (left vs. right). Unfortunately, you can see that the “c”......

Words: 1090 - Pages: 5

Free Essay

Lab Report

...Name: Gertrude Edwards Date: 12/1/2014 Instructor’s Name: Staci Lynn Assignment: SCI203 Phase 2 Lab Report TITLE: Speciation • Purpose o The purpose of this lab is to evaluate what would happen if a species within a population were suddenly split into 2 groups. • Introduction o If a population is divided indefinitely by a barrier members of the divided population will not have the opportunity to breed with each other, over years, the biotic and abiotic conditions on either side of the barrier will vary from one another. (M.U.S.E). • Hypothesis/Predicted Outcome o Based on what I’ve learned I expect that species will undergo changes if they were split into 2 different groups, some would adapt and some wouldn’t. • Methods o The methods I used in this lab came from M.U.S.E. The initial separation would consist of some species from the mainland reaching the isolated Island, then after that the isolated population would begin to diverge because of the genetic drift and natural selection, then after that overtime divergence may eventually become sufficient to cause reproduction isolation. (M.U.S.E). • Results/Outcome o As a result, Natural selection will cause different selective and adaptive pressures to occur between the two divided populations and they will evolve forever. Over time this will result in speciation which is the creation of two new species. (M.U.S.E). •......

Words: 309 - Pages: 2

Premium Essay

Lab Report

...BMS192 Lab Report marking sheet for 201360 Lab Report Marking Criteria Marks awarded Section total Abstract (4 marks) 2 Approx 2 lines introducing the topic (and aims) (1 mark) 1 Approx 2 lines for methods (1 mark) 0.5 Approx 2 lines summarising results (1 mark) 0 Approx 2 lines concluding (1 mark) 0.5 Introduction (11 marks) Note: use your text and the supplied journal articles to justify and support the development of the aims and hypothesis of the study. 5.75 What is blood pressure (BP)? (1 mark) 1 What is normal blood pressure? (1 mark) 0.5 Explain and Define mean arterial pressure (MAP) and pulse pressure (PP)and what they represent without showing their calculation (2 mark) 1 What can cause changes in blood pressure? (1 mark) 0.25 How is blood pressure regulated? (Focus mainly on the short term regulation of blood pressure, but also briefly mention long term regulation) Include the following: • What receptors detect changes in blood pressure? (1 mark) • Where is the signal transmitted? (1 mark) • What is the output and effectors? (1 mark) • What is the final result of effector action(s)? (i.e. Increased or decreased BP)? (1 mark) You do not complete your argument by including this information. 1 1 0.5 0 Aims and hypothesis. Explain what the study is testing and why (2 marks). Note: a hypothesis is a statement that you can test as being true or false so your results will either support the hypothesis or show it to be......

Words: 3522 - Pages: 15

Free Essay

Lab Report

...Lab Report Introduction: Natural selection relies upon the assumption that all organisms produce more offspring than can survive in an environment demonstration limited resources. The heritable traits that are best suited for a particular environment should be passed on at a greater frequency then those less adaptive traits. Natural selection is unique in that it leads to adaptive change, and these changes are likely to lead to increased survival and reproductive success. To sum up, natural selection is that organisms can survive only because they can suit to the changed environment which means those organisms also need to change with the environment all the time. Hypothesis: during the experiment, the forks out of all the “predators” should survive, and the peas out of all those “preys” will be survived. Material and Metnods: We will use 4 kind of beans (preys items) which are fava beans, white beans, red beans and peas. And we also have 4 mouthparts (predators) which are knives, forks, spoons and foreceps. First, we get 100 ml for each prey and spread them on the ground. And the students will be divided into 4 groups with those 4 different predators. Each group of predators include 6 student. And all of the predators will have a cup which will serve as the stomach into which the prey will be placed. We also have a timer and a security that will make sure the process is fair. Here we begin the game. The predators will be gathered, they will be instructed not......

Words: 806 - Pages: 4

Premium Essay

Lab Report

...Final Lab Report (Water Quality and Contamination) Student’s Name Course Name Institution Instructors Name Date of Submission Final Lab Report Abstract Establishing water quality was done by analyzing the chemical, physical and biological characteristics. This process helped determine safe water for human consumption in public in addition to making sure that humans are not affected by chemicals or disease causing organisms. This was done by analyzing 3 water samples which entailed Tap water, Fiji® bottled water and Dasani® bottled water. The goal of this research was to establish the effects of ground water contamination. This research necessitated hypothesizing on the capability of oil, vinegar and laundry detergent to pollute ground water in view of soil as a contributing filter of oil. Arising from the results obtained from the data analysis and observations from the experiments, conclusive evidence about bottled water was deduced and further research consideration is brought to light. Introduction Water quality was established by analyzing various characteristics which entail chemical, physical and biological. There are benchmarks of water quality set for every of these classes of characteristics. The benchmarks for water quality are advanced by (EPA) Environmental Protection Agency (2004) and (WHO) World Health Organization (2011). The quality of water taken in public was determined in the view of these benchmarks. Water quality research is significant due......

Words: 1234 - Pages: 5

Premium Essay

Lab Report

...Lab report As part of my module Nip1002 I was required to perform a set of observational skills which included; pulse, blood pressure, respirations, hand washing and urinalysis and then compare them to previous results. In this lab report I am going to discuss blood pressure in detail. Procedure * Explain the procedure to the patient and gain consent * Wash hands thoroughly following the hand wash technique to prevent the transfer of bacteria * Clean equipment e.g. blood pressure cuff and stethoscope using antibacterial wipes * Ensure the patient is comfortable and has been resting for 10 minutes * Remove tight clothing and support the arm at heart level, overestimation or underestimation can occur if it is not at the appropriate level * Ensure you have the correct cuff size for the patient or this could give an inaccurate reading * Locate the brachial artery and apply the cuff * Estimate the systolic pressure by using the radial pulse and inflate the cuff until the pulse cannot be felt. This is important to provide an estimation and avoids error in reading. * To take the patient’s blood pressure use a stethoscope and place on the brachial artery pulse and inflate 20-30 mmHg higher than the estimated systolic pulse * Immediately release the pressure using the thumb valve at approximately 2mmHg per second. If it is deflated too rapidly you may not hear the sounds accurately * The systolic pressure is the level when clear tapping......

Words: 1016 - Pages: 5

Free Essay

Lab Report

...Gustavo Duran Per#5 Making Dilutions of Concentrated Solutions Purpose: To make dilutions of concentrated solutions and report their concentration in different ways. Hypothesis: I predict that at least one of the tubes will not change color because of the little concentration it has. Materials: Balance, analytical Balance, tabletop milligram weigh paper, 7.6x7.6 cm weigh boat, 3.5”x3.5” Lab scoops cupric sulfate 5-hydrate Tubes, 15 mL, capped Tube racks for 15mL tubes Deionized water Permanent lab marker pens Tubes, glass, 13x100mm Peg racks for 13x100 mm tubes pipets, 5mL pipet pump, green Spectrophotometer, spectronic 20 D+ Procedure: ● In matrixes similar to those shown in table 3.21 and 3.22, record all your calculations and diagrams. Confirm your calculations with another person’s calculations before you begin. Draw a diagram to show how each sample is diluted. Use the equation to make the calculations. Be sure to make the columns te appropriate width for the material they will contain. ● Label all tubes with the name and concentration of the sample, your initials, and the date. Table 3.21 Dilutions of the 300x stock CuSO4 volume to be made (mL) concentration to be made (x) 5 150x 7 30x 5 15x 5 3x 4 Calculations Volume of stock to use Solution preparation diagram 1x 1. Prepare 25mL of 300-mg/mL CuSO4 solution. Mix well. Do not use previously made solutions. consider this a......

Words: 706 - Pages: 3