microsoft-access-courses - How to modify the design of a form?

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

Resolved · Low Priority · Version Standard

How to modify the design of a form?

Patrick has attended:
Excel Introduction course
Access Introduction course

by - delegate Patrick [2 posts] (2007 Mar 8 Thu, 09:44) Reply

how to modify the design of a form in access?

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 25 Tue	Bloomsbury	4	book now	£207	£215
2002/XP	2008 Nov 26 Wed	Tooting	0	FULL
2003	2008 Dec 2 Tue	Southwark	5	book now	£198	£215
2007	2008 Dec 5 Fri	Bloomsbury	4	book now	£224	£224
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
Full Schedule: See all 55 Access Intermediate course dates. Bookings currently available until 24th November 2009.

How to modify the design of a form in MS Access

by - trainer David gold contributer [428 posts] (2007 Mar 8 Thu, 13:18) Reply

Hi Patrick

I hope you enjoyed both your MS Excel and Microsoft Access courses.

To modify the design of a form in Microsoft Access you need to open the form, go into design view. Once in design view you will be able to modify the form.

Hope this Helps

David

· How To Find Good Access Database Courses In London
· Convert a Paper Trail to a DBMS
· Microsoft Access as a Business's Database Management System
· Microsoft Access Beginners' Training: Getting to Grips with Databases
· Microsoft Access Courses

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips