S
slipandfall
Hi,
I want to create a database using access to keep track of my book
collection, but I have a question.
Essentially, I would like it to display the following info for each book
I've entered. book title, author, publisher, year, a reference number, date
entered into database and subject matter.
I've used Excel before and have seen a spreadsheet with a worksheet like the
above which had a second worksheet that had a button marked "Add book
details" When you clicked it you filled the info above into a few boxes and
then it would actually add the info you typed in, into the first worksheet
and even sorted it into the correct position alphabetically. Ideally, I
would like to be able to easily print the details of just the ones from a
particular author or perhaps the publisher.
I have about 100 books entered into a basic excel chart and think I should
find a better way to enter the info before I do many more. Ideally, I'd like
a database as I find working in excel spreadsheets to easy to delete a cell
on accident, plus I'd like access to prompt me with a list of
authors/years/subjects ect that I had previously typed in when I was
prompted for the information on the new title. I think this is called a
dropdown list?
I'm over my head in creating anything like this in access, but I think I
could adapt an inventory management type template to my individual needs if
I could find a suitable one. The ones on microsofts site are either
specifically for access2003 or have way too many other features like
employee timecards and sales reports and the like.
Can anyone recomend a site where I can download a premade one that I can
customize. Or even a free standalone program that would do a similar job as
an access database.
Though I have in interest in learing more about Access programming, Id
rather not have to reinvent the wheel.
Thanks in advance!
I want to create a database using access to keep track of my book
collection, but I have a question.
Essentially, I would like it to display the following info for each book
I've entered. book title, author, publisher, year, a reference number, date
entered into database and subject matter.
I've used Excel before and have seen a spreadsheet with a worksheet like the
above which had a second worksheet that had a button marked "Add book
details" When you clicked it you filled the info above into a few boxes and
then it would actually add the info you typed in, into the first worksheet
and even sorted it into the correct position alphabetically. Ideally, I
would like to be able to easily print the details of just the ones from a
particular author or perhaps the publisher.
I have about 100 books entered into a basic excel chart and think I should
find a better way to enter the info before I do many more. Ideally, I'd like
a database as I find working in excel spreadsheets to easy to delete a cell
on accident, plus I'd like access to prompt me with a list of
authors/years/subjects ect that I had previously typed in when I was
prompted for the information on the new title. I think this is called a
dropdown list?
I'm over my head in creating anything like this in access, but I think I
could adapt an inventory management type template to my individual needs if
I could find a suitable one. The ones on microsofts site are either
specifically for access2003 or have way too many other features like
employee timecards and sales reports and the like.
Can anyone recomend a site where I can download a premade one that I can
customize. Or even a free standalone program that would do a similar job as
an access database.
Though I have in interest in learing more about Access programming, Id
rather not have to reinvent the wheel.
Thanks in advance!