Solved

Access 2007 Database to inventory, catagorize, and search by keyword

Posted on 2008-06-14
8
902 Views
Last Modified: 2013-12-25
Hi,

I am a member of a Church and have been given the priveledge and responsibility of maintaining a plethera of recorded Sermons and Events stored on CD's and DVD's.  I have a system of keeping them organized and catagorized physically, but I am in great need of a method that can be used to INVENTORY the CD's and DVD's.

I know Access has the potential to do what I need it too.  But i know nothing about it.  What I'm looking for is a "Database" that allows me to make an organized inventory of the sermons By: Date, Speaker's Name, Sermon/Event Title, Catagory, and also a place for making notes about the disk.

Then most importantly it would need to have the ability to be "searched" by keywords.  Like if I want to find all the sermons/events by a particular 'speakers name' then I can just search by that persons name and it pulls up all related entries.  

I know there must be tons of different methods of making this happen, so I'm not bound to using Access, I just figure its something that could be free and convienent because I own it already.

Thanks for input and IDEAS!

zbox
0
Comment
Question by:zbox
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 19

Expert Comment

by:frankytee
ID: 21788500
its critical that you get your db relationship and table design correct.
given your info you can use this as a starting point.

table: tblPreacher
fields:
PreacherID (Primary Key)  -auto number if you want
PreacherFirstName
PreacherLastName
..plus address details etc

table: tblSermon
fields:
SermonID (PK)  -auto number if you want
PreacherID (Foreign Key)
Title
SermonDate
Category
MainBook --genesis, mark, etc
MainChapter --1, 2 etc whatever
MainVerseStart --9 etc whatever
MainVerseEndt --21 etc whatever
FlagDVD yes/no field to indicate whether burn to DVD etc
FlagCD yes/no field to indicate whether burn to CD etc
... etc

table: tblSermonDetails
fields:
SermonDetailID (PK)  -auto number if you want
SermonID (FK)
Keywords  -put one keyword per row
...etc

relationships
tblPreacher to tblSermon is 1 to many (ie one preacher has many sermons)
tblSermon to tblSermonDetailsis 1 to many (ie one sermon has many keywords)

after you have your table design you can then begin designing your forms etc where you do your data entry etc
0
 

Author Comment

by:zbox
ID: 21790517
I want to aknowledge that I am reading your comment.  However, please give me some time to understand it.  I will play with Access a little bit this week and see what I come up with using this info.  In the meantime, if there is anything else I should know, please comment.

-first time Access user,

zbox
0
 

Author Comment

by:zbox
ID: 21806063
I've done some research and I understand your comment a little better.  You're right.  I need to make tables first then forms and so forth from there.  I think the hard part for me is going to actually be the relationships between the tables later on.  anyways I'm not sure how much more you can help, I am going to need some great training video tutorials!

any recommendations for Access 2007 tutorial videos that show making a database START to FINISH??

peace
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 19

Expert Comment

by:frankytee
ID: 21811699
0
 
LVL 19

Accepted Solution

by:
frankytee earned 500 total points
ID: 21811723
and if you ever get stuck then post another question on this site. most of the ee regulars here have years of experience and are pretty much the cream of the crop. videos and books will cover the basics so you'll get some tips from this site that you wont find there.
0
 

Author Comment

by:zbox
ID: 21825145
wow, frankytee you hit it on the money.  Well said and good advice.  I feel confident about getting started with Access2007 now and cant wait to explore those links you posted a little deeper.  

I learn by seeing so much better and pick up things very quickly, so this should be all I need until I get to the deeper things like table relationships.  Thanks again EE!

zbox
0
 

Author Closing Comment

by:zbox
ID: 31467287
You were very helpful, thank you.  Also your first comment makes more since now after reviewing the links with tutorials!

peace

zbox
0
 
LVL 19

Expert Comment

by:frankytee
ID: 21828194
thanks, you're welcome.
also the best way to learn is to practice, experiment and make mistakes (create an "access tips" folder and document any unexpected or hard to remember things you come along)
make sure you make several backups of your db as you develop so you can always roll back to a particular time or version.
the tutorials and good books will give you a good guideline but you'll be amazed how much you'll pick up by experimenting and also this site.
0

Featured Post

Get MongoDB database support online, now!

At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question