Scroll the Field name dropdown and see for yourself.īy inserting or really unhiding columns you can see more of the information in the view you are looking at. Insert is really not a good name: you unhide a column since the table in this case have hundreds of columns. If you right click a column you can in the contextual menu select Insert Column and Hide Column. So, if you go searching for the field, you need to find the column Name. If you for example double click the title Task Name you can see that the column is really called Name and that Task Name is just the label. Observe that the Title is the name which is displayed while the field name is the name in the database.
If you double click the column name you can see which column is displayed and how it’s displayed. If you look at this table you can see that the table has a number of columns and a number of rows. In most cases some of the columns are also visible, like in the Gantt Chart: If you look at a view (this concept was discussed in Part 6) like Gantt chart view, the view is based on a table in the database.
Right now, that is not important, but if you’re into details you can start exploring the database.įor normal users, you can work from inside Microsoft Project. But you cannot see the connections and you cannot see how the different columns are calculated. Microsoft Project is based on a JET database and if you export the thing to Microsoft Access (you can use File->Save As and select that) you can see which tables and columns are present in the database. And since I come from the database world, I started exploring the database. When I first started using Microsoft Project, I could not understand how the thing worked.