Finding & Organizing Data in Access 2019 for Windows
Access 2019 (Windows)
| Intermediate
- 6 videos | 22m 35s
- Includes Assessment
- Earns a Badge
- CPE
There are multiple ways to find or search for elements and Access allows you to adapt your view on fields by sorting and filtering data values. This 6-video course, "Access 2019: Finding and Organizing Data," allows learners to discover how to sort, filter, find, and replace features available in Access 2019. This process will enable you to save time and locate the information you need most within your Access database values. To begin, you will learn how to sort the data in the data tables, and then filter the data in the data tables. Explore how to search and locate data values, which is useful if you have a large number of records in your data table. Also, you will discover how to replace data values. Creating an index in Access can help find a value or record more quickly, which is particularly useful if a data table contains a large number of records; learners will also observe how to edit database indexes. Conclude with a look at finding duplicate values in a database.
WHAT YOU WILL LEARN
-
Sort data in tables
Filter data in tables
Locate data values in tables -
Replace data values
Edit database indexes
Find duplicate values in a database
IN THIS COURSE
-
3mIn Access; you can sort the data that you have added to your data tables. This can help you to find records more easily. You can use any of the fields that you have created to sort your data: you can also sort your data alphabetically or in ascending and descending order. You can even apply multiple sort criteria simultaneously. FREE ACCESS
-
5m 2sAnother way of finding your data more easily if to use the Access filter tools. Filtering allows you to temporarily hide records according to set criteria. This can help you to focus on specific data values. In Access, you can create filter rules, visualize date ranges, and even hide numerical values below or above a certain figure. FREE ACCESS
-
3. Locating a data value in Access 2019 for Windows4m 15sIf you have a large number of records in your data table, you can use the search function to find the value you are looking for. This search function can be configured to search for values with particular properties. FREE ACCESS
-
4. Replacing data values in Access 2019 for Windows3mIf you have made a mistake when inserting a record or data value into your Access 2019 table, you can use the find and replace tools to correct it. Rather than manually replacing values, you can create a search query that will automatically find and replace a specified value. FREE ACCESS
-
5. Editing database indexes in Access 2019 for Windows4m 14sIn Access, creating an index can help you to find a value or record more quickly. This is particularly useful if your data table contains a large number of records. Primary key fields are automatically indexed, but you can also choose to index other fields in your data table. FREE ACCESS
-
6. Finding duplicates in your database in Access 2019 for Windows3m 3sAccess features a special query that can be used to find record duplicates in specified data tables. It is extremely important to avoid creating duplicates in your database as this can not only make your database bloated but can also distort your analysis reports. The Access query can help you to root out any duplicates and remove them quickly from your database. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.YOU MIGHT ALSO LIKE
Book
Access For Dummies
