Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

So Lost!!!!!!

Discussion in 'Information Technology' started by Scooper2241, Nov 11, 2005.

Tags:
  1. Scooper2241

    Scooper2241
    Expand Collapse
    Guest

    I am starting a data base from scratch for a library of thousands of
    video tapes. The company I work for is broken up into many different
    departments and groups. The videos need to be sorted into the appropriate
    category for which I created a combo box field with the names of the
    different departments. The fields that accompany them are mostly the same
    (Date, Program
    Title, Footage Type, Agenda and the big one which i assigned ten separate
    fields for, SPEAKERS).
    Earlier it was said that I should create a new table for speakers but I am
    totally confused as to the layout? I know that any given video may have many
    speakers (if so do i need a field for each speaker or do they get their own
    record?) and that I need to be able to reference all the videos one person
    made a speech at and vice versa what speakers are on a particular video?
    Should their be a table for the program names them self? How many tables do
    I need to do this?
    In the end to keep this monster together and organized I need a way to have
    everything divided into the categories. Because their are so many categories
    the tapes can't just be labeled 1,3,4,5 or they would all just get grouped
    together. Instead the department has it's own section on the shelf so what I
    want is a key that identifies the department and the tape number starting
    with 1 and going up for each department.
    Is this possible? and if so how can it be done!!!????
    P.S. Microsoft does not have any blank video templates for Access 2002

    Can anyone help?
    Can anyone help me? AAAHHHHHUUUUGGGGGHHHH the pain!!!!
     
  2. Loading...

    Similar Threads Forum Date
    Lost Treasures Of The Sikh Kingdom - BBC Documentary History of Sikhism May 28, 2016
    lost patrol Blogs Oct 16, 2015
    Self lost patrol Blogs Oct 11, 2014
    Heritage Lost Treasures of the Sikh Kingdom History of Sikhism Nov 21, 2014
    Malaysia Second Malaysian Plane Lost in only 4 months! Breaking News Jul 18, 2014

  3. Rick B

    Rick B
    Expand Collapse
    Guest

    Microsoft DOES have the templates mentioned. They are in Access 2000 format
    (which will work just fine with any later version).

    I would think they will work just fine with VERY LITTLE modification. Your
    "speakers" would replace actors in the database as it is designed.

    Any of the following would probably be excellent starting points...

    Music collection database:
    http://office.microsoft.com/en-us/templates/TC010186291033.aspx?CategoryID=CT011366831033


    Book collection database:
    http://office.microsoft.com/en-us/templates/TC010186431033.aspx?CategoryID=CT011366831033


    DVD collection database:
    http://office.microsoft.com/en-us/templates/TC010186441033.aspx?CategoryID=CT011366831033


    --
    Rick B



    "Scooper2241" <Scooper2241@discussions.microsoft.com> wrote in message
    news:D0119B10-31C6-4BD2-B168-12F680712E27@microsoft.com...
    >I am starting a data base from scratch for a library of thousands of
    > video tapes. The company I work for is broken up into many different
    > departments and groups. The videos need to be sorted into the appropriate
    > category for which I created a combo box field with the names of the
    > different departments. The fields that accompany them are mostly the same
    > (Date, Program
    > Title, Footage Type, Agenda and the big one which i assigned ten separate
    > fields for, SPEAKERS).
    > Earlier it was said that I should create a new table for speakers but I am
    > totally confused as to the layout? I know that any given video may have
    > many
    > speakers (if so do i need a field for each speaker or do they get their
    > own
    > record?) and that I need to be able to reference all the videos one person
    > made a speech at and vice versa what speakers are on a particular video?
    > Should their be a table for the program names them self? How many tables
    > do
    > I need to do this?
    > In the end to keep this monster together and organized I need a way to
    > have
    > everything divided into the categories. Because their are so many
    > categories
    > the tapes can't just be labeled 1,3,4,5 or they would all just get grouped
    > together. Instead the department has it's own section on the shelf so what
    > I
    > want is a key that identifies the department and the tape number starting
    > with 1 and going up for each department.
    > Is this possible? and if so how can it be done!!!????
    > P.S. Microsoft does not have any blank video templates for Access 2002
    >
    > Can anyone help?
    > Can anyone help me? AAAHHHHHUUUUGGGGGHHHH the pain!!!!
     
  4. xRoachx

    xRoachx
    Expand Collapse
    Guest

    Another suggestion:

    Please do not post the same question multiple times in multiple threads.
    This is generally frowned upon as it can be confusing trying to help you
    through mutliple posts as Rick B has. :)

    "Scooper2241" wrote:

    > I am starting a data base from scratch for a library of thousands of
    > video tapes. The company I work for is broken up into many different
    > departments and groups. The videos need to be sorted into the appropriate
    > category for which I created a combo box field with the names of the
    > different departments. The fields that accompany them are mostly the same
    > (Date, Program
    > Title, Footage Type, Agenda and the big one which i assigned ten separate
    > fields for, SPEAKERS).
    > Earlier it was said that I should create a new table for speakers but I am
    > totally confused as to the layout? I know that any given video may have many
    > speakers (if so do i need a field for each speaker or do they get their own
    > record?) and that I need to be able to reference all the videos one person
    > made a speech at and vice versa what speakers are on a particular video?
    > Should their be a table for the program names them self? How many tables do
    > I need to do this?
    > In the end to keep this monster together and organized I need a way to have
    > everything divided into the categories. Because their are so many categories
    > the tapes can't just be labeled 1,3,4,5 or they would all just get grouped
    > together. Instead the department has it's own section on the shelf so what I
    > want is a key that identifies the department and the tape number starting
    > with 1 and going up for each department.
    > Is this possible? and if so how can it be done!!!????
    > P.S. Microsoft does not have any blank video templates for Access 2002
    >
    > Can anyone help?
    > Can anyone help me? AAAHHHHHUUUUGGGGGHHHH the pain!!!!
     
  5. Scooper2241

    Scooper2241
    Expand Collapse
    Guest

    When i try and download the template it tells me Access 2002 not found and
    when i downloaded it anyway it would not open in 2002

    "Rick B" wrote:

    > Microsoft DOES have the templates mentioned. They are in Access 2000 format
    > (which will work just fine with any later version).
    >
    > I would think they will work just fine with VERY LITTLE modification. Your
    > "speakers" would replace actors in the database as it is designed.
    >
    > Any of the following would probably be excellent starting points...
    >
    > Music collection database:
    > http://office.microsoft.com/en-us/templates/TC010186291033.aspx?CategoryID=CT011366831033
    >
    >
    > Book collection database:
    > http://office.microsoft.com/en-us/templates/TC010186431033.aspx?CategoryID=CT011366831033
    >
    >
    > DVD collection database:
    > http://office.microsoft.com/en-us/templates/TC010186441033.aspx?CategoryID=CT011366831033
    >
    >
    > --
    > Rick B
    >
    >
    >
    > "Scooper2241" <Scooper2241@discussions.microsoft.com> wrote in message
    > news:D0119B10-31C6-4BD2-B168-12F680712E27@microsoft.com...
    > >I am starting a data base from scratch for a library of thousands of
    > > video tapes. The company I work for is broken up into many different
    > > departments and groups. The videos need to be sorted into the appropriate
    > > category for which I created a combo box field with the names of the
    > > different departments. The fields that accompany them are mostly the same
    > > (Date, Program
    > > Title, Footage Type, Agenda and the big one which i assigned ten separate
    > > fields for, SPEAKERS).
    > > Earlier it was said that I should create a new table for speakers but I am
    > > totally confused as to the layout? I know that any given video may have
    > > many
    > > speakers (if so do i need a field for each speaker or do they get their
    > > own
    > > record?) and that I need to be able to reference all the videos one person
    > > made a speech at and vice versa what speakers are on a particular video?
    > > Should their be a table for the program names them self? How many tables
    > > do
    > > I need to do this?
    > > In the end to keep this monster together and organized I need a way to
    > > have
    > > everything divided into the categories. Because their are so many
    > > categories
    > > the tapes can't just be labeled 1,3,4,5 or they would all just get grouped
    > > together. Instead the department has it's own section on the shelf so what
    > > I
    > > want is a key that identifies the department and the tape number starting
    > > with 1 and going up for each department.
    > > Is this possible? and if so how can it be done!!!????
    > > P.S. Microsoft does not have any blank video templates for Access 2002
    > >
    > > Can anyone help?
    > > Can anyone help me? AAAHHHHHUUUUGGGGGHHHH the pain!!!!

    >
    >
    >
     
  6. Rick B

    Rick B
    Expand Collapse
    Guest

    I have 2003 and it worked fine for me. You saved the CAB file on your hard
    drive, then double clicked the compressed file and it opened a POWER
    ARCHIVER or WINZIP screen with the database file? You then extracted that
    file to your hard drive?



    --
    Rick B



    "Scooper2241" <Scooper2241@discussions.microsoft.com> wrote in message
    news:E30D2BBB-094D-4588-95AB-0E78C2618C07@microsoft.com...
    > When i try and download the template it tells me Access 2002 not found and
    > when i downloaded it anyway it would not open in 2002
    >
    > "Rick B" wrote:
    >
    >> Microsoft DOES have the templates mentioned. They are in Access 2000
    >> format
    >> (which will work just fine with any later version).
    >>
    >> I would think they will work just fine with VERY LITTLE modification.
    >> Your
    >> "speakers" would replace actors in the database as it is designed.
    >>
    >> Any of the following would probably be excellent starting points...
    >>
    >> Music collection database:
    >> http://office.microsoft.com/en-us/templates/TC010186291033.aspx?CategoryID=CT011366831033
    >>
    >>
    >> Book collection database:
    >> http://office.microsoft.com/en-us/templates/TC010186431033.aspx?CategoryID=CT011366831033
    >>
    >>
    >> DVD collection database:
    >> http://office.microsoft.com/en-us/templates/TC010186441033.aspx?CategoryID=CT011366831033
    >>
    >>
    >> --
    >> Rick B
    >>
    >>
    >>
    >> "Scooper2241" <Scooper2241@discussions.microsoft.com> wrote in message
    >> news:D0119B10-31C6-4BD2-B168-12F680712E27@microsoft.com...
    >> >I am starting a data base from scratch for a library of thousands of
    >> > video tapes. The company I work for is broken up into many different
    >> > departments and groups. The videos need to be sorted into the
    >> > appropriate
    >> > category for which I created a combo box field with the names of the
    >> > different departments. The fields that accompany them are mostly the
    >> > same
    >> > (Date, Program
    >> > Title, Footage Type, Agenda and the big one which i assigned ten
    >> > separate
    >> > fields for, SPEAKERS).
    >> > Earlier it was said that I should create a new table for speakers but I
    >> > am
    >> > totally confused as to the layout? I know that any given video may have
    >> > many
    >> > speakers (if so do i need a field for each speaker or do they get their
    >> > own
    >> > record?) and that I need to be able to reference all the videos one
    >> > person
    >> > made a speech at and vice versa what speakers are on a particular
    >> > video?
    >> > Should their be a table for the program names them self? How many
    >> > tables
    >> > do
    >> > I need to do this?
    >> > In the end to keep this monster together and organized I need a way to
    >> > have
    >> > everything divided into the categories. Because their are so many
    >> > categories
    >> > the tapes can't just be labeled 1,3,4,5 or they would all just get
    >> > grouped
    >> > together. Instead the department has it's own section on the shelf so
    >> > what
    >> > I
    >> > want is a key that identifies the department and the tape number
    >> > starting
    >> > with 1 and going up for each department.
    >> > Is this possible? and if so how can it be done!!!????
    >> > P.S. Microsoft does not have any blank video templates for Access 2002
    >> >
    >> > Can anyone help?
    >> > Can anyone help me? AAAHHHHHUUUUGGGGGHHHH the pain!!!!

    >>
    >>
    >>
     

Share This Page