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

Welcome, Word 2010!

After a three year wait, the newest version of Microsoft Word is finally here! Discover the new layout of Word 2010, with the return of the File tab (which you may remember from Word 2003) in place of the 2007 Office button.

With this newest version of Word, you can create professional, high quality documents, perfect for personal and business use. Word 2010 has all sorts of new and improved tools to enhance your documents, including:

• The ability to add formatting effects like gradient fills and reflections directly to your document text (the same effects you may have previously used for pictures, charts, and SmartArt graphics)

• New picture editing tools, including advanced color and cropping tools to perfect your document pictures

• Customizable Office themes to ensure the look of your document is consistent—you can even add your personal or business brand to your theme, giving your documents that much more of a professional edge

• A wide selection of SmartArt graphics, including additional layouts for charts and picture diagrams, to add an extra visual effect to your message

Word’s improved layout makes it even easier to navigate the program. You can recover draft versions of files that you closed without saving—that’s right, no more panic over losing a document!—and you can work with others on documents and projects with new co-authoring capabilities.

Get familiar with these new features and more at KnowledgeCity.com—we have training tutorials for beginning and advanced users, so you can learn all about how to use Word 2010. Coming soon are more of the new Office Suite, including PowerPoint 2010 and Access 2010.

Read More