Although Office 2010 Access Table Wizard provides a simple way to quickly createtables, it does not create the table to provide you with all aspects of the structure,complete control. It allows you to choose from a set list of fields used in the table, but it limits you only pre-defined fields (there are several types of fields, for different data types).
When you use the worksheet, you work in two different views: "Data Table" view and "design" view. Datasheet view is used to input, view and edit data. "Design" view can be used to create and edit the table structure. Start from scratch "design" view, create tables, allowing you to create a table from the bottom up, and provides you with all aspects of the design table full control.
Design view allows you to view the input field name, select a data type, will hold a field,each field of custom attributes. Design view is that all access to objects, including tables, forms, queries, and reports.
"Design" view is not the only way to create a table from scratch in Access. You can also create a table in Datasheet view labels directly on the table the table column to column;This method is similar to creating a download Office 2010 Excel worksheet. In bothmethods, we will take a look, create a new table.
Datasheet view this view places in a separate line, and in a separate column (column heading field name) of each field in each record. This view is used to directly enter data in the table. You want to view records in the table or add or edit records, you will use theDatasheet view.
No comments:
Post a Comment