• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Quick Reference

Quick Reference

Chapter 1 Getting to Know Microsoft Access 2003

Page 4 To open an existing database

1.
On the taskbar, click the Start button, point to All Programs and then Microsoft Office, and click Microsoft Office Access 2003.

2.
Click the Open button on the toolbar, navigate to the folder that contains the database you want to open, and double-click the file name.

3.
If necessary, click Open to acknowledge the safety warning.

6 To view details about objects listed in the database window

On the toolbar at the top of the database window, click the Details button.

6 To view a table

1.
On the Objects bar, click Tables.

2.
Double-click the table you want to open in Datasheet view.

3.
To switch to Design view, click the View button on the toolbar.

10 To view a query

1.
On the Objects bar, click Query.

2.
Double-click the query you want to open.

3.
To switch to Design view, click the View button on the toolbar.

14 To open a form

1.
On the Objects bar, click Forms.

2.
Double-click the form you want to open.

3.
To switch to Design view, click the View button on the toolbar.

14 To display the Toolbox

On the toolbar, click the Toolbox button.

18 To open a report

1.
On the Objects bar, click Report.

2.
Double-click the report you want to open.

3.
To switch to Design view, click the View button on the toolbar.

22 To preview an object

1.
Open the object.

2.
On the File menu, click Print Preview.

22 To print an object

1.
Open the object.

2.
Click the Print button.

Chapter 2 Creating a New Database

Page 32 To create a new database by using the Database wizard

1.
If the New File task pane is not displayed, open it by clicking the New button on the toolbar.

2.
In the Templates area of the task pane, click On my computer, and then click the Databases tab to display the available templates.

3.
Double-click the template you want to use.

4.
Follow the steps of the Database Wizard, and click Finish to complete the process.

41 To create a table by using a wizard

1.
On the database window’s toolbar, click the New button to display the New Table dialog box.

2.
Double-click Table Wizard.

3.
Follow the instructions of the Table Wizard, and then click Finish to create and open the table.

44 To edit the property settings of a table

1.
Display the table in Design view.

2.
Click in the Data Type cell of the field you want to edit, click the down arrow, and then click the Data Type you want to set for the field.

3.
In the Field Properties area, click the General or the Lookup tab, click the property you want to edit, and enter the property, or select the property from the drop-down list of options.

51 To size a column to fit the longest entry

Point to the vertical bar between the column headers, and double-click.

51 To change the height of all rows in the table

On the left side of the datasheet, drag the horizontal bar between any two record selectors up or down.

51 To return the height of all rows to the default setting

1.
On the Format menu, click Row Height to display the Row Height dialog box.

2.
Select the Standard Height check box, and then click OK.

51 To hide a column

Click in the column, and then on the Format menu, click Hide Columns.

51 To restore a hidden field

1.
On the Format menu, click Unhide Columns to display the Unhide Columns dialog box.

2.
Select the check box of the field you want to display, and then click Close.

51 To freeze columns

With the columns selected, on the Format menu, click Freeze Columns.

51 To unfreeze columns

With the columns selected, on the Format menu, click Unfreeze All Columns.

Chapter 3 Getting Information Into and Out of a Database

Page 58 To import an Excel worksheet into an existing table

1.
On the File menu, point to Get External Data, and then click Import.

2.
In the Files of type list, click Microsoft Excel.

3.
Navigate to the folder that contains the worksheet, click the file, and then click Import.

4.
Follow the instructions on the Import Excel Worksheet Wizard, and then click Finish to complete the process.

61 To import information from a text file into an existing table

1.
On the File menu, point to Get External Data, and then click Import.

2.
In the Files of type list, click Text Files.

3.
Navigate to the folder that contains the information, click the file, and then click Import.

4.
Follow the instructions on the Import Text File Wizard, and then click Finish on the wizard’s last page to import the text file into the appropriate location, and then click OK to close the message box.

66 To import information from an Access database

1.
On the File menu, point to Get External Data, and then click Import.

2.
In the Files of type list, make sure Microsoft Access is selected.

3.
Navigate to the folder that contains the database, click the file, and then click Import.

4.
Click the Options button to select any import options you want.

5.
Select the objects you want to import, or click Select All to import all objects, and then click OK.

68 To import information from another database

1.
On the File menu, point to Get External Data, and then click Import to open the Import dialog box.

2.
In the Files of type list, click the database type you want to import.

3.
Navigate to the folder that contains the database, click the file, and then click Import.

4.
Follow the wizard’s instructions, and click Finish to complete the process, and then click OK.

69 To import information from an HTML file into an existing table

1.
On the File menu, point to Get External Data, and then click Import.

2.
In the Files of type list, click HTML Documents.

3.
Navigate to the folder that contains the HTML file, click the file, and then click Import.

4.
Follow the instructions on the Import HTML File Wizard, click Finish to complete the process, and then click OK.

71 To import information from an XML file into an existing table

1.
On the File menu, point to Get External Data, and then click Import.

2.
In the Files of type list, click XML.

3.
Navigate to the folder that contains the XML file, click the file, click Import, and then click the Options button to display the import options.

4.
Click the Options button to select any import options you want, and then click OK twice.

73 To export information to another program

1.
In the database window, click the table you want to export.

2.
On the File menu, click Export to display the Export Table To dialog box.

3.
Navigate to the folder where you want to store the exported file, select the appropriate Save as type option, type a name for the file, and then click Export.

76 To link a table in one database to another

1.
On the File menu, point to Get External Data, and then click Link Tables.

2.
In the Link dialog box, navigate to the folder that contains the database to which you want to link, select the appropriate Files of type setting, select the file, and then click Link.

3.
In the Link Tables dialog box, click the name of the table that you want to link to, and then click OK.

76 To link a database to an Excel worksheet

1.
On the File menu, point to Get External Data, and then click Link Tables.

2.
Navigate to the folder that contains the worksheet to which you want to link. In the Files of type list, click Microsoft Excel, select the worksheet, and then click Link.

3.
Follow the instructions of the Link Spreadsheet Wizard, click Finish, and then click OK.

78 To copy and paste Access data into an Excel worksheet

1.
Open the table in Datasheet view.

2.
Select the records you want to copy by pointing to the row selector of the first record you want to select (the pointer changes to a right arrow), holding down the left mouse button and dragging to the last record you want to select. Then on the toolbar, click the Copy button.

3.
Start Excel, and with cell A1 of a new blank worksheet selected, click the Paste button on Excel’s toolbar.

Chapter 4 Simplifying Data Entry with Forms

Page 84 To create a form by using a wizard

1.
On the Objects bar, click Forms.

2.
Double-click Create form by using wizard to display the first page of the Form Wizard.

3.
Follow the instructions of the Form Wizard, and then click Finish.

86 To change the properties in a form

1.
Display the form in Design view.

2.
Use the buttons and boxes on the Formatting toolbar to change the formatting of labels and controls.

3.
To change the properties of a control, in the form, right-click the control you want to change, and click Properties from the shortcut menu.

4.
Click the appropriate tab, click the property you want to change, and then change the property setting.

86 To change the background color of a label

1.
Open the form in Design view.

2.
Right-click the label you want to change, and then click Properties from the shortcut menu.

3.
Click the Format tab, click the Back Color ... button, select the color you want, and then click OK.

92 To rearrange or move the controls in a form

1.
Display the form in Design view.

2.
To resize a control, select it, and drag the left, right, top or bottom edge of the control.

3.
To move a control, select it, and when the pointer changes to a hand, drag it to its new location.

95 To add a graphic and a caption to a form

1.
Display the form in Design view.

2.
Click the Image control in the Toolbox, and then drag a rectangle in the location where you will add the graphic.

3.
Navigate to the folder that contains the graphic, and double-click the graphic file.

4.
To add a caption, click the Label control in the Toolbox, and then drag another rectangle in the location where you will add the caption.

5.
Type the caption, and press .

104 To create a form by using AutoForm

1.
On the Objects bar, click Forms.

2.
On the database window’s toolbar, click the New button.

3.
Click the AutoForm format that you want from the list, click the Table/Query down arrow, select the table or query on which you want to base the form, and then click OK.

4.
Click the Save button, enter a name for the form in the Save As dialog box, and then click OK.

106 To add a subform to a form

1.
Make sure the tables on which you want to base your main form and the subform have a relationship.

2.
Open the main form in Design view and if necessary, open the Toolbox and make sure the Control Wizards button is active (is orange).

3.
On the Toolbox, click the Subform/Subreport button, and drag a rectangle to the location on your main form where you want to insert a subform.

4.
Follow the instructions on the Subform Wizard, and click Finish on the wizard’s last page to complete the process.

5.
Adjust the size and location of the objects on your form as necessary.

114 To create a form and subform by using a wizard

1.
To create the form in your database, on the Objects bar, click Forms, and then click the New button on the database window’s toolbar.

2.
Click Form Wizard, select the form’s base table from the list at the bottom of the page, and then click OK.

3.
Verify that the table you selected is shown in the Table/Queries list and then double-click each field that you want to include in the new form to move it to the Fields in my new table list.

4.
To create the subform, display the Tables/Queries list, and select the table on which you want to base the subform.

5.
Double-click each field you want to add to the subform, and then click Next.

6.
Follow the instructions on the wizard, and then click Finish to create the form and subform.

Chapter 5 Locating Specific Information

Page 118 To sort a field in ascending or descending order

1.
Open the table in Datasheet view.

2.
Click anywhere in the column you want to sort, and then click the Sort Ascending or Sort Descending button.

3.
To reverse the sort order, click the opposite Sort button.

4.
To sort on more than one column of information, arrange the columns so that they are side-by-side in the order you want to sort them, select the columns, and then use the Sort buttons.

121 To filter a table by selection

1.
Open the table in Datasheet view.

2.
Click any instance of the selection by which you want to filter, and then click the Filter By Selection button.

121 To remove a filter

Click the Remove Filter button.

121 To exclude a field from a filter process

Right-click the field you want to exclude, and click Filter Excluding Selection on the shortcut menu

123 To filter by form in a form

1.
Open the table or form you want to work with in either Datasheet or Form view.

2.
Click the Filter By Form button on the toolbar.

3.
Click the field or fields in which you want to create the filter, type the filter criteria you want, and press ; or select the criteria from the list of options. (Repeat this step for any other fields you want to filter.)

4.
To add additional filter criteria for a particular field, click the Or tab and enter the criteria as necessary.

5.
Click the Apply Filter button.

126 To filter by multiple criteria

1.
Open the table in Datasheet view.

2.
On the Records menu, point to Filter, and then click Advanced Filter/Sort.

3.
If the design grid is not blank, on the Edit menu, click Clear Grid.

4.
Select the criteria by which to filter.

5.
On the Filter menu, click Apply Filter/Sort to view the records that match the criteria.

129 To create a select query in Design view

1.
On the Objects bar, click Queries.

2.
Double-click Create query in Design view.

3.
In the Show Tables dialog box, double-click each table that you want to include in the query, and then close the dialog box.

4.
To include a field in the query, drag it from the field list at the top of the window to consecutive columns in the design grid. To copy all fields to the grid, double-click the title bar above the field list to select the entire list, and then drag the selection over the grid.

5.
Click the Run button to run the query and display the results in Datasheet view.

129 To add an expression to a query

1.
Open the query in Design view.

2.
Right-click the appropriate cell in the design grid, and then click Build on the shortcut menu.

3.
In the Expression Builder dialog box, double-click the Functions folder in the first column of the elements area, and then click Built-in Functions.

4.
Build your expression, and then click OK.

5.
Press to move the insertion point out of the field, which completes the entry of the expression.

5.
To rename the expression, double-click Expr1, and then type the name you want.

6.
Click the Run button to run the query and see the results in Datasheet view.

138 To create a query by using a wizard

1.
On the Objects bar, click Queries, and then double-click Create query by using wizard.

2.
In the Tables/Queries list, click the table on which you want to base the query.

3.
Double-click each field that you want to include in the query to move it to the Selected Fields list.

4.
If you want to include more than one table in your query, repeat steps 2 and 3.

5.
Follow the instructions of the Simple Query Wizard, and then click Finish to complete the process and see the results.

6.
If you want to use a field in a query but don’t want to see the field in the results datasheet, click the View button to switch to Design view, and then clear the Show check box for fields you don’t want to display.

7.
Switch to Datasheet view to see the results.

140 To perform a calculation in a query

1.
Open the query in which you want to perform a calculation.

2.
Click in the field in which you want to perform the calculation, and then click the Totals button on the toolbar.

3.
In the new Totals cell for the field, click the down arrow, and then click the calculation you want to perform from the drop-down list.

Chapter 6 Keeping Your Information Accurate

Page 146 To specify data type settings

1.
Display the table in Design view.

2.
Click in the Data Type cell of the field you want to change, click the down arrow, and then click the data type you want.

150 To set a field’s size property

1.
Display the table in Design view.

2.
Click in the field you want to change, and then in the Field Properties area, click in the Field Size box, click the down arrow, and change the setting to what you want.

152 To create a custom input mask

1.
Display the table in Design view.

2.
Select the field for which you want to set an input mask, and in the Field Properties area, click Input Mask.

3.
Click the ... button to start the Input Mask Wizard. (Click Yes if you are prompted to first save the table or install this feature.)

4.
Select an input mask from the options, or enter your own input mask in the Try It box, and then click Next.

5.
Specify whether you want to store the symbols with the data, and then click Finish.

6.
Press to accept the mask.

157 To set a field validation rule

1.
Display the table in Design view.

2.
Select the field you want to add a rule to, and in the Field Properties area, click the Validation Rule box,

3.
Click the ... button at the right end of the Validation Rule box to open the Expression Builder, or type an expression and press .

4.
In the Validation Text box, type a description of the rule.

5.
Click in the Caption box, and indicate the type of entry that can be made in the field, by typing, for example, Phone Number.

6.
Save and close the table.

160 To use a Lookup List to restrict data

1.
Display the table in Design view.

2.
Click the Data Type cell for the field in which you want to use a Lookup List, click the down arrow, and then click Lookup Wizard.

3.
Select the option to either look up the values in a table or query, or to type in the values that you want, and click Next.

4.
Follow the wizard’s instructions, (which will be determined by your choice in step 3), and then click Finish.

166 To create and run an update query

1.
Create a query that displays the information you want and then open the query in Design view.

2.
On the Query menu, click Update Query.

3.
In the Update To row of the field you want to update, type the text you want, or create an expression.

4.
Click the Run button, click Yes when Access warns you that you are about to update records, and save and close the query.

170 To create and run a delete query

1.
Create a query that displays the information you want and then open the query in Design view.

2.
On the Query menu, click Delete Query.

3.
Type the text you want in the Criteria row under the appropriate field.

4.
Click the Run button to run the delete query and click Yes when Access warns you that you are about to delete records.

5.
Save and close the query.

Chapter 7 Working with Reports

Page 176 To create a report by using a wizard

1.
On the Objects bar, click the table on which you want to base your report.

2.
On the Insert menu, click Report to display the New Report dialog box.

3.
Double-click Report Wizard.

4.
Follow the instructions of the Report Wizard, and then click Finish to preview the report.

180 To change the height of a report section

1.
Open the report in Design view.

2.
Point to the top of the selector of the section you want to resize, and when the pointer changes to a two-headed vertical arrow, drag the selector up or down to expand or collapse the section.

180 To create a custom date format in a Report Header

1.
Open the report in Design view.

2.
Click the Toolbox button to open it, if necessary.

3.
In the Toolbox, click the Text Box control, and then click where you want to insert the date in the Report Header section.

4.
Click the label that was created with the new text box, and press to delete it.

5.
Click the text box, and then press the key to display the Properties dialog box.

6.
On the Data tab, click Control Source, enter your custom date format, for example: =Format(Date(), “dd,mm,yyyy”), and then press .

180 To add a group header or footer

1.
Open the report in Design view, and then click the Sorting and Grouping button on the toolbar.

2.
In the Group Properties area, double-click Group Header or Group Footer to change it to Yes.

180 To report properties

1.
Open the report in Design view.

2.
Select the control you want to modify, press to display the Properties dialog box, if necessary, and then click the appropriate tab.

3.
Click the property you want to change, and then enter new values, or select a new setting from the drop-down list.

186 To use a query as the basis for a report

1.
On the Objects bar, click Queries.

2.
Click the query on which you want to base the report.

3.
On the Insert menu, click Report.

4.
Click Report Wizard, and then click OK.

5.
Follow the wizard’s instructions, and then click Finish.

186 To insert a title in a report

1.
Open the report in Design view.

2.
If the Toolbox isn’t displayed, click the Toolbox button on the toolbar.

3.
To give the report a title, click the Label control in the Toolbox, and then click the top of the Report Header section.

4.
Name the report, and press .

5.
Scroll down, and set the label’s font properties.

6.
If necessary, on the Format menu, point to Size, and then click To Fit.

7.
Move the label to the location you want it.

186 To insert the date and time into a report

1.
On the Insert menu, click Date and Time to display the Date and Time dialog box.

2.
Make sure that Include Date is selected, and choose the date format you want. If you want to include the time, make sure that Include Time is selected, choose the time format, and then click OK.

3.
Drag the new text box containing =Date() to where you want it, and adjust its width and position as needed using the buttons and boxes on the Formatting toolbar.

186 To give a report a label

1.
Click the Label button in the Toolbox, click in the location on the report where you want the label, type the label name, and then press .

2.
Set the font properties for the label, and then fine-tune the position of the label, in necessary.

186 To insert a page number in a report

1.
In the Page Footer section, click Page Numbers on the Insert menu to display the Page Numbers dialog box.

2.
Select the options you want, and then click OK.

191 To add a subreport to a report

1.
Open the main report in Design view.

2.
Open the Toolbox, if necessary, click Subform/Subreport on the Toolbox, and then click on the report where you want to insert the subreport.

3.
Follow the instructions of the SubReport Wizard, and then click Finish.

191 To format a subreport

1.
Open the main report with the subreport in Design view.

2.
Click the subreport control, and press .

3.
Use the options in the Properties dialog box to make the necessary changes.

4.
Save your changes, and switch to Print Preview to view the results.

191 To use the Expression Builder in a text box in a report

1.
Open the report in Design view.

2.
Click an unbound text box control and press to open the Properties dialog box.

3.
Click the Data tab, click Control Source, and click the ... button to open the Expression Builder.

4.
Build your expression, and then click OK to close the Expression Builder.

5.
Press to enter the calculation in the unbound text box.

197 To preview a report in Print Preview or Layout Preview

1.
Open the report in Design view.

2.
Click the down arrow to the right of the View button to display the list of views.

3.
Click Print Preview or Layout Preview.

4.
On the Navigation bar, click the Next Page button to view each page of the report.

197 To print a report

1.
In the database window, click the report you want to print.

2.
On the toolbar, click the Print button.

Chapter 8 Making It Easy for Others to Use Your Database

Page 202 To open a Switchboard

On the Objects bar, click Forms, and then double-click Switchboard to open it in Form view. (Click the View button if you want to see it in other views.)

207 To create a splash screen

1.
On the Objects bar, click Forms, and then double-click Create form in Design view.

2.
Click the Save button, type a name in the Form Name box, and click OK.

3.
If the Properties dialog box is not already displayed, press .

4.
Set the form properties you want in the Properties dialog box.

5.
If the Toolbox is not displayed, click the Toolbox button, and then insert any objects you want to include on your splash screen, and format them as necessary.

6.
Save the design.

217 To create a backup of your database

1.
On the File menu, click Back Up Database.

2.
In the Save Backup As dialog box, navigate to the folder in which you want to store the backup, accept the file name Access provides, and click Save.

217 To run the Compact and Repair database feature

On the Tools menu, point to Database Utilities, and then click Compact and Repair Database, enabling macros when prompted.

217 To analyze performance

1.
Open the database you want to analyze, and then on the Tools menu, point to Analyze, and click Performance.

2.
To check the entire database, click the All Object Types tab.

3.
Click Select All, and then click OK to start the analyzer.

4.
Scroll through the list, click each entry in turn, and read through all the analysis notes, and click the Optimize button.

5.
Close the Performance Analyzer dialog box.

217 To run the Documenter

1.
On the Tools menu, point to Analyze, and then click Documenter.

2.
Click the All Object Types tab.

3.
Click Select All, and then click OK to start the documentation process.

Chapter 9 Keeping Your Information Secure

Page 226 To encrypt a database

1.
Open the database, and on the Tools menu, point to Security, and then click Encrypt/Decrypt Database.

2.
Navigate to the folder in which you want to store the encrypted file, name the encrypted file you are creating, and click Save.

226 To decrypt a database

1.
With the database closed, on the Tools menu, point to Security, and click Encrypt/Decrypt Database.

2.
In the Encrypt/Decrypt Database dialog box, navigate to the folder that contains the encrypted database, click the encrypted database file, and then click OK.

3.
In the File name box, type a name for the decrypted database, and click Save.

228 To assign a password to a database

1.
On the Database toolbar, click the Open button.

2.
In the Open dialog box, navigate to the folder that contains the database you want to assign a password to, and click the file name.

3.
Click the Open button’s down arrow, and then click Open Exclusive.

4.
On the Tools menu, point to Security, and click Set Database Password.

5.
In the Password box, type a password, and press .

6.
In the Verify box, type the password again, and then click OK.

7.
Close and reopen the database (you will have to type the password).

231 To share a database

1.
Open the database you want to share, and on the Tools menu, click Options to display the Options dialog box.

2.
Click the Advanced tab.

3.
In the Default open mode area, make sure that the Shared option is selected.

4.
Select the options you want, and then click OK to close the dialog box.

233 To replicate a database

1.
Right-click the desktop, point to New, and then click Briefcase on the shortcut menu.

2.
Rename the briefcase, and press .

3.
Click the Windows Start button, and navigate to the folder that contains the database you want to replicate.

4.
Reduce the size of the window, and position it so that you can see both the database file and briefcase on your desktop.

5.
Drag the database to the briefcase.

6.
Click Yes to continue.

7.
Click Yes to have Briefcase make a backup copy of your database.

8.
Click OK to accept the option to allow design changes only in the original copy of the database and to finish the replication process.

238 To split a database

1.
Open the database you want to split, and on the Tools menu, point to Database Utilities, and click Database Splitter.

2.
Click Split Database.

3.
In the Create Back-end Database dialog box, navigate to the folder where you want to store the database components. In the File name box, type the name you want, and then click Split.

240 To create a workgroup

1.
Open the database, and on the Tools menu, point to Security, and then click User-Level Security Wizard.

2.
On the first page of the Security Wizard, click Next to create a new workgroup information file (WIF).

3.
Replace the text in the WID box by selecting it and typing a new workgroup ID.

4.
Accept the default selection to create a shortcut to open the security-enhanced database, and click Next.

5.
Click Next to accept the default selections and secure all objects.

6.
Select the check boxes for Full Data Users and New Data Users, and then click Next.

7.
Click Next.

8.
To add users to the list, in the User name box, type a name of a user, in the Password box, type a password, and then click Add This User to the List.

9.
Click Next.

10.
Click Finish in the wizard’s final page to accept the default name for the backup copy of your unsecured database.

253 To secure the VBA code in a database

1.
With the database open, press to open the VBA Editor.

2.
On the VBA Editor’s Tools menu, click the Properties command for the database you have open.

3.
In the Project Properties dialog box, click the Protection tab, and click the Lock project for viewing check box.

4.
In the Password box, type a password, and press .

5.
In the Confirm Password box, type the password again, and then click OK.

6.
Press to return to Access, and then close the database.

254 To convert a database to Access 2002-2003 format

1.
With the database you want to convert closed, on the Tools menu, point to Database Utilities, point to Convert Database, and click To Access 2002 – 2003 File Format.

2.
In the Database to Convert From dialog box, navigate to the folder that contains the database you want to convert, and double-click the file name.

3.
In the File name box, type a name for the converted database, and click Save.

4.
Click OK.

254 To secure a database by saving it as an MDE file

1.
Make sure the database you want to secure as an MDE file is first converted to Access 2002-2003 format.

2.
With the database closed, on the Tools menu, point to Database Utilities, and click Make MDE File.

3.
In the Database To Save As MDE dialog box, navigate to the folder that contains the file you want to save as an MDE file, click the file, and then click Make MDE.

4.
In the File name box, type a name for the file, and then click Save.

Chapter 10 Working with Pages and Modules

Page 261 To convert a report to a set of static Web pages

1.
On the Objects bar, click Reports, and double-click the report you want to convert.

2.
On the File menu, click Export to display the Export dialog box.

3.
Navigate to the folder where you want to save the Web pages, in the File name box, type a name for the pages, in the Save as type box, click HTML Documents, select the Autostart check box, and then click Export.

4.
In the HTML Output Options dialog box, make sure the Select a HTML Template check box is cleared, and then click OK.

5.
If you don’t see the HTML page, click the file name on the taskbar to display it. Click the Next hyperlink to scroll through the pages of the file.

276 To create a data access page with AutoPage

1.
With the database open, on the Objects bar, click Pages.

2.
On the database window’s toolbar, click the New button to display the New Data Access Page dialog box.

3.
Click the AutoPage option you want, display the list of tables and queries, click the table or query you want, and then click OK.

4.
Click the Save button on the toolbar to save your new page.

5.
In the Save As Data Access Page dialog box, navigate to the folder where you want to store the file, give the file a name, and click Save.

6.
If Access warns you that the connection string for this page uses an absolute page, click OK to dismiss the message. (A UNC path is appropriate if you are using a file on a network computer.)

283 To create a data access page with the Page Wizard

1.
With the database open, on the Objects bar, click Pages.

2.
At the top of the database window, click the New button.

3.
In the New Data Access Page dialog box, click Page Wizard. In the list of tables and queries, click the table on which you want to base the data access page, and then click OK.

4.
Click the ≫ button to move fields from the Available Fields list to the Selected Fields list, and then click Next.

5.
Double-click CategoryName, and then click Next.

6.
In the first sort box, click ProductName, and click Next.

7.
Select the Do you want to apply a theme to your page check box, and click Finish.

287 To create a data access page by hand

1.
With the database open, on the Objects bar, click Pages.

2.
Double-click Create data access page in Design view to open a blank data access page.

287 To add a PivotTable to a data access page

1.
Open the data access page that you want to add a PivotTable to in Design view.

2.
If the Field List is not displayed, click the Field List button on the toolbar.

3.
Make sure the Toolbox is open, click the Office PivotTable tool, and then click a blank section of the upper-left corner on the page.

4.
Click in the PivotTable, and then double-click its frame to open the Properties dialog box.

5.
Click the Other tab, click the DataMember property, select the table or query on which the PivotTable will be based from the list, and close the Properties dialog box.

6.
In the Field List, select the same table or query.

7.
Drag a field from the Field List to the horizontal box labeled Drop Filter Fields Here.

8.
Drag a field to the vertical box labeled Drop Row Fields Here.

9.
Drag a field to the horizontal box labeled Drop Column Fields Here.

10.
Drag a field to the box labeled Drop Totals or Detail Fields Here.

11.
Click the View button to switch to Page view, and experiment with the PivotTable to make sure it works.

12.
Save the page.

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint