Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

MS Access - Basic database with back up control / recovery
Sign in to Add to Watch List

IT & Programming > Database Development

View Change History

The client has made the following changes to the job.


Job awarded.

Sep 12, 2011

Job Description

  |  Change History >>


  • Posted: Thu, Sep 08, 2011
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

Simple task (I just don't have the time) however I would like you to consider the following, with the prospect of doing heap more in future. In a way this is a simple test, with a useful purpose, as this and othere works are in the offing.

1.Using Microsoft Access, create a Relational Database with the tables from the attached file; populate the tables with the sample data provided.

2.Ensure the database relational, enforcing entity and referential integrity.

3.Copy/paste these tables with data into the same database to create the ‘Backup’ tables.

4.Write the restore macro (fully commented), which will run SQL queries to delete the data in the changed tables and replace them with the data in the backup tables (i.e. restoring the changed table(s) to their original data).

5.Create a command button on an Access Form for the restore macro.

6.Create three action queries using SQL in SQL View only for testing purposes. The three queries required are:
1.Insert a new customer and...

Sign in or Register to see more

Job ID: 26040129
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 United Kingdom
I have an excellent academical background and vast practical experience working with clients on a wide range of projects. I have excellent language...
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 26059501  |  Submitted: Sep 9, 2011 09:47 ET 
Within 3 days

 Pakistan  |  
Al-Bari Consulting is a group of professional with expert level in domain. We provide software development and support services for mission...
 4.6   |  $90 Earnings   |  1 Jobs
Bid ID: 26054472  |  Submitted: Sep 9, 2011 03:11 ET 
Proposal SEALED

We are a software company which aims on Web technologies. MySQL, SQL-Server, Python, Twisted, PHP, Perl, Joomla, Drupal, zenCart are a few of the...
 4.7   |  $200 Earnings   |  0 Jobs
Bid ID: 26040851  |  Submitted: Sep 8, 2011 08:40 ET 
Proposal SEALED

 Bangladesh  |  
We are here from Bangladesh. We have a creative well experienced world class professionals who develop Application Software , Web-based Enterprise...
 3.0   |  Private   |  0 Jobs
Bid ID: 26040400  |  Submitted: Sep 8, 2011 08:05 ET 
Proposal SEALED
Elance is now an Upwork company.
Upwork is the choice of 4M+ clients. Get started working on Upwork today.
Are you ready to post a job like this one?
Post a Similar Job »