Can Access do this?

[NightLord]

I want to create a self-contained program/database that works like so:

User(s) is presented with an initial screen that looks like a Form. This
form will contain various input fields. Some will be drop-down selection,
others they will input information manually.

The drop-down selections will pull from the database, which is also updated
when the form is filled out.

The point being, the database contains information already: I may have an
entry for Bob with his address, phone number, ect. That information is
already sitting in the database. The point of the form is so that the next
time I deal with Bob, I can input that information (time he called, day of
the week, phone number he called from, ect.) into the form and have it added
to the database. That's just the form. I then need to be able to go to
another page and be able to sort the information from the database. Thus, I
can sort by phone number and see that both Bob and Mary have called from the
same phone number, or address, ect.

Is this possible with Access, or do I need something more?

 

[Tom van Stiphout]

On Wed, 24 Sep 2008 15:37:02 -0700, NightLord

That is well within its capabilities.
You may want to start with a template. There are many available at
office.microsoft.com

-Tom.
Microsoft Access MVP

 

[Allen Browne]

Yes: you can create a contact management database in Access.

 

[John W. Vinson]

I want to create a self-contained program/database that works like so:

User(s) is presented with an initial screen that looks like a Form. This
form will contain various input fields. Some will be drop-down selection,
others they will input information manually.

The drop-down selections will pull from the database, which is also updated
when the form is filled out.

The point being, the database contains information already: I may have an
entry for Bob with his address, phone number, ect. That information is
already sitting in the database. The point of the form is so that the next
time I deal with Bob, I can input that information (time he called, day of
the week, phone number he called from, ect.) into the form and have it added
to the database. That's just the form. I then need to be able to go to
another page and be able to sort the information from the database. Thus, I
can sort by phone number and see that both Bob and Mary have called from the
same phone number, or address, ect.

Is this possible with Access, or do I need something more?

All of this is very possible.

You do need to have your application designed correctly though. If you already
have this set up with one table... step back a bit. You need (at LEAST) two
tables - one for contacts (the people), and one for calls. You may end up
using a form with a subform for these two tables; there are other
possibilities.

I'm pretty sure that A2007 has a contact manager template that may do what you
want.