Audiosoft Forums : EJukebox Last active: Never
Not logged in [Login - Register]
Go To Bottom

Printable Version | Subscribe | Add to Favourites   Post new thread Poll:
Author: Subject: Simple queries for office setup |
Junior Member

Posts: 35
Registered: 4-4-2019
Location: usa
Member Is Offline

posted on 5-15-2019 at 09:02 AM Edit Post Reply With Quote
Simple queries for office setup |

If you are not yet familiar with Microsoft Access queries, here’s a little bit of explanation. A query is simply the term used when you want to mine some information from your database. Let’s say you want to know how many units of computers you sold last year, creating a Microsoft Access query will get you this information.( In essence, queries are questions that your data has the answers for. While there are many simple queries to choose from, some queries can be quite complex when summing and grouping of data are what you after.
To help you identify the qualifiers that you can use, you should know the data types for each field on your Microsoft Access database, especially those that you want to include in your report. For example, Date, Number or Text. To make sure that you have all the fields required, get a piece of paper and write all the names of the tablets and their fields that you want on your final query report.( way – you can see how they relate. When querying, you can add the fields first without marking any criteria. This test query will help you get the total number of records being shown. This will also help you confirm that there’s no error. You can then add one criteria option one at a time. This will save you time should you encounter any error – as you can pinpoint the culprit Setup

View User's Profile Visit User's Homepage View All Posts By User U2U Member
Post new thread Poll:

Go To Top

Audiosoft Home | Download EJukebox for Windows | Register EJukebox
©2016 Audiosoft Network. All rights reserved.
[queries: 16]
HTML5 Color Picker for CSS Opacity
Short Url Service with Stats