Analyze the business activity

Assignment Help Database Management System

Reference no: EM13756203

Data Files needed for this Case Problem: OBrien.accdb (cont. from Tutorial 3) and Tests.bmp O'Brien Educational ServicesKaren O'Brien is using the OBrien database to track and analyze the business activity of her educational consulting company. To make her work easier, you'll create a form and report in the OBrien database. Complete the following-

1 . Open the OBrien database you created and worked with in Tutorials 1 through 3, and then click the Enable Content button next to the security warning, if necessary.

2. Create the form shown in Figure

3 Using the form you just created, navigate to the second record in the subform for the third main record, and then change the Assessment Complete field value to yes.

4. Use the Find command to move to the record for Samuel Glick, and then Chan the value in the Groups Only field to no.

5. Use the appropriate wildcard character to find all records with a Hire Date field value that begins with the month of March (3). Change the Hire Date field value for Alameda Sarracino (Tutor ID 51-7070) to 3/27/2016. Save and close the form.

6. Create the report shown in Figure 4-30.

7. Scroll to the bottom of the report; note that the page number might not be completely within the page border (the dotted vertical line). If necessary, select and move the box containing the text "Page 1 of 1" until the entire text is positioned to the left of the dotted vertical line marking the right page border.

8. Preview each page of the report, verifying that all the fields fit on the page. If necessary, return to Layout view and make changes so the report prints within the margins of the page and so that all field names and values are completely displayed.

9. Save the report, print its first page (only if asked by your instructor to do so), and then close the report.

10. Compact and repair the OBrien database, and then close it.

Reference no: EM13756203

Questions Cloud

Cyber security triad : Choose a threat that targets one of three categories of the cyber security triad: Confidentiality, Integrity or Availability. Using the posted instructions for writing a white paper

Theories of crime causation and non-sharable problems : Theories of Crime Causation and Non-sharable Problems" Please respond to the following:

Why was spanish empire based on economies of exploitation : Why was the Spanish Empire based on economies of exploitation?

Sarbanes-oxley act and sec reporting requirements : Based on the requirements of the Sarbanes-Oxley Act and SEC reporting requirements for publically traded companies,

Analyze the business activity : Data Files needed for this Case Problem: OBrien.accdb (cont. from Tutorial 3) and Tests.bmp O'Brien Educational ServicesKaren O'Brien is using the OBrien database to track and analyze the business activity of her educational consulting company. T..

How did feudalism bring about social order in europe : How did feudalism bring about social and political order in Europe during the middle ages?

Number of impediments to project success : Exhibit 18.2 of your textbook lists a number of impediments to project success. How might you minimize or eliminate these impediments?

What john winthrop saying in his sermon of christain charity : What was John winthrop saying in his sermon A Model of Christian Charity? Like what was the main point he was trying to get across?

Define and discuss osteoporosis : Define and discuss osteoporosis. Include in your discussion information on how osteoporosis develops; how age, sex, hormones, and genetics affect it; how activity affects it; and what dietary interventions can help prevent or treat osteoporosis.

User Account

All Pages