Jannie said:
Can someone help me to understand what my teacher in my "Database Management"
class means? This is what she said to me:
Create a checklist of items on a form you should test before releasing the
form into use. After creating your checklist, be sure to state why you
would test these elements of the form prior to releasing the form into use.
I dont understand what items she is talking about, reports and forms? or
Normalization Form, please help me understand and answer this.
Well, I googled for "Access form design checklist" and found this very
useful article:
http://www.fmsinc.com/tpapers/genaccess/formtips.html
Be careful, though - it's not uncommon for students to cut & paste from
the very same article that inspired the teacher to set the question, so
if you use this, attribute it! Plagiarism is usually rewarded with an F!
Your final paragraph sounds (frankly) a little incoherent, so I guess
you're right at the start line. So, just in case:
Access is a Relational Database, and like all RD's it has Tables for
storing data and Queries for selecting information from them. If you
have a table already, you can create a query easily using the Wizard.
"Normalisation" is the (vital) art of dividing up your data according to
certain golden rules (called "normal forms" by purists) - see this
tutorial, or google "normalisation" for others:
http://www.lynda.com/home/Player.aspx?lpk4=31001 (video)
Access also has Forms, which are used for interactive work, like
data-entry or searching. Forms contain "controls", like buttons and
drop-downs ("combo boxes"), and all these elements (including the Form
itself) can have program code associated with them by means of Events
(e.g. a button-click, or a form-load). If you have a query already, you
can easily create a form using the Form Wizard.
Reports are available to lay out results for printing. If you have a
query already, you can easily create a report using the Report Wizard.
How's that?
Phil, London
PS: See one of these:
http://office.microsoft.com/en-us/training/CR101582831033.aspx
http://office.microsoft.com/en-us/training/CR061829401033.aspx
PPS: Access Forms / Normal Forms - not the same meaning of the word "form"!