Forms

[Jannie]

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.

 

[fredg]

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.

I hate to be the bearer of bad tidings, but you are the one in the
class. If the teacher gives an assignment and you don't understand it,
the person to ask is the teacher. That's what she gets paid for. None
of us here know what your instructor had in mind, so while any of us
could guess, it still might not do you any good.
Ask your instructor!

 

[Jeff Boyce]

Jannie

"items on a form" may mean the controls you've added to a form (i.e., the
textboxes, listboxes, etc.)

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Philip Herlihy]

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"!

 

[Jannie]

For all that responded, thank you, I was able to figure it out, she meant the
appearance of the form and how the form works, like, if an error was typed
in, what would happen. I get it now, sorry for being blonde!

 

[Jannie]

Nevermind, I get it now! The appearance and how the form works, for instance,
you would test what would happen if an error was entered, and also, the
layout of the form. OK OK I get it! Duh!

 

[Jannie]

Thank you Jeff, so its more less the appearance and how the form works in
general. Thanks thats all I wanted to know.