Create OpenOffice Base database and train on data entry and administration
$30-100 USD
Cancelado
Publicado hace alrededor de 12 años
$30-100 USD
Pagado a la entrega
I need someone to create a database using OpenOffice Base.
The database will have the following fields:
Location (number)
SaleNumber (number)
RewardsNumber (number)
Email (text)
Logged (yes/no value)
Date (mm/dd/yy)
Time
Notes (text with preferably unlimited characters)
ReferredBy (dropdown list)
Employee (dropdown list)
GoldSpot (dollar amount)
SilverSpot (dollar amount)
PlatinumSpot (dollar amount)
GoldAdjustment (percentage)
TotalPaid (dollar amount)
GoldTotal (dollar amount)
PlatinumTotal (dollar amount)
SilverTotal (dollar amount)
Total Gross (dollar amount)
AuGross (dollar amount)
AgGross (dollar amount)
PtGross (dollar amount)
Au10K (number)
Au14K (number)
Au16K (number)
Au18K (number)
Au20K (number)
Au900 (number)
Au21K (number)
Au22K (number)
Au23K (number)
Au24K (number)
Ag400 (number)
Ag900 (number)
Ag925 (number)
Ag999 (number)
Ag400Adjustment (percent)
Ag900Adjustment (percent)
Ag925Adjustment (percent)
Ag999Adjustment (percent)
PtAdjustment (percent)
Pt900 (number)
Pt950 (number)
Pt999 (number)
After the database is created, I will need you to show me how my employees can enter data into it. I have already created a spreadsheet in OpenOffice Calc where they enter a lot of the data that will go into the database. If this spreadsheet could somehow link into the database, that could make the process even quicker.
I will also need someone to show me how to access and administrate (sort, delete, modify, add) to the data myself.