GUI program

[SmallTownGirl]

I am not necessarily new to Access but have never found a great appreciation
for it. I am trying to build a simple database with a simple GUI. This
database will keep track of all of the equipment owned by a company, as well
as a break down of amorization schedules for each piece of equipment.

I have everything in the database now I just need to know how to design a
simple GUI so that others can add/edit things in the database.

Is there a way to make this like a program that they would open from their
desktop...that would not open in Access? Even if I have to purchase
third-party software to work in conjunction with Access for this to happen.

Also does Access have capabilities such as excel with autosum, etc?

Any responses are greatly appreciated. Thank you for your time.

 

[John W. Vinson]

I am not necessarily new to Access but have never found a great appreciation
for it. I am trying to build a simple database with a simple GUI. This
database will keep track of all of the equipment owned by a company, as well
as a break down of amorization schedules for each piece of equipment.

I have everything in the database now I just need to know how to design a
simple GUI so that others can add/edit things in the database.

Is there a way to make this like a program that they would open from their
desktop...that would not open in Access? Even if I have to purchase
third-party software to work in conjunction with Access for this to happen.

Also does Access have capabilities such as excel with autosum, etc?

Any responses are greatly appreciated. Thank you for your time.

ummmm...

so you've tried and rejected the very powerful Forms feature within Access?

Sure, you can (with about triple the effort) create a Visual Basic or Visual
Studio compiled application to use the data stored in a JET (Access) database.
It might even be as user friendly as a well designed set of Access forms, if
you're really good at programming.

Of course Access is quite capable of doing "autosums", total queries,
basically any sort of calculation that you would like to do.

You might want to look at some of the many examples of working Access
applications, and tutorials for the program:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials