With 1.7 million freelancers, we'll match you with the perfect talent.
The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
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