It is not possible to give a complete answer in a few sentences. Access is a
powerful system with a lot of features.
Access is a database that manages data. An Access database can consist of
many data-tables, all defined by you, the designer.
If you have a set of data that need to be sorted, filtered, updated etc.
Access can do the job for you. Typical subjects covered by a database are
salesorders, customers, invoices, employees etc.
Access provides the tools to build forms with controls (buttons, textboxes,
datasheets etc) that enable the user to read, update, delete data in tables.
Some beginners may not see the difference between Excel and Access. Why use
Access when "everything" can be done in excel? Access has capacity far
beyond excel when it comes to number of rows in tables and speed. Access has
the basic tools you need to set up tables with keys, indexes and relations.
These features help speed and consistency in the data-tables Excel, to my
knowledge, has no such features.
I think a basic textbook on Access will help you a lot. When you install
Access on your PC you will often have the option to install the Northwind
sample database. Going through this sample database and Access Help may be
very useful to you.
Regards
Tore
