access database with ability to track sales

C

Caroline M.

I useed to have a database set up in Microsoft works in which I had fields
for the contact information, phone # etc. Then I had labels and columns which
allowed one to enter numerical data which using a formula totaled up the
yearly sales for each client. Unfortunately not everyone has Works so I need
to create a new database. I want this to be on one form with record
capababiltiy. I don't really care if I can transfer any info to other
databases for charts etc. I am finding myself not able to do this in excel or
access and I need some assistance. Is this possible. I don't want to have to
create several forms to do simple data entry.
 
D

databaseben

msaccess can likely import it with all your fields and data. Take a look at
the extensions that msacess has under the open file dialog. Then figure out
a way to save or export your data from works. It's likely that you can
export iyour works data into or save as a spreadsheet file, csv, txt,
etc...., Then get access to import the spreadsheet or link to data
file.... g.l.
 
Top