advanced excel class - List management

The UK's most regular instructor-led training courses.
Training information: advanced excel class · Excel course · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

List management

Rafael has attended:
Excel Advanced course

by - delegate Rafael [1 post] (2007 Oct 26 Fri, 13:03) Reply

How do I convert my database list in to a form?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2009 Jan 8 Thu	Bloomsbury	2	book now	£215	£215
2007	2009 Jan 8 Thu	Bloomsbury	3	book now	£224	£224
2007	2009 Jan 12 Mon	Bayswater	3	book now	£224	£224
2007	2009 Jan 13 Tue	Bloomsbury	1	book now	£224	£224
2002/XP	2009 Jan 13 Tue	Tooting	0	FULL
2003	2009 Jan 15 Thu	Southwark	1	book now	£215	£215
Full Schedule: See all 136 Excel Intermediate course dates. Bookings currently available until 30th March 2010.

RE: List management

by - trainer Amanda diamond contributer [1297 posts] (2007 Oct 29 Mon, 14:21) Reply

Hi Rafael

Thank you for your question.

You can use a form interface in Excel to enter or edit information stored in an Excel list/database.

To enter data through a form interface:
1. Go to Data - Form.
2. Click the New button on the right hand side to add another row/record of information to the list/database.
3. Click Close.

To search for and edit a row/record:
1. Go to Data - Form.
2. Click the Criteria button on the right hand side.
3. Type in the criteria you are looking for from a specific field or fields.
4. Click the Find Next button to display the next row that contains the criteria you have searched for.
5. Edit the row/record information if you wish.
6. Click Close.

I hope this helps.
Amanda