Access+using+existing+fields+or+query


 * Home / software / microsoft access / Tutorials

Practical Learning: Using Existing Fields of a Table or Query ||
 * 1) Open the Bethesda Car Rental1 database
 * 2) On the Ribbon, click Create
 * 3) In the Reports section, click Blank Report
 * 4) To switch the report to Design View, right-click it and click Design View
 * 1) To switch the report to Design View, right-click it and click Design View

> If the Add Existing Fields button is not highlighted, click it. > On the form, double-click the button at the intersection of both rulers to display the Properties window of the report
 * Practical Learning: Accessing the Fields List ||
 * 1) On the Ribbon, click Design if necessary.
 * 1) On the Ribbon, click Design if necessary.
 * 1) In the Properties window, click the Data property page
 * 2) Click the arrow of the **Record Source** button and click Company Assets
 * 3) On the Ribbon, click the Add Existing Fields button and notice that the Field List is now equipped with fields
 * 4) To save the report, right-click the Report1 title bar and click Save
 * 5) Set the Name to **Company Assets** and press Enter

> In the Field List, click Date Acquired and hold your mouse down > > > > > From the Field List, double-click the items in the following order: Date Acquired, Category, Make, Model, CompanyAssetID, and Purchase Price
 * Practical Learning: Inserting Fields ||
 * 1) The Company Assets report should still be opened in Design View with the Field List
 * 1) The Company Assets report should still be opened in Design View with the Field List
 * 1) Then drag it (Date Acquired) from the Field List and drop it in the middle left area of the report
 * 1) In the Field List, click Category
 * 2) Press and hold Shift, then click Model, and release Shift. This allows you to select a range of fields
 * 3) Click and hold the mouse on the selection. Then drag and drop it under the Date Acquired field on the report
 * 1) To select fields at random, in the Field List, click Purchase Price
 * 2) Press and hold Ctrl
 * 3) Click CompanyAssetID
 * 4) Release Ctrl
 * 5) Click and hold the mouse on one of the selected items, such as Purchase Price
 * 6) Drag and drop in the upper right area of the report
 * 7) To save the report, press Ctrl + S
 * 8) In the Ribbon, click Create and, in the Forms section, click Blank Form
 * 9) To save the form, right-click its title bar and click Save
 * 10) Set the Name to **Company Assets1** and press Enter
 * 11) To switch it to Design View, right-click its title bar and click Design View
 * 12) Using the Properties window, set its Record Source to Company Assets
 * 13) Display the Field List.
 * 1) Save and close the form