🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Thread View: microsoft.public.access
4 messages
4 total messages Started by Hyun Jin O Wed, 07 Jan 1998 00:00
Library Database HELP!
#10
Author: Hyun Jin O
Date: Wed, 07 Jan 1998 00:00
25 lines
1982 bytes
Help me Please.

I am trying to create a database for basically a library.

i have cards that people check out.  i would like to keep track of:

1. who checked the card out
2. when they checked the card out
3. when it was returned, if it is returned
4. what cards are checked out/ still in

nothing very complicated i know.  but i have very little experience
using access.
i have tried to make one but i am having some serious problems.  I have
bought a couple of books but i don't have time to go through a 3 week
course.  i know how to make simple forms and queries and tables and
things.

a sample database would be very helpful if anyone knows where i could
obtain/view one.

thank you all in advance for any help that you give.

Hyun Jin O
Re: Library Database HELP!
#11
Author: Hyun Jin O
Date: Wed, 07 Jan 1998 00:00
31 lines
2199 bytes
P.S.  This is supposed to be used by many different people and user
friendly.  So, forms and buttons and anything else would be very helpful.


Hyun Jin O wrote:

> Help me Please.
>
> I am trying to create a database for basically a library.
>
> i have cards that people check out.  i would like to keep track of:
>
> 1. who checked the card out
> 2. when they checked the card out
> 3. when it was returned, if it is returned
> 4. what cards are checked out/ still in
>
> nothing very complicated i know.  but i have very little experience
> using access.
> i have tried to make one but i am having some serious problems.  I have
> bought a couple of books but i don't have time to go through a 3 week
> course.  i know how to make simple forms and queries and tables and
> things.
>
> a sample database would be very helpful if anyone knows where i could
> obtain/view one.
>
> thank you all in advance for any help that you give.
>
> Hyun Jin O
Re: Library Database HELP!
#12
Author: Bill Matthews
Date: Thu, 08 Jan 1998 00:00
46 lines
2550 bytes
Hyun,

Try looking at the various sample and "collection" sample databases
provided with Office/Access.

You might be able to use or modify one of these (e.g., "Book Collection" to
get what you need.

If you installed them as part of your Offcie or Access installation, you
will find them on your hard drive under:

C:\Program Files\Microsoft Office\Templates\Databases\.....

Hope this helps!

Good Luck!

Bill

Hyun Jin O wrote:

> Help me Please.
>
> I am trying to create a database for basically a library.
>
> i have cards that people check out.  i would like to keep track of:
>
> 1. who checked the card out
> 2. when they checked the card out
> 3. when it was returned, if it is returned
> 4. what cards are checked out/ still in
>
> nothing very complicated i know.  but i have very little experience
> using access.
> i have tried to make one but i am having some serious problems.  I have
> bought a couple of books but i don't have time to go through a 3 week
> course.  i know how to make simple forms and queries and tables and
> things.
>
> a sample database would be very helpful if anyone knows where i could
> obtain/view one.
>
> thank you all in advance for any help that you give.
>
> Hyun Jin O
Re: Library Database HELP!
#13
Author: Joe Fallon
Date: Sat, 10 Jan 1998 00:00
4 lines
1402 bytes
Microsoft Sql Server 6.5 study course has a 10 page description of a
library database.  I think it shows many of the tables and discusses many
of the issues you need to consider when writing such an app.
Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads