25.10 Questions

---

25.9 Exercises

1. Open the Office.dwg file in the C:\Steps\Lesson25 folder. Follow these instructions:

   1.1  

   DbConnect AutoCAD to the Technology.mdb database in the C:\Steps\Lesson25 folder. (The database file is an MS Access file.)

   1.2  

   Create links between the Office Unit (link to the desk) and the Employee (use the Employee table) and between the Office Unit (link to the computer on the desk) and the Computer (use the Computer Equipment table):

   OFFICE UNIT	EMPLOYEE	COMPUTER
   1	Starbuck	8
   2	West	3
   3	Brezina	1
   4	Miles	4
   5	Dominic	6
   6	Whitson	9
   7	Paul	7
   8	Harrington	5
   9	Aloysius	2

   1.3  

   Label each cubicle with the name of its occupant. (Use Freestanding Labels.) Your drawing looks like Figure 25.9.1a.

   
   Figure 25.9.1a: Labeled Office Drawing

   1.4  

   Answer the following questions:

   1.4.1	Where does the Lead Programmer sit?
   1.4.2	Where does the COO sit?
   1.4.3	AutoCAD requires a minimum of 32Mb of RAM. Who among the CAD Operators will need an upgrade? (Save the query as ram_upg.)
   1.4.4	Everyone hired before January of 1984 will be receiving a large Christmas bonus. Can you locate the recipients by cubicle for the mailman? (Save the query as bonus.)
   1.4.5	Santa Claus will upgrade all of the Pentium II chips to Pentium IIIs over the holidays. Tell him which cubicles to visit. (Save the query as santa.)
   1.4.6	Everyone with less than 32Mb of RAM and a slower CPU speed than 400MHz will receive a new computer. How many will be needed and where will they go? (Save the Query as New.)
   1.4.7	Which units have computers that use a modem (-1 indicates a "yes" column)? (Save the Query as modems.)
   1.4.8	What kind of computer does the lead engineer use? How fast is it?

   1.5  

   Export the templates and queries to the C:\Steps\Lesson25 folder.

   1.6  

   Remove the connection between AutoCAD and the Technology.mdb database.

   1.7  

   Remove the Data Source you created from the Windows Operating System.

   1.8  

   Save the drawing as MyOffice.dwg in the C:\Steps\Lesson25 folder.

---