Why is the use of forms important in a database application

[jathayer]

Why is the use of forms important in a database application???

Cheers

Jat

 

[Mile-O]

It allows you to create a customised user interface and stops the end user getting into the backend of the database and messing about with data structures etc..

 

[jathayer]

More please

Could you fill in the etcs for me please

 

[Mile-O]

What I mean is that by having a full form-based user interface, you can prevent the enduser getting access to the database window where they could get into the database structure itself and cause damage - they could delete tables, queries, forms, macros, modules, relationships and reports , they could edit them with hazardous consequences such as changing data types in tables.

All in all, forms are great for creating a user interface and excellent for displaying information rather than just looking at a table and filling in line after line.

 

[jetson]

Here's another twist. Forms are not necessary. By that I mean that you can create a set of tables, ADD, EDIT, and DELETE rows to your hearts content. Create queries like there's no tomorrow. Import and export with other Office and ODBC products. And basically have great success.
Assuming you really don't need to protect anything and you have no need to make things "easier" through user interfaces (forms), Access works quite nicely as a quick and dirty database.

I wouldn't really try to go formless if my database was very complex as far as the design. Of course, what's the fun in a database without custom forms!