Overall Description to the Data Base
1) This is a live database and in full use
2) There is a front end Access DB linked to a backend Access data base.
3) 48 Tables on the backend
4) 185 different queries
5) 126 different forms
6) 29 different reports
7) 14 different macros
8) 14 different modules
As you can see by the above, this is not a simple data base and anyone that is not an advanced coder and understands Microsoft Access could quickly have a mess on their hands if they aren’t very sure what they are doing.
The good news is that we test extensively before going live because of the obvious problem it would cause if there were errors in the live data base.
Item 1: See the two screen shots [Air Dates Search - highlight selected [url removed, login to view] and Air Dates Search - Move the [url removed, login to view]] for the change on the “Air Dates” form. It is two points:
a) move three columns to the left so it is next to the “local date” column
b) when a person selects a row it needs to highlight so as to identify the row all the way across
Item 2: Append an “Invoice” field and a “Check Number” field to the “Airdate” table OR create a new table hold those two fields. If it is a separate table it would have to be set up as a relation to the “tblAirdate” table. It will more likely be best to append the table. NOTE: there will have to be way to auto-advance the Check number. This will be used in a later addition to this database.
Item 3: When on the Air Dates Search form query a station “KDOC” and then “alt-E” to edit a record. The “Edit Airdate” Form comes up. The two fields added to “Item 2” above will be put in this form, see [Air Dates Search - Move the [url removed, login to view]] for example. If the two fields end up being in a separate table then a relationship would have to be established between the new table and the “tblAirdate” table.
4 freelancer bu iş için ortalamada 87$ teklif veriyor
Hi. I'm an access expert. I read through your project description and can assure you of getting this done perfectly with 100% accuracy and attention to detail. Kind Regards. Emmanuel
I'm a professional MS-Access / VBA / SQL Server developer and can do this job for you starting today. Thank you for considering my bid. Bests, Larry