Hey Looking at the scenario and data files I have got 4 tables,customer,phone,contract and package, I was wondering if anyone agrees also when importing the data in each table how many records you got bye

Hi I am new to the applied Unit 7 exam, looking at the scenario I have got 5 tables, I also see this exam needs a functional spec rather than a flowchart. Phones, Stock,Sales,Customer,Contracts. does anyone agree? Do we as lecturers get the real data files a week before the students?

Can anyone explain the following anomoly between the specification for Unit 7 and the ICE document. In the ICE Document it says: "11.8 Communication between candidates during each sub-session is not allowed." In the specification it says: "During the production of your database system...

If you put the Field headings into an new empty table and make the Member ID an Auto number then import to this table it will work. I have spent days trying to work out a way of creating the user interface and have made no progress . Any ideas?

Reading through the scenario, I don't think the data structure, validation etc is going to be overly complicated. The 16 digit number shouldn't be much of a problem and you can use an autonumber. The 1st 8 digits are always the same (5555 1234 or something like that). If you use the Format of...

Just wondering if anyone here can suggest the best way of importing data into previously set up Database Tables. Nothing seems to be working for me - wondering whether I am missing something simple! At the moment I am playing with the S Cars SAM material.