Devam Ediyor

Airdate Mangement System - Check number & Invoice Number Addtions

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.

Beceriler: Microsoft Access

Daha fazlasını görün: n is a number, microsoft number, kdoc, access db forms, microsoft access test, points system, invoice front, invoice example, create invoice, access points, access macros, database invoice microsoft access, simple check date, access query table, advance search form, simple invoice microsoft access, access append, access table query, access linked table, simple invoice database, form invoice, access table query form, access create query, microsoft access create backend, table linked access

İşveren Hakkında:
( 8 değerlendirme ) CLEARWATER, United States

Proje NO: #4439821

Seçilen:

winghei

Hi, Please check my profile and your pmb Regards, winghei

0 gün içinde 65$ USD
(29 Değerlendirme)
5.3

4 freelancer bu iş için ortalamada 87$ teklif veriyor

amcsummers

Thanks for taking the time to writea detailed scope. It makes it a lot easier to give a fair price on work. You referrenced some jpg files but I did not see them on the project. I hope you will consider my bid. F Daha fazlası

in 3 gün içinde85$ USD
(38 Değerlendirme)
5.1
emova

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

in 3 gün içinde99$ USD
(32 Değerlendirme)
4.3
expertcoder1vw

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

in 2 gün içinde99$ USD
(8 Değerlendirme)
4.2
NourElDeen

Dear Sir, I'm Ready To Help. Best Regards, NourElDeen

in 2 gün içinde100$ USD
(18 Değerlendirme)
4.1