9:00am Finish off work on
an existing project for a recruitment company. The user wants to be able to
click a button and email all his clients individually with their timesheet data
attached as an Adobe PDF This involves writing and implementing code in VBA for
Microsoft Access which carries out the process automatically. The code is
almost there but with a few teething errors, I go through the code step by step
using a debugger to determine where the errors are occurring. After the errors
are fixed I double check that the process works and save the changes leaving
the file ready for testing tomorrow.
9:58am Import an update to
a database for a client who has a stock management database that we built. Send
a transfer file to the customer which contains only the
tables, queries, forms and reporrs that need updating. Log on to their PC remotely. I
first backup their live database in case anything goes wrong. I then import the file
to overwrite their existing files and run through the updates of the database
to check they are working.
10:23am I receive a phone
call from another client during the update process saying that they have a
problem with their database. I arrange to phone them back when I am
10:34am Call back the client
from earlier. They want a quick change to an exisitng form.
I carry out the work required on our version of the database and note down the
steps that I have taken. I check this works and then log in to the client’s pc
and carry out the same process there.
11:00am Start building a
new database from a specification produced by Philippa. We have already talked
through the background and requirements of the business. I start
by creating the back file of the database in Access– this is where all the data
is stored in tables.
1:00pm Run the daily
backup for all our files and then break
1:30pm Carry on working
on the new project, finish the back file and start working on the front
which is linked to the tables in the back file. The front file is what the user
sees and is where they enter and view all the data.
2:05pm Receive a phone call
from a company who is looking for someone to build them a database. I take down
their contact details and check that their requirement sounds like something we can help with
before passing them through to Philippa who deals with the enquiry in detail.
2:13pm Check and reply to emails.
2:34pm Carry on the
project from earlier.
3:30 - 4:45pm Several phone calls, including one for me.
Pass the other ones over to Philippa and James. Keep going on the project in between.
5:30pm Finish for the day after noting where I am on the project