Getting started with Access tutorial 6.4 insert, delete, and move fields in a table

Source: Internet
Author: User
If you forget something when creating a table, you can add it again. You only need to add another field to the original table. You can add and delete fields in an existing table. You can add a "company address" field between "company name" and "contact name. First

If you forget something when creating a table, you can add it again. You only need to add another field to the original table. You can add and delete fields in an existing table. You can add a "company address" field between "company name" and "contact name. First


If you forget something when creating a table, you can add it again now, as long as you add anotherFieldYou can. You can add not onlyFieldAnd can alsoDeleteField.

We can go to "company name" and "contact name"FieldAdd a company address between them"Field. First put the mouseMobileTo "contact name"FieldIn the left-side navigation pane.InsertColumn "command. In this way, the "contact name"FieldFrontInsertA newField. NewInsertOfFieldThe name is"Field1 "instead of" company address ", because we have not specified a name for it,"Field1 "is the name automatically given by Access. To changeFieldName, you can move the mouseMobileTo"Field1 ", double-click the left mouse button to change the title. Set"FieldChange the word "1" to "company address", and then press the Enter key on the keyboard. In this way, "company name" and "contact name" are twoFieldThere is an additional address called "company address" between them.Field.

Getting startedTutorialTable 6.4Insert,DeleteAndMobileField"/>

ToDeleteAField, You can move the mouseMobileTo thisFieldAt this time, the mouse becomes the downward arrow, right-click to select thisField, EntireFieldBlack and a menu is displayed. Click"DeleteColumn ", then a dialog box is displayed, asking whether you are sureDeleteThisFieldAnd its data. Click "yes" toField1"Delete. HoweverDeleteFieldNote thatDeleteOneFieldAt the same timeFieldAll values inDeleteTherefore, when performing this operation, you must make it clear to avoid the loss of useful data due to accidental deletion.

If you want to adjust the "zip code" in the data table"FieldFirst place the mouseMobileTo "zip code"FieldIn the left-side navigation pane.FieldAfter it turns black, hold down the left mouse button and drag itFieldClick the back of "company address" to release the left button.FieldJustMobileGo to the end of "company address.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.