Find Jobs
Hire Freelancers

Access Database modifications

$100-500 USD

In Progress
Posted over 11 years ago

$100-500 USD

Paid on delivery
I currently have a pretty simple Access 2007 database for asset tracking. I need several updates made to improve its function. The database application currently has the ability to: - Keep a track of current inventory - Print the current inventory (or portions of the current inventory) along with a sign-off block and a unique random hexadecimal number at the bottom. I need the following features added: - Allow only limited editing of the inventory. Currently the end user can made direct edits in the database table, but this should be hidden from the end user, and changes should be limited. For instance, an item should never be allowed to be deleted from the inventory. Instead, a new field should be added to the database with the status of the item (Active, Destroyed, or Transferred). - Keep an audit trail of past inventories. I want to be able to select any date in the past and view the inventory contents and status at that time. - On the "Assets Form", which enables the end-user to print a copy of the inventory, I need a "Select all/Deselect all" button for the "print" column. - A method of selecting which item statuses to display on the printed list. By default, only "Active" items should be printed, but the end-user should be able to select "Destroyed" or "Transferred" items as well, if needed. - A method of exporting a copy of the entire current or previous inventory (all fields) to an excel workbook. I'm attaching a dummy copy of the inventory database for your use in determining the difficulty of this project. Please feel free to ask any questions you might have.
Project ID: 2675310

About the project

29 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

About the client

Flag of UNITED STATES
Beaufort, United States
5.0
14
Payment method verified
Member since Jul 22, 2007

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.