1 Start Access. Open the downloaded Access file named Exp19_Access_Ch10_Cap_Specialty.accdb.

     

1

Start Access. Open the downloaded   Access file named Exp19_Access_Ch10_Cap_Specialty.accdb.   Grader has automatically added your last name to the beginning of the   filename. Save the file to the location where you are storing your files.

0

 

2

You   will create an event-driven data macro that will populate a new field   automatically each time a record is added to the table.
 

  Open the Orders table   in Datasheet view, observe the data, and then switch to Design view. Add a   new field, ExpectedShipDate   with the data type Date/Time   below the OrderDate field. Save the table.

6

 

3

Create a data macro attached to the   Before Change event. Use the SetField Action   to populate the ExpectedShipDate in the table. The ExpectedShipDate will   always be five days after the OrderDate. Save the macro. Close the macro.   Save the table.

10

 

4

You   will change a value in the first record, and then move to the second record   to trigger the macro.
 

  Switch to Datasheet view of the Orders table. Retype the OrderDate in the   first record (OrderID 10248) and press DOWN ARROW.   The macro will be triggered and automatically fill in the ExpectedShipDate   with a date five days after the OrderDate.

6

 

5

Repeat the test on the second and third   records (10249 and 10250). Close the table.

6

 

6

Open   the Main Menu form in Design view. Add three buttons   below the Forms label that will open the three forms in the database: Enter Customers, Enter Orders,   and Enter Suppliers (in that order and to show all records).   Set the first one at the 2″   mark on the vertical ruler and the 1″ mark   on the horizontal ruler. Set the height of the button to 0.5” and the width to 1“. The first button should have   the caption Enter Customers   with the button named as cmdEnterCustomers.

10

 

7

Repeat the same procedure for Enter Orders and Enter Suppliers,   setting each button immediately below the one before it. For example, set Enter Orders so   that its top border is set approximately at the 2.6-inch mark, and Enter   Suppliers is set approximately at the 3.1-inch mark.

12

 

8

Add   three buttons below the Reports label that will print preview the three   reports in the database: Employees,   Orders, and Products   (in that order). Set the first one at the 2″   mark on the vertical ruler and the 4″   mark on the horizontal ruler. Set the height of the button to 0.5” and the width to 1“. The first button should have   the caption Employees   with the button named as cmdEmployees.

10

 

9

Repeat the same procedure for Orders and Products,   setting each button immediately below the one before it. Save the form,   switch to Form view, and then test the buttons. Close all objects except the   Main Menu form. For example, set Orders so that its top border is set   approximately at the 2.6-inch mark, and Products is set approximately at the   3.1-inch mark.

12

 

10

Switch   to Design view, add a Close Database   button that exits Access to the top-right corner of the form, at the 0″ mark on the vertical ruler and the 5″ mark on the horizontal ruler, with a   height of 0.5”   and a width of 1“.   Name the button cmdExit.

8

 

11

Modify the embedded macro in the On Click property of the cmdExit button. Add a MessageBox action to the macro to display the message Please check all updates before exiting!   and set the Type to Information.   Move the action up to before the QuitAccess action. Change the option under   QuitAccess from Prompt to Exit. Save and close the macro.

6

 

12

Save   the form, switch to Form view, and then set the Main Menu   form to display when the database opens. Test the Close Database   button.   Reopen the database.

4

 

13

You want to modify the records   displayed in the Employees report. You will use an SQL statement to modify   the record source so that only employees who live in London display in the   report.
 

  Open the Employees report in Design view. Open the Property Sheet and click   in the Record Source property box. Type an SQL statement into the Record   Source property of the report. The statement should select all fields (*) for employees where the City equals   (=) London. Save the report. Test the report in   Print Preview and close the report.

10

 

14

Close   all database objects. Close the database and then exit Access. Submit the   database as directed.

0

  

Total   Points

100

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

patient file

Your final project for this course will be a patient record analysis. You will apply the knowledge of anatomy, physiology, and pharmacology that you have developed during this course in a thorough review of existing patient information in the Final Project Patient File. Specifically, you will review a patient’s history

610 6-1 Discussion: Improve, Part Two—Mitigating Unwanted Consequences

 The Essential Workplace Conflict Handbook. Including the IMPROVE Supplementary Document. Next, in your initial post, address the following: • In what ways do you perceive the Improve phase as being informed by the other phases of DMAIC that you have worked with in the course thus far? • How can

Code of conduct

 For this assignment, Write a paper about employee codes of conduct using information from your textbook and at least two other scholarly sources. First, research employee codes of ethics, especially for the medical field. Next, find some examples of employee codes of ethics from medical facilities and choose the one

Human Growth and Development

Scenario: Simon Whitaker is 42 years old and has suffered from mental illness since his late teens. He lives in a flat in a large housing estate. He lost his job as a warehouse cleaner after he was admitted to hospital the last time he became ill, two years ago.

Exporting Security

Write a 2 page argumentative essay on the links provided below. Link 1: https://www.airuniversity.af.edu/SSQ/Book-Reviews/Article/1292320/exporting-security-international-engagement-security-cooperation-and-the-changi/ Link 2:https://digital-commons.usnwc.edu/cgi/viewcontent.cgi?article=1049&context=nwc-review Link 3: https://digital-commons.usnwc.edu/cgi/viewcontent.cgi?article=1049&context=nwc-review #Exporting #Security

Organizational culture and values

 Details: Prepare a 10-minute presentation (10-15 slides, not including title or reference slide) on organizational culture and values. Describe how alignment between the values of an organization and the values of the nurse impact nurse engagement and patient outcomes. Discuss how an individual can use effective communication techniques to overcome

Document Analysis

Document Analysis (5% – c. 500 words) Primary sources are writings that were produced by individuals or groups at the time of the historical events or issues that they deal with. A number of such documents have been placed on Blackboard, organized by course unit. This assignment requires you to

M3D1: Big Data

The discussion will examine the social interaction of participants regarding an issue or situation and its impact on research data. This discussion addresses the following module outcomes: •MO1: Become familiar with the process of conducting marketing research methods and research tools •MO2: Review the process marketers use for identifying and

Case Study 1 and 2 Pneumonia and Addison diseases

Review the case study and answer all questions with a scholarly response using APA and include 2 scholarly references. Answer both case studies on the same document and upload 1 document to Moodle. Case Studies will be uploaded to Moodle and put through TURN-It-In (anti-Plagiarism program) Turn it in Score

Should schools ban unhealthy snack machines?

 Your outline should include: An explanation of the controversial issue, why is it controversial? Identify which position or side you will take in your paper, and explain why. If you don’t agree with the position you are taking discuss how this could affect your argument on the topic. If you

The Outcome of Inequality of Wealth and Income

Research Topic: Submit an idea for a research study based on a business/economic problem. • Write the title of the study. • Explain your overarching aim for the study. • What is the problem? • What is the significance of it? • Draft at least two research questions. Due 1/27

“practice of professional engineering”

1. “practice of professional engineering” means any act of planning, designing, composing, evaluating, advising, reporting, directing or supervising that requires the application of engineering principles and concerns the safeguarding of life, health, property, economic interests, the public welfare or the environment, or the managing of any such act; (“exercice de

Curriculum Development and Evaluation

 Learning Materials: Keating, S. B. (2011). Curriculum development and evaluation in nursing (2nd ed.). New York: Springer. (Chapter 13) Books are on website Vital Source user name is sred9196@yahoo.com, the password is Bungalow9@ • Exercise #1: Address an educational need among nursing staff at a health care agency. In the

Epidemiology and Surveillance

Research the public health agency in Chicago, IL and develop a presentation on its structure, response capabilities, surveillance tools, and role in emergency management. In your response, include a description of the community served by the department (Chicago), its emergency response structure, surveillance systems that are used at hospitals, biohazard

General Psychology Application

 General Psychology Application Essay Over the course of the class, we have discussed a number of different psychological concepts and theories. For your paper you will be asked to connect a real life experience or observation with a concept or theory from lecture and/or your textbook. Your assignment should include

Issues and Trends in Curriculum Development

 Learning Materials: • Iwasiw, C., Goldenberg, D., & Andrusyszyn, M. (2009). Curriculum development in nursing education (2nd ed.). Boston: Jones & Bartlett. (Chapters 13 and 14) • Keating, S. B. (2011). Curriculum development and evaluation in nursing (2nd ed.). New York: Springer. (Chapters 16 and 17) PowerPoint • Chapter 13

Foundation of Nursing Module 2.1 ( Discussion)

Module 2.1 – Discussion Nursing Theories and Theorists Instructions: After reading the assigned chapters, please post two discussion questions based on the readings along with your answers to the following questions: Did any of the theories or theorist influence your own personal theory of nursing; and consequently, your own view