A few questions about forms

[jfielding2000]

Hi Guys. . .

In a few weeks I have to face a dreaded database exam.

I have lots of past papers and questions . . and I'd just like to pop only 2 or 3 to see what answers you guys would give. I am really looking for model answers - to help me further revise.


1. Describe three checks that you might make to verify correct operation of your form and subform. [5 marks]


2. After completing your design work, you open the form and attempt to add a record to the subform. The message “the changes you requested have not been successful because they would create duplicate values in the primary key or relationship” appears. Explain carefully the cause of the problem.

3. Furthermore, when the form is viewed there are several occurrences of each main form record. Explain the cause of this problem.

 

[ajetrumpet]

You won't get an answer to this. Please don't post questions like this. It's your exam...

 

[jfielding2000]

Excuse me what? Yes its my exam - and I'd like some help! This is last year's question and I'd like someone to answer it. I want to do well, and I have 3 weeks until the real exam is upon!

Thanks in advance.

 

[gemma-the-husky]

jf - posters here dont like doing homework stuff direclty, but these will guide you


for 1, not sure - think about it

for 2 search for "non updateable queries" or "my query is non-updateable"

for 3 search for "cartesian" join