Access 2019 For Dummies by Laurie A. Ulrich & Ken Cook
Author:Laurie A. Ulrich & Ken Cook
Language: eng
Format: epub
ISBN: 9781119513285
Publisher: Wiley
Published: 2018-10-09T00:00:00+00:00
Filter by Form
You can tighten a search by using additional filters to weed out undesirable matches, but that takes a ton of extra effort. For an easier way to isolate a group of records according to the values in more than one field, try Filter by Form.
Filter by Form uses more than one criterion to sift through records. In some ways, it’s like a simple query. (What’s a query? See Chapter 13.) It’s so similar to a query that you can even save your Filter by Form criteria as a full-fledged query!
Suppose, for example, that you need a list of all the employees at your company who work in a certain department and have a particular title. You can perform two Selection filters (on the Department and Job Title fields, using the employee database as an example) and write down the results of each to get your list; or you can do just one search with Filter by Form and see all the records that meet your criteria (based on their entries in multiple tables) in a single step.
To use Filter by Form, follow these steps:
On the Ribbon’s Home tab, click the Advanced button in the Sort & Filter section.
A menu appears.
Download
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.
Algorithms of the Intelligent Web by Haralambos Marmanis;Dmitry Babenko(8332)
Azure Data and AI Architect Handbook by Olivier Mertens & Breght Van Baelen(7022)
Building Statistical Models in Python by Huy Hoang Nguyen & Paul N Adams & Stuart J Miller(7009)
Serverless Machine Learning with Amazon Redshift ML by Debu Panda & Phil Bates & Bhanu Pittampally & Sumeet Joshi(6891)
Data Wrangling on AWS by Navnit Shukla | Sankar M | Sam Palani(6674)
Driving Data Quality with Data Contracts by Andrew Jones(6638)
Machine Learning Model Serving Patterns and Best Practices by Md Johirul Islam(6367)
Learning SQL by Alan Beaulieu(6030)
Weapons of Math Destruction by Cathy O'Neil(5824)
Big Data Analysis with Python by Ivan Marin(5506)
Data Engineering with dbt by Roberto Zagni(4516)
Solidity Programming Essentials by Ritesh Modi(4162)
Time Series Analysis with Python Cookbook by Tarek A. Atwan(4033)
Pandas Cookbook by Theodore Petrou(3735)
Blockchain Basics by Daniel Drescher(3326)
Hands-On Machine Learning for Algorithmic Trading by Stefan Jansen(2925)
Feature Store for Machine Learning by Jayanth Kumar M J(2833)
Learn T-SQL Querying by Pam Lahoud & Pedro Lopes(2820)
Mastering Python for Finance by Unknown(2759)
