Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Access

Resolved · Low Priority · Version 2003

Reply Tue 27 Jan 2009, 11:42Delegate parveen said...

parveen has attended:
Access Introduction course

Access

What is the difference between a form and a atable?

For upcoming training course dates see: Pricing & availability

Reply Wed 28 Jan 2009, 16:35Trainer Rajeev said...

RE: Access

Dear Parveen

Thank you for attending Access Introduction course!! I hope you enjoyed the course and benefited from it.

Table is the data that is arranged in rows and columns (as a Grid)

Forms are user friendly way of inputting or viewing the records which may be in your existing tables.

Simply put forms are a friendlier way of looking and entering data in your tables.

Normally you would create a table from scratch and then for others to input data in more user-friendly way you would create a form based on that table.

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007

Tue 3 Feb 2009: Automatically marked as resolved.

Access articles

· Three Myths About Microsoft Access
· Protect Sensitive Access Databases With A Password
· How To Use Referential Integrity In Microsoft Access
· So You Want To Create Forms In Access 2007?
· Microsoft Access Courses

Please browse our web site to find out more about
microsoft database training and other Microsoft training 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