This preview shows page 1. Sign up to view the full content.
Unformatted text preview: d look something like what is shown in Figure 6-13. Notice that in addition to the Alternate Hierarchies Menu there is another object on the screen behind this menu. To see this object, click on its header. Your screen should then look something like Figure 6-14. This is what is called a database window . It allows you direct access to everything in the database. The reason you will need access to the tables in the hierarchy database is that it is much easier to copy an existing hierarchy table into the database than to create a new one from scratch. Also, you will need to export your alternate hierarchies into Figure 6-13. Alternate Hierarchies Menu. Figure 6-14. Database window showing hierarchy tables. Page 158 the example project database, and this process requires that the database tables be visible. If the Hierarchies database window does not show the two hierarchy tables named OBS and WBS (as shown in Figure 6-14), then click on the Tables tab at the upper left corner of the Hierarchies database window. Then your screen should look like Figure 6-14. To see what is contained in the OBS table, click on the OBS table object in the database window, and then click on the control button labeled Open at the right side of the database window. A spreadsheet- style table should appear that looks like Figure 6-15. To exit this table and get back to the database window, just click on the little control button at the upper right-hand corner of the OBS table window with an "X" in it. Suppose you want to add a third hierarchy to the Hierarchy database. You could open the WBS table object and look at its structure and then create a new database with that structure. Instead, we will show you how to simply make another copy of the WBS table. Figure 6-15. OBS Table for example project. Page 159 To do this, click on the File button at the top of the Access window. Then select the Save As Export option on the File menu that drops down. This will cause the Save As window to appear, as shown in Figure 6-16. There are two buttons you can select from on the left side of this window. Select the lower one, titled Within the Current Database as , and then type "Old WBS" into the New Name field below. Finally, click on the OK button at the upper right of this window. You should now see the database window as shown in Figure 6-17 and that you now have a copy of the WBS table in the hierarchy database named "Old WBS." Clearly, the Old WBS table is merely a copy of the WBS table. Figure 6- 16. Save As window. Figure 6-17. Database window showing revised hierarchy tables. Page 160 Now that you have a copy of the WBS table called Old WBS, we will explain how you can edit the WBS table to make it into yet another hierarchy table. There are two different ways. If you are familiar with Microsoft Access, you can click on the Open control button on the right side of the database window. A spreadsheet version of the table will appear that you can edit in much the same way you would edit a Microsoft Excel spreadsheet. The other way is to use the WBS Entry/Edit tool that you are already familiar with. A copy of this tool is also...
View Full Document
This note was uploaded on 01/11/2011 for the course ACC 9 taught by Professor Yeetan during the Spring '10 term at Sunway University College.
- Spring '10