Want this question answered?
Design view.
Design view.
Design View
One of the views a form has is Design View. It is used when designing the form, so it does not show the actual data. There is also a view called Form View, which shows the data.
table design
create tab
A data sheet view shows the data in the database. It allows you to enter and edit the data, but you cannot change the format of the database. Design view allows you to create or change the table, form or any other database object.
Within Access you can create various things like tables, forms, reports, queries and pages for the internet. These all have to be designed. So each of them has a design view mode enabling you to do the work you need to create them. Once they are designed there are modes that enable you to use them. So having designed a form you can then go into Form View and use the form to display records. Having created a query in design view, you can then run the query and see the output it produces. Your reports can list data and your Tables can have data entered into them and stored there, all after they have been designed. If you need to change the design of any of these things you can go into the design view and make the adjustments you need, like adding a new field to a table, or changing the background colour on a form.
by using the query wizard or design view
In the design view of a query, report, page or form you can do it, but not in the design view of a table.
by using the query wizard or design view
If you create it in Design View, no field name is given. If you create it in Datasheet View it is called Field1.