The attached EXCEL table (Sheet1) is a “flattened” version of a relational database. This would normally be generated as a query from the actual database, which is currently an EXCEL workbook, but this one was made by hand for test purposes to avoid being distracted by the details of the database.
I want to generate a WORD document with a section (new page) for each
Object. (An
Object is a work of art, drawing, painting, sculpture etc). At the top of the section is the fixed singular data for the object:
Artist,
Title,
Year,
Dimensions and
Materials.
Then there is a section headed Exhibitions, which lists all the
Exhibitions (if any) in which the
Object has appeared, in chronological order of (first)
Start date, giving the name of the
Exhibition and the
Catalogue_nr of this
Object at that
Exhibition. If the
Object has never been exhibited then the text “No exhibition record” should be entered instead.
For each
Exhibition there is a list of
Locations with
Start and
End dates, in chronological order of
Start date. There will often only be one
Location, but touring exhibitions can have several. The first one should appear on the same line as the
Exhibition details, and others on subsequent lines with blanks or ditto marks for the
Exhibition details.
The attached WORD file is a start, but not complete.
The rules are:
- Object_id is a unique identifier (key) for Object. Artist, Year, Title, Dimensions and Materials are attributes of Object. These are not unique over the table as a whole (distinct Objects could be called “Untitled” and have the same Date, Materials and Dimensions).
- An Object may appear in zero or more Exhibitions. Exhibition_id is a unique identifier for Exhibition, in case two distinct exhibitions have the same name.
- More than one of our Objects may appear in the same Exhibition. They each have a Catalogue_nr, which is unique for the Object at that Exhibition (there is no requirement to check this).
- An Exhibition takes place at one or more Locations (there should be an error message if there is no Location data). Location_id is a unique identifier for the Location, in case the names are the same (though that is unlikely). The Start and End dates define the relationship between Exhibition and Location. (Dates would not overlap, but there is no requirement to check this).
Who can rise to this challenge and show me how to make this simple example work on my computer, with Mac OS X 10.11.1 and Microsoft Office for Mac 2011 version 14.5.8?