Figure 15.1 Using different programs to meet your business needs is a common practice. Many programs are designed to work together. (credit: modification of “Team Having a Meeting” by Mikael Blomkvist/Pexels, CC0) Chapter Outline 15.1 Microsoft 365: Collaboration and Integration 15.2 Microsoft Word: Integration…
Advanced Queries in Microsoft Access Multiple Table Forms Customizing Forms Customizing Reports Using Macros Data Analysis and Integration
Learning Objectives By the end of this section, you will be able to: Now that you are comfortable with building and maintaining databases, it is time to start talking about integration. Suppose you have one database that controls all accounting…
Learning Objectives By the end of this section, you will be able to: A macro is a set of instructions that can automate repetitive tasks or perform complex operations with a single click. Macros can be created using the Macro Builder, which provides…
Learning Objectives By the end of this section, you will be able to: Reports offer a way to view, format, and summarize the information in your Access database. For example, at WorldCorp, you can create an invoice for all your…
Learning Objectives By the end of this section, you will be able to: WorldCorp has manufacturing locations in the United States, China, and Germany, with headquarters in key metropolitan areas in those same countries. Smaller functional units are located in…
Learning Objectives By the end of this section, you will be able to: Much like any global manufacturing corporation, we have an extensive list of assets that include company vehicles, equipment, and facilities to operate and manage. At WorldCorp, when…
Learning Objectives By the end of this section, you will be able to: As your database continues to evolve, the incorporation of advanced queries aids in the management and manipulation of the exact data of interest. For example, at WorldCorp,…
Figure 14.1 As businesses grow, they often need to use more advanced features in Microsoft Access for complex database design and querying to help with tasks like managing inventory. (credit: modification of “Man in Black and Gray Plaid Dress Shirt Holding Black…
What Is a Database? Microsoft Access: Main Features and Navigation Querying a Database Maintaining Records in a Database Creating Reports in Microsoft Access Creating Forms in Microsoft Access