How to Use the Wizard to Add the Table to the Microsoft Access Database

Posted on January 15th, 2011 in Common Technique by admin

Step1 Open your database in Access.

Step2 Click the F11 pass to shift to the Database window.

Step3 Click upon the Tables tab. Click New.

Step4 Double-click upon Table Wizard. Click OK.

Step5 Check commercial operation or personal to collect the list of list names. Select the list name which is closest to the a single we want. You can rename both the list as well as the fields after if we wish to.

Step6 Select the representation fields which we want, afterwards click upon the right arrow to pierce them in to the Fields window. If we wish to operate all of the fields, click upon the stand in right-arrow (>>) sign. If we shift your thoughts as well as wish to mislay the field, name the margin from the Fields window, afterwards click upon the left arrow to pierce it back.

Step7 Rename the fields if desired. Click Next.

Step8 Name your latest list as well as prove either we wish Access to allot the “primary key,” or singular identifier, to any record. Primary keys have been accessible if we wish to do formidable queries after on.

Step9 Indicate either your latest list is associated to any existent tables (if it shares fields, for example, with existent tables). Click Relationships to shift the approach your tables have been related. Click Next.

Step10 Indicate either we wish Access to open the list rught away after formulating it, either we wish to come in interpretation in to the list without delay or either we wish the Wizard to emanate the form which allows we to come in data.

Step11 Click Finish.


Article Source: レジストリクリーナー

Post a comment