Build MS Access Database to Document existing Tables & Fields

Cancelado Publicado hace 7 años Pagado a la entrega
Cancelado

We have an existing Access project that we would like to migrate to a new data structure.

The project is in constant use so we need to be able to re-migrate the data repeatedly during testing then finally when ready to go live.

The old database has table and field names that we wish to change.

Our objective is to to import our existing database structure into tables (to document it) then add details of new tables / fields so that the database can then automatically create our new tables and fields by copying data from the old. We then may want to amend the old structure and re-import it, retaining data about the new tables and fields.

What we would like you to create for us is a new Access Database ([url removed, login to view]) that:

- has a table tTableNew with fields sufficient to create a new table (including foreign key link to tTableOld using table name not ID)

- has a table tFieldNew with fields sufficient to create a new field (including foreign key link to tTableOld using table name not ID)

- has a form with three buttons

- the first button should create a new Access database with tables and fields as defined by tTableNew and tFieldNew

- the second button should insert data from the old database into the newly created tables

- the third button (import old structure) opens our existing database in order to do the following

- loop all existing tables, creating a record for each in a table tTableOld

- loop all existing fields, creating a record for each in a table tFieldOld

- ensure a foreign key exists in tFieldOld so that a relationship is maintained between tTableOld and tFieldOld

Microsoft Access

Nº del proyecto: #10728378

Sobre el proyecto

4 propuestas Proyecto remoto Activo hace 7 años

4 freelancers están ofertando un promedio de $9 / hora por este trabajo

Dhruvika111

Greetings! I hope you are doing well! We have a extensive experience in Build MS Access Database as per your requirement. Can you please reply on our bid,so we can able to discuss the things properly. Iam sure yo Más

$8 USD / hora
(2 comentarios)
3.2
MohsanEijaz

I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SEO, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for y Más

$8 USD / hora
(1 comentario)
1.5
yilingdev

Dear client! I'm VBA expert. And I have many experiences of develop excel/access macro I can help you and like to work with you. Thanks. Regards.

$15 USD / hora
(0 comentarios)
0.0
arityinfoway

Hello Sir, I have gone through your requirements regarding Build MS Access Database to Document existing Tables & Fields. we brief and understand your idea and preference for job as you are looking for. I have mo Más

$11 USD / hora
(1 comentario)
0.0