Microsoft Access: Tips and Tricks

  1. How to Create a Form with the Form Wizard in Microsoft Access

    The Form Wizard gives you more control over your results than one-click forms do. The wizard lets you make decisions about certain aspects of a form's design and produces a form based on your instructions. To create a form based on a single table using the Form Wizard, follow these nine steps.

  2. How to Create a Report with the Report Wizard in Microsoft Access

    Similar to the Form Wizard, the Report Wizard walks you through a series of decisions in order to build a report. To create a report using the Report Wizard, follow the steps below.

  3. How to Add a Header and Footer to a Form in Microsoft Access

    You can add header and footer sections to a form in Access in just a few simple steps.

  4. How to Add a Header and Footer to a Report in Microsoft Access

    You can add header and footer sections to a report in Access in just a few simple steps.

  5. How to Open a Table in Design View in Microsoft Access

    While Datasheet view lets you work directly with the data in tables, Design view takes you behind the scenes to work with the table structure. In Design view you have much finer control over how the fields in your data are defined and validated. You can open a closed table in Design view with just a few clicks.

  6. How to Rename a Table in Microsoft Access

    There will be times when you must rename a table. Before you do, please be aware that any objects that are dependent on the table will need to be updated as well. Access does not rename references for you as other technologies do.

  7. How to Move a Field in the Query Grid in Microsoft Access

    You can move fields in the query grid to rearrange them.

  8. How to Create a Navigation Form in Microsoft Access

    Make the user experience with an application as streamlined as possible by creating a navigation form that presents the main functions of a database in a straightforward and logical way.

  9. How to Add a Logo to a Form Header in Microsoft Access

    Follow these seven steps to add a logo to the header of an Access form.

  10. How to Add a Title to a Form Header in Microsoft Access

    Follow these four steps to add a title to an Access form header.

  11. How to Set the Navigation Form as the Default Form in Microsoft Access

    You can set the navigation form as the default form that displays when a user opens your application in Access. In addition, you can give the application an official name and an icon to display for forms and reports.

  12. How to Run a Macro from a Navigation Button in Microsoft Access

    You're not limited to running forms and reports from the navigation form. You can use navigation buttons to run macros as well, thus opening the range of functionality to any process you can write a macro or module for.

  13. How to Add a Title to a Report Header in Microsoft Access

    Follow these five steps to add a title to an Access report header.

  14. How to Add a Logo to a Report Header in Microsoft Access

    Follow these seven steps to add a logo to an Access report header.