Results 1 to 3 of 3
  1. #1
    krobbyzw is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2014
    Posts
    2

    Access 2010 Year Timeline of World History

    Dear All



    I have looked through the timeline queries so far on your forum and have not found an answer to this one yet. I wondered if it is in fact beyond the scope of a desktop based database application.

    I have recently been working on an educational project in Excel in which I have listed all the years from 3760BC to 2050 AD on the far left hand column.
    Subsequent columns have the countries of the world in alphabetical order.
    This enables concurrent country timelines of world history that multiple history students may add to on a shared network.

    I understand, however, that once an Excel spreadsheet becomes more than 10MB in size (currently 8MB), it becomes unwieldy in Excel and have been advised to upgrade the project to a database.

    My question is:
    is this idea indeed beyond the scope of a database? I have an idea of how to set up a Primary Key for the years, eg 201401312000 equal to 8PM on 31 Jan 2014.
    However, when incorporating BC dates, eg 2014BC, will Access be able to keep all of the BC dates and AD dates together? Is it a simple solution of having an AD table and BC table?

    I have a sample in Excel that I may send any interested people.
    Many thanks for your time.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    The spreadsheet setup is not a normalized data structure. There is a limit of 255 fields in Access table. There are 193+ countries, depending on how you define a country (the Vatican, Taiwan).

    Table in Access would be like:

    tblEvents
    ID
    EventDate
    EventDescription
    EventCountry

    Appears Access cannot handle dates prior to 6/1/1352 and could not use a date/time field type so your alternate text date convention may be reasonable. Or perhaps each date part in separate number field. Need to also have a suffix (or another field) for the AD/BC. Either way, calculating elapsed time between two dates would be complicated if you wanted to calculate fractions of year.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    krobbyzw is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2014
    Posts
    2
    Thank you very much! Will see how I get on.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. New to Access world
    By tigwebu in forum Forms
    Replies: 3
    Last Post: 10-30-2012, 12:17 PM
  2. Report Timeline
    By brownk in forum Reports
    Replies: 3
    Last Post: 05-31-2012, 02:53 PM
  3. Replies: 10
    Last Post: 12-18-2011, 12:04 PM
  4. Timeline View in Access
    By brettbarton in forum Forms
    Replies: 1
    Last Post: 11-08-2011, 07:35 PM
  5. timeline form
    By barkarlo in forum Programming
    Replies: 0
    Last Post: 08-07-2010, 12:39 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums