How to Create an Access Query with an And Condition

Creating a query with an And condition allows you to search for information in your database with multiple criteria. Here's how:

1. Click on the Create ribbon at the top of the Access window.

2. Click on Query Design.

3. Choose the table or query you would like to search (see the picture below).

4. Close the Show Table once you've selected your table or query.

5. Choose what you want to place in the query grid at the bottom of the screen. You can select, drag, and drop individual categories from the table you've selected, or you can double click on the table name (in the picture below, EmployeeInfo) to highlight all the fields in the table and drag them down to the query grid. Simply drag the highlighted information to the first grid column.

6. Fill in your criteria. By filling in criteria along the same criteria line, you are asking an And condition. In the example below, the query will pull results for a person who is both in the Sales Department and a Clerk.

It's as easy as that! You can also create queries with Or conditions to bring in information that is different from one another at the same time (for example, people who are in the Sales Department or a Clerk). For demonstrations on how to use Access, check out our courses on Access 2010 Introduction, Advanced, and New Features, and be sure to take advantage of the first 3 FREE previews of each.

Read More

New Courses Posted: Access 2010

To go along with the rest of the new Microsoft Suite, we are pleased to announce that our new set of courses on Access 2010 is posted. In step-by-step demonstrations, Instructor Irasema Perrot guides beginning to advanced users through the features of Access 2010. Access is such a useful program: it allows you to organize your data into neat, easy-to-use databases. You can find specific information in your database by creating and running searches called queries. If you've already started using the program and want more information, here are some of the most frequently asked questions regarding Access 2010. Also, make sure to take advantage of our free previews on how to get started using Access.

Tip: If you're using Access to store people's information, such as addresses, running a query can be a great way to pull up information for people you want to send holiday cards to. It's easy to make labels from your query results—say goodbye to hours of sorting through your client/contacts/family info and handwriting or typing up labels. With Access, you've already got the information set up and ready to use whenever you may need it.

Read More

Tools Needed for Accounting Majors

To be an accountant means to provide organization, summarization, and interpretation of financial information for companies. College students who wish to play a critical role within a business organization as an accountant needs to be computer literate and be thoroughly knowledgeable in business mathematics.

Computer literacy is a necessity for an accountant’s performance. Being able to understand the basic functions, hardware, software, and operating system commands is immensely important for most operations are performed on a computer setting. Although most college students these days are fully aware of a computer’s capability, there are computer literacy training tutorials for accounting majors who went back to school later on in life when computers were not the prevalent tool in the work or academic force.

Basic mathematics wouldn’t just do in terms for an accountant. Since accounting is all about mathematics in a business environment, business mathematics is a separate entity than regular math taught in academia. Online training tutorials are available to learn more on what mathematical applications pertain in a business context.

Read More