access+courses+in+london - What is the 1st normal form ?

The UK's most regular instructor-led training courses.
Training information: access+courses+in+london · Microsoft access courses · Microsoft Access Training uk
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

What is the 1st normal form ?

Simon has attended:
Access Intermediate course
Access Advanced course

by - delegate Simon [2 posts] (2007 Feb 27 Tue, 10:01) Reply

What is the 1st normal form ?

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Aug 21 Thu	Bloomsbury	0	FULL
2003/XP	2008 Sep 2 Tue	Southwark	4	book now	£207	£215
2003/XP	2008 Sep 9 Tue	Bloomsbury	6	book now	£193	£215
2003/XP	2008 Sep 11 Thu	Tooting	0	FULL
2003/XP	2008 Sep 19 Fri	Bayswater	5	book now	£195	£205
2007	2008 Sep 23 Tue	Bloomsbury	5	book now	£212	£224
Full Schedule: See all 74 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: What is the 1st normal form ?

by - trainer Carlos gold contributer [391 posts] (2007 Mar 5 Mon, 16:08) Reply

First Normal Form (1NF) sets the very basic rules for an organized database:

A table in 1NF:

Does not contain similar information in several fields

Does not contain fields in which the values can be further broken down into smaller parts eg. A field called Name can be broken down into FirstName and Last name.

· Microsoft Access Cheat Sheet: Tips and Shortcuts
· Microsoft Access Courses
· Want to Become the Office Hero? MS Project Training Could be the Answer
· Microsoft Access Training Unleashes the Power of the Pivot Table
· MS Access: Access your Personal Information with Ease

Access tip:

Open A Combo Box Automatically

This is helpful if users need to enter large amounts of data. There are two ways to open ComboBoxes when they get the focus by using the tab keys.

When the ComboBox gets focus:

Press Alt + Down Arrow on the keyboard

For it to happen automatically, needs a bit of coding:

1. Add a combo box and a text box control to the form
2. Set the combo box's On Got Focus property to the following event procedure:

Private Sub ComboBoxName _GotFocus()

Me!ComboBoxName.Dropdown

End Sub

3. Open your form in Form View and use the TAB key to make sure it works.