|
How the Excel application works):
Data base applications can be developed upon request and may
take some time to complete. First come first serve
bases. Click on "Contact" for information on how
to contact me.
Excel Database):
The application uses a worksheet in the Microsoft Excel file to
use as the data base for problems and the hardware available.
The database contains hardware data and any geometric problems the
user has saved to the database. User can
delete/add/edit/modify items in the database by the application or
on the worksheet. Another Excel sheet is for printing reports of a
particular problem save to the data base.
Reports):
Reports can be generated for a problem from an Excel sheet for
any problem
that has been saved to the database. Examples of reports may
be Invoices, Labels, ...etc. Additional notes can be
added on the reports if needed.
Advantages):
The Excel application provides several advantages for the
users.
- Because excel is so widely used, no new training is required
other than how the application works.
- Print out reports based on the application.
- General information can be added based on the application.
- Instructions on how to use the data base application.
- Information can be saved, modified, deleted, and/or retrieve from
the Excel data base.
- The data base application, database information, and report functions are all
contained in one file.
Limitations):
The Excel application has one limitation. It is as follows:
- User can not run multiple applications.
- Other limitations may be based on the application.
|