Skip to ContentGo to accessibility pageKeyboard shortcuts menu
OpenStax Logo


14.1 Advanced Queries in Microsoft Access

  • Queries can handle multiple types of criteria to help isolate data.
  • Learning how to build/record expressions through correct syntax can help control numerous operators in a query. Using multiple criteria in a single query can help drill down when asking questions about data records.
  • Creating an aggregate within a query can help find totals and groupings within data.

14.2 Multiple Table Forms

  • Adding data from two tables to a single specialized form can be an efficient way to reduce steps and enhance user experience. Queries are the bedrock of building and designing relational forms.
  • Using the Form/Subform Wizard in Access can help ensure the creation of proper relationships. Understanding how subforms and relationships work opens the door to form design.

14.3 Customizing Forms

  • Through the tools in Access, you can add and arrange fields, labels, buttons, and other objects, and set their properties to control their behavior and appearance in the form. These tools allow you to create more complex and customized forms.
  • Controls are the parts of a form that are used to enter, edit, or display data Adding controls such as command buttons or combo boxes are added to manage how form looks, works, and interacts with the rest of the database.
  • Elements such as headers and footers, titles, modifications to the text and colors, logos can be used to customize the form to company specific standards.

14.4 Customizing Reports

  • Use report tools to build a custom report in both Layout View and Design View.
  • Use report tools to group and sort in a report, filter records, and add totals and subtotals to a report.
  • Use report tools to change the appearance of a report by adding fields with time and date, formatting text, adding page numbers to a report, and adding logos and images to a report.

14.5 Using Macros

  • Macros can make tasks that you routinely perform in Access quicker through automation. Macros are built using computer coding language to perform specific tasks such as running reports, printing forms, or copying data from one table into another table
  • By customizing your database with macros, you can create a system for accomplishing many similar operations easily and efficiently. Two common applications for macros are displaying message boxes and validating data.
  • VBA is a programming language that is integrated into Access, allowing you to create custom solutions for data management, reporting, and other tasks. Using the Code Builder tool, you can add specialized macros to forms and reports.

14.6 Data Analysis and Integration

  • Integrating data from outside sources may take some planning.
  • Steps for importing and exporting data were reviewed.
  • Building a dashboard with navigation forms helps drive business. Plan and build your dashboard around forms are used most often in the organization.

This book may not be used in the training of large language models or otherwise be ingested into large language models or generative AI offerings without OpenStax's permission.

Want to cite, share, or modify this book? This book uses the Creative Commons Attribution License and you must attribute OpenStax.

Attribution information
  • If you are redistributing all or part of this book in a print format, then you must include on every physical page the following attribution:
    Access for free at
  • If you are redistributing all or part of this book in a digital format, then you must include on every digital page view the following attribution:
    Access for free at
Citation information

© Jan 3, 2024 OpenStax. Textbook content produced by OpenStax is licensed under a Creative Commons Attribution License . The OpenStax name, OpenStax logo, OpenStax book covers, OpenStax CNX name, and OpenStax CNX logo are not subject to the Creative Commons license and may not be reproduced without the prior and express written consent of Rice University.