Soldato
theres a table in a db with records containing a unique id, names, addresses, course codes, accomodation numbers, telephone numbers etc, the questions are:
a. Adapt the database to conform to at least 1NF (First Normal Form) and structure the database into a relational model.
b. The database includes one form (called FrmStart) with a visible command button (CmdButton) when the user clicks on the command button a message box appears with the text ‘hello world’ and the form closes (not saving) followed by a different form opening (called FrmNext) How would you write this in VBA?
now I dont want answers but the actual questions make sense yes?
essentually A is looking for non repeating info split into tables , then linked together by the end of it you end up with it in 2NF if done correctly.
and B is declaring the subroutine, msgbox, and docmd.openform baring in mind to use acsaveno when closing.
a. Adapt the database to conform to at least 1NF (First Normal Form) and structure the database into a relational model.
b. The database includes one form (called FrmStart) with a visible command button (CmdButton) when the user clicks on the command button a message box appears with the text ‘hello world’ and the form closes (not saving) followed by a different form opening (called FrmNext) How would you write this in VBA?
now I dont want answers but the actual questions make sense yes?
essentually A is looking for non repeating info split into tables , then linked together by the end of it you end up with it in 2NF if done correctly.
and B is declaring the subroutine, msgbox, and docmd.openform baring in mind to use acsaveno when closing.