INF 110 Challenges Chapter 3 Access  VBA Programming

Challenges Chapter # 3          Access 2007 User Instructions      Access 2010 & 2013 User Instructions
Challenges 2 & 3 Page 80 Access VBA Programming Textbook - In-Chapter work p 60 Light Switch Form: Download Light On/Off Graphics

General Guidelines: Do steps 2 & 3 on page 80 to produce a single database named challengesChapter3AccessLastName.accdb with 2 forms, one for each of the challenges; for challenge 2 the form should be named Calculator Program, for challenge 3 name the form Discount Book Program.

Structure charts: Be sure to create a structure chart for each of the challenges (2-3) on page 80 in the Access textbook by using the PowerPoint hierarchy chart tool. Steps:(Click the Insert Tab, Click Smart Art Icon in Ribbon, click on Hierarchy in the left pane, choose the hierarchy type diagram, edit the text in the rectangles to reflect your programming steps) You could revise the structure chart from slide 27 in Excel 2 PowerPoint to create the necessary structure chart for challenge 2. Use some of the same shape symbols in challenge 3 to create the structure chart. Save the structure chart slides in a PowerPoint file named StructureChartsChallengesChapter3AccesslLastName.pptx.
Structure Chart challenge 2 page 80 (See video) (Download video) 
 Structure Chart challenge 3 page 80 (See video) (Download video)

Send me this file as an email attachment at least 3 days before the assignment is due so that I can check it for you. Submit this file in Blackboard together with your Access and Word files, as indicated in the directions at the bottom of this page.

Hints and corrections:

  1. In step 2 on page 80, use the add button program in chapter 3 on pages 65 & 66 as a guideline. Replace the = sign command button with 4 buttons containing +, -, *, and / for each of the 4 math operations. Change the Caption property of the lblDirections control from "Add Two Numbers" to "Choose Math Operation". When a command button is clicked change the Caption property between the two text boxes from "+" to "+, -, *, and /" depending on which command button was clicked. See the screen-shot listed below for the sample interface:

    Use the following property settings for the controls to be added to Calculator Program form :
    (+ command button)

    Name:

    		 cmdAdd

    Caption:

    		  +

    Picture:

    		 None
    (- command button)

    Name:

    		 cmdSubtract

    Caption:

    		  -

    Picture:

    		 None
    (* command button)

    Name:

    		 cmdMultiply

    Caption:

    		  *

    Picture:

    		 None
    (/ command button)

    Name:

    		 cmdDivide

    Caption:

    		  /

    Picture:

    		 None
    (first textbox)

    Name:

    		 txtNum1
    (second textbox)

    Name:

    		 txtNum2
    (top label)

    Name:

    		 lblDirections
    (label between textboxes)

    Name:

    		 lblMathOperator
    (answer label)

    Name:

    		 lblOutputs
    Use Boldface and font-size 14 for all the controls on the form


    Outputs to Word Document: (Access Chapter 3 Challenges.docx)
    Create a new Word document called Access Chapter 3 Challenges.docx and type in ("    Access Chapter 3 Challenge 2") as the first line of the document. Run the Calculator Program form in Access for the multiplication operation using the data in the above screen-shot, press the Print Screen key on the keyboard to get a copy of the screen-shot onto the clipboard, paste the screen-shot into the Word document. Start a new page in your Word document and copy and paste the code from the Calculator Program form in Access to the 2nd page of the Word Document.

     

  2. In step 3 on page 80, use the numbers listed in the screen-shot listed below for the Discount Book Program. To get the final cost add the discount price and the sales tax amount.



    Use the following property settings for the controls to be added to Discount Book Program form :
    Table of controls properties go from top to bottom and left to right as the controls are positioned on the form.
       

    Discount Book Program Form Controls Properties

    Name: lblInitialBookPrice - Caption: initial book price: Name: txtInitialBookPrice
    Name: lblDiscountRate - Caption: discount rate: Name: txtDiscountRate
    Name: lblSalesTaxPercentage - Caption: sales tax percentage: Name: txtSalesTaxPercentage
    Name: lblDiscountPriceLabel - Caption: discount price: Name: lblDiscountPriceValue - Caption: " "
    Name: lblSalesTaxAmountLabel - Caption: sales tax amount: Name: lblSalesTaxAmountValue - Caption: " "
    Name: lblFinalCostLabel - Caption: final cost: Name: lblFinalCostValue  - Caption: " "

    Name: cmdCalculateFinalCost - Caption: Calculate Final Cost - Picture: None

    Note:  Make the labels used for the outputs look like TextBoxes by setting the following properties:
    Back Style: Normal - Back Color: 16777215 (White) - Border Style: Solid

    Outputs to Word Document: (Access Chapter 3 Challenges.docx)
    Start a new page in your Word document called Access Chapter 3 Challenges.docx and type in ("Access Chapter 3 Challenge 3") as the first line of the 3rd page. Run the Discount Book Program form in Access and type in the numbers listed in the screen-shot above, press the Print Screen key on the keyboard to get a copy of the screen-shot onto the clipboard, paste the screen-shot into a Word document. Start a new page in your Word document and copy and paste the code from the Discount Book Program form in Access to the 4th page of the Word Document.

Students should submit the electronic versions of the four files using the drop box in Blackboard, send the  PowerPoint file with the structure charts for the challenges named (

Students should submit the electronic versions of the four files using the Assignments link, send the  PowerPoint file with the structure charts for the challenges named (StructureChartsChallengesChapter3AccesslLastName.pptx), the database file for the challenges named (challengesChapter3AccessLastName.accdb),  the Word document (Access Chapter 3 ChallengesLastName.docx) together with the In-Chapter work from this chapter (In-Chapter3AccessLastName.accdb), the forms in the In-Chapter database file should use the following names (Page50FormEvents, Page58FormsCollection, Page60LightOnOff, Page63Colors, Page65AddTwoNumbers), substitute your last name for LastName listed in file names above

Number of pages required in Word document: 4

Note: Steps to submit your work: Submit the four files by clicking on the Assignments link in the left pane then click Exer8 link in the right pane, Choose the challengesChapter3AccessLastName.accdb  database, add another file named Access Chapter 3 ChallengesLastName.docx, add another file named StructureChartsChallengesChapter3AccesslLastName .pptx, then click Submit.
Note: The Word Document, the Structure Charts, and the Challenges database are all submitted under the Exer8 link.

 

Next click on the InChap8 link. Choose the In-Chapter3AccessLastName.accdb database, then click Submit.