Hi, i am studyiing a degree in Information technology and have a module named data analysis and database design.
I have received some notes from my lecturer titled " MS Access for Building Database Systems" and i need help in filling some of the blanks in the notes in and was wondering if some of the people on this forum could help me, they will be used as notes to help me revise from.

The notes have been uploaded here and are a powerpoint presentation.
http://download.yousendit.com/DD732F222672E6CC

It would be nice if people could just put some info under the headings:

MS provides an integrated environment for developing database applications.

Features of MS Access:

tables


queries



forms



reports



wizards



controls/built-in functions/properties


VBA


Concurrency/record management features built in


Features of Access which support relational database development :

Table definition

Key definition

single attribute keys

composite/compound keys

foreign keys

Relationship definition

Referential integrity features
can enforce referential integrity – what does this mean?

cascade update

cascade delete

SQL statements may be used



Here is the type of question that i would need to answer in an exam using these notes and the question is worth 25 marks


"5. (a) How does MS Access support the development of relational
database systems? [10]
(b) Explain the key features of MS Access which help developers produce
systems quickly and efficiently.[15]"


My exam is on monday, i would be grateful if anyone could fill it in by tonight or tomorow morning.

Thanks

Hi, i am studyiing a degree in Information technology and have a module named data analysis and database design.
I have received some notes from my lecturer titled " MS Access for Building Database Systems" and i need help in filling some of the blanks in the notes in and was wondering if some of the people on this forum could help me, they will be used as notes to help me revise from.
The notes have been uploaded here and are a powerpoint presentation.
http://download.yousendit.com/DD732F222672E6CC

It would be nice if people could just put some info under the headings:

MS provides an integrated environment for developing database applications.

Features of MS Access:

tables - Useful for putting you reference books on.


queries - looks like you have just posted one here



forms - a name for a class in british schools



reports
Doesn't look like you will get a good one unless you do some work


wizards - ask Harry Potter



controls/built-in functions/properties self explanatory


VBA - very boring answers


Concurrency/record management features built in


Features of Access which support relational database development :

Table definition something you sit at to eat a meal

Key definition A key opens a lock

single attribute keys Key that only opens 1 lock

composite/compound keys High security Key

foreign keys Key made in another country

Relationship definition Ask your girl friend

Referential integrity features Low integ
can enforce referential integrity – what does this mean? Don't you know?

cascade update consult atlas

cascade delete destroy mountains in western America

SQL statements may be used. Thats handy



Here is the type of question that i would need to answer in an exam using these notes and the question is worth 25 marks


"5. (a) How does MS Access support the development of relational
database systems? [10]
(b) Explain the key features of MS Access which help developers produce
systems quickly and efficiently.[15]"
Bet you don't get full marks unless you do some work


My exam is on monday, i would be grateful if anyone could fill it in by tonight or tomorow morning. Good luck

Thanks. Hve a nice day

my arse.....
if your lectures been off - then your marks will be adjusted...