Microsoft Office 2010 A Skills Approach 1st Edition

  • Authored by verified experts
  • Available on iOS, Android & web
Chapter: Problem:
0 Stars(0 users)

You are a botany professor who was recently placed in charge of maintaining the department’s greenhouse. You have inherited an Access 2010 database from the previous greenhouse supervisor. This database contains records of the plants in the greenhouse and the employees that assist you with maintenance duties. Become comfortable with the department’s database by completing the exercises below. Please note: For any step that contains a question, your instructor may require a written response.

1. Open the greenhouse.accdb student file and save it as [your initials] AC_Challenge_1-3.

2. Write down the names of all the objects present in this database. Which three objects appear grouped together after selecting the Tables and Related Views option?

3. Open the Employees table and switch to Design view. Which of the five fields contains text in the Description area?

4. Switch to Datasheet view and browse the records using the record navigation buttons and keyboard shortcuts.

5. Enter the following record into your table and note that the Position field is a lookup field.







> Tracy

> Seidel

> Greenhouse Tech 2

> 15

6. Find the record with a LastName of Rojas and change the WeeklyHours from 35 to 30.

7. Delete the record with an EmployeeID of 23605379.

8. Close the Employees table and open EmployeesForm.

9. Enter the following record into your form:







> George

> Phillips

> Greenhouse Tech 2

> 20

10. Find the employee named Gary and edit his last name so that it reads Mills. 1 1. Delete the record of the employee named Dale Barnes.

12. Close the EmployeeForm.

13. Observe the file size of your database. Use the Compact&Repair Database feature and check the file again. How much did the file size decrease?

14. Create a backup of this database using the default name chosen by Access.


    We do not have a solution to this problem yet.
    Use the dropdowns to view one of the
    other 72 solutions to this book.

    Or you can ask a question about this problem.

What is Chegg Study?

With Chegg Study, you get step-by-step solutions for odd and even answers at the back of the book Microsoft Office 2010 A Skills Approach - 1st Edition and 2,500 others.
Chegg Study authors: Publishers, professors and post-grads
Textbook authors: Cheryl Manning
ISBN: 0073516473
ISBN-13: 9780073516479
View all editions
81% of students said using Chegg better prepared them for exams
2013 Chegg Homework Help Survey
  • Where do solutions come from?
  • What comes with membership?
  • What subjects are covered?

Step-by-step solutions for this book and 2,500 others
Already used by over 1 million students to study better

Get Study Help from Chegg
