I don´t know to raise my database

[jealindgar]

Hello from Spain (sorry for my poor english)
My database will be about Marilyn Monroe´s photos and I have this information:
* MAIN CATEGORY (Events, Movies, etc.)
* MAIN SUBCATEGORY (Events = Acts, Charity, etc.; Movies: All about Eve, Some like it hot, etc.)
* FOLDER (Events = Charity = 1957-April in Paris)
* MAIN CODE (Events = Charity = 1957-April in Paris = 57ECHAIP)
* and GENERAL INFORMATION (Date, Country, Description, Photographer, Designer, etc.)

One folder contain, for example, five photos... then
EVENTS\CHARITY\1957-APRIL IN PARIS:
57ECHAIP#001
57ECHAIP#002
57ECHAIP#003
57ECHAIP#004
57ECHAIP#005

How do I do all this in a database?

thanx a million!

WindowsXP
Access 2007 (testing) if not Access 2003

 

[statsman]

It sounds like you are trying to put together a catalogue of your photos. If this is the case, it’s a relatively simple task.

Essentially you only need one table. The fields should be:

Catalogue Number: Set to AutoID unless you already have a system of catalouging your photos, then use text or number as appropriate.

Category: Set to text. It would contain the categories you wish to use. Examples: Movies, Candid, Publicity, Events etc.

Movie: Set to text. Contains the name of the movie if applicable.

Event: Set to text. Contains the name of the event (if not a movie)

Year: Set to text. The year the photo was taken.

Location: The location on your computer where the picture is located. Example:
C:/MarilynMovies/RNR (for River Of No Return).

Other Info: Set to memo. Contains the photograher, location taken and any other relevant info.
Note: you may wish to enter additional fields if you would like (for example) to keep track of the specific photographers or the specific events. Create extra specific fields if you are going to want to track down a picture based on this data (example, all photos taken by a specific photographer).

When you have entered your data, you can then create queries to access it. For example create a query called “YearQuery”. Using the query wizard enter all the fields in the table. In the Year field, in the Criteria box enter [Enter Year:] square brackets required. When you run the query it will prompt you for the year. Enter an appropriate year that has records entered for that year. All of the photos from that year will be presented on the screen. You can create a separate query for any individual field or combination of fields you wish to access your data.

 

[jealindgar]

In fact statsman, I want to catalogue my photos.
But my system it´s more difficult, I have an example of my old database here

http://farm2.static.flickr.com/1404/942084614_6b5c4b2031_o.jpg or http://farm2.static.flickr.com/1351/896641509_230129e6fe_o.jpg

 

[statsman]

Sorry, I didn't realize it was such a complicated task.

 

[jealindgar]

Perhaps you have reason, I never had seen it thus

 

[Moniker]

All you've done is made it overly complex for no reason. Sorry for being harsh, but there's no reason that simple relationships won't work. Look at how IMDB and Amazon work. Both are absolutely massive DBs, and both are fairly simple in their design (not talking List Mania, etc., but rather the backend design of how they work.)

Even Google is just a DB.

I have a feeling you are making this way more complicated than it should be. The suggestion you've been given is the solution (from statsman), and if you're wanting a professional level DB, well, those aren't free. (They still aren't as complex as you're making it out to be though.)

 

[jealindgar]

i agree with both