Em Andamento

Microsoft Access VBA fucntionality

The following project requires a number of features to be built onto an existing database. The project will use Microsoft Access and an experienced VBA developer will be required

The database consists of 10-12 tables and each table consists of 4-8 fields. The database is currently empty but I will put in some test data before sending the database to the selected bidder.

The features that need to be added to the database are as follows:

1. Create a change log:

This log will need to track changes made to the database

Ideally I would like to store the details of :

• What has been done – whether data, has been modified, deleted or updated and to what data

• Who has done it – using the 'environ' method built in to windows to get the user name

• When it was done – date and time

The database consists of 10-12 tables and each table consists of 4-8 fields. The database is currently empty but I will put in some test data before handing the database to the selected bidder.

2. Import functionality.

We will need to take data from a spreadsheet and import it into corresponding tables in the database.

The spreadsheets consist of 36 columns.

Each new row in the spreadsheet will need to be imported into the database.

The 36 columns need to be imported into the 7 corresponding tables.

However we need to generate a primary key for each row of data entered into the database. There will only be one primary key for the 36 columns although this primary key will be a foreign key in 6 other tables.( auto number could be used but is probably not ideal as it can cause problems later on )

This import functionality will be used regularly to import data so it needs to be quite robust and the locations of the spreadsheet will change so the ability to ‘browse’ to the spreadsheet using the windows browser is essential.

Please feel free to ask me any questions.

FYI, The maximum budget for this project will be $150

Habilidades: Visual Basic, Área de trabalho do Windows

Ver mais: vba access developer, microsoft project import, microsoft number, microsoft access database developer, get microsoft access free, vba time, vba for, microsoft visual, microsoft vba, microsoft spreadsheets, microsoft project free, microsoft access test, me vba, in vba, microsoft access developer, budget spreadsheet, test auto, microsoft , microsoft access vba, key generate, c access, basic free test, access microsoft, create access database spreadsheet, windows vba

Acerca do Empregador:
( 4 comentários ) Kerry, Ireland

ID do Projeto: #162466

Premiar a:

$150 USD em 3 dias
(12 Avaliações)
4.5

8 freelancers estão ofertando em média $153 para este trabalho

HussienSharaf

hi, i m the best expert in DB design and MS Access and VBA. plz check PMB. thanks

$150 USD in 4 dias
(46 Comentários)
6.6
riyoyo

For #1: you could add a "change" event listener, so your MS Access database knows what had been changed. For #2: you could use Web Query method for importing your worksheets file. That's it. All are written in VBA code Mais

$125 USD em 1 dia
(15 Comentários)
5.9
mingon

Hello! I have great experience in MS Access VBA automation. The description is expanded, so I haven't any questions, excepr log format layout.

$100 USD in 3 dias
(11 Comentários)
5.4
$150 USD in 10 dias
(2 Comentários)
1.6
Mudra

Hi there! Well I have done Exactly the same project for my client's Payroll System software. but his database was with SQL. I can very well do this with MS-Access also. Let's start!!

$150 USD in 5 dias
(0 Comentários)
0.0
nkarthick

Hello Sir, I am Narayana Karthick working as VBA Developer, i have very good experience in VBA (Access, Excel). Now I am working with Access project for the client 'http://dssaccess.com/'. I had done many projec Mais

$150 USD in 3 dias
(0 Comentários)
0.0
sharangaonker

I have the capability to achieve the job the time and provide the solutions form the bottom of the core of any requirement. the Asset for me the broad experience of same type of work. So you can make trust on me for an Mais

$250 USD in 7 dias
(0 Comentários)
0.0