Microsoft Access Programmer Mobile, Alabama

Call MS Access Solutions at (323) 285-0939 for your FREE consultation.

The material below originally appeared in Alison Balter's book Mastering Microsoft Office Access 2007 Development and is reprinted here with the author's permission. There may be references to "Figures" or "Chapters" that are not reprintable and are not used on this page.

Everything You Need to Know About Query Basics

Creating a basic query is easy because Microsoft has provided a user-friendly, drag-and drop interface. There are two ways to start a new query in Access 2007. The first way is to select the Create tab and then click to select the Query Wizard button in the Other group. The New Query dialog box appears. The Simple Query Wizard walks you through the steps for creating a basic query. The other wizards help you create three specific types of queries: Cross-tab, Find Duplicates, or Find Unmatched. The second method is to click to select the Create tab and then click to select the Query Design button in the Other group. The Show Table dialog box appears. This dialog box lets you select which tables and queries you want to include in the query.

Adding Tables to Your Query

As mentioned previously, if you select Query Design rather than one of the wizards, the Show Table dialog box appears. In this dialog box, you can select the tables or queries that supply data to your query. Access doesn't care whether you select tables or queries as the foundation for your queries. You can select them by double clicking on the name of the table or query you want to add or by clicking on the table or query and then clicking Add. You can select multiple tables or queries by using the Shift key to select a contiguous range of tables or queries, or the Ctrl key to select noncontinuous tables or queries. When you have selected the tables or queries you want, click Add and then click Close. This brings you to the Query Design window shown in Figure 4.3.

Adding Fields to Your Query

You're now ready to select the fields you want to include in the query. The query shown in Figure 4.3 is based on the tblClients table and the tblProjects table included in the CHAP4.ACCDB database on the sample code CD-ROM. Notice that the query window is divided into two sections. The top half of the window shows the tables or queries that underlie the query you're designing; the bottom half shows any fields that will be included in the query output. You can add a field to the query design grid on the bottom half of the query window in several ways:

• Double-click the name of the field you want to add.
• Click and drag a single field from the table in the top half of the query window to the query design grid below.
• Select multiple fields at the same time by using your Shift key (for a contiguous range of fields) or your Ctrl key (for a noncontiguous range). You can double-click the title bar of the field list to select all fields and then click and drag any one of the selected fields to the query design grid.

Create a database based on the Northwind 2007 template database that comes with Access (see Figure 4.4). If you want to prevent the Startup form from appearing, hold down your Shift key as you click the Create button and until the database opens. Click to select the Create tab. Select Query Design from the Other group. The Show Table dialog box appears. Add the Customers table to the query and close the Show Table dialog.

---

Author Attribution

The preceding information originally appeared in Alison Balter's book Mastering Microsoft Office Access 2007 Developmentand is reprinted here with the author's permission.

---

Expert Microsoft Access Programmer Mobile, AL

When you need a Microsoft Access programmer for your Mobile, Alabama, business, agency, or organization, call MS Access Solutions at (323) 285-0939. We have over 25 years experience as a programmer company creating Microsoft Access database applcations. We create Access databases for all business niches, including, but not limited to, consisting of medical clinics, hospitals, government agencies at the federal, state, and local levels, the U.S. military, school districts, junior colleges and universities, agriculture, human resources departments, and insurance agencies and insurance corporations.

Here at MS Access Solutions, we roll up our sleeves and tackle everything from enterprise-level database projects to those pesky little fixes that drive you crazy. Our team has spent years in the trenches with Access and SQL Server, learning the quirks and hidden features that make these systems tick. We've seen firsthand how critical these database applications are to keeping your business running day after day.

What We Do

We handle database work for businesses large and small, with particular expertise in:

• Custom Programming: Tailored Microsoft Access and SQL Server applications built specifically for your unique business needs
• System Connections: Getting your Access database talking smoothly with other business systems you rely on
• Speed Improvements: Finding and fixing those frustrating bottlenecks slowing down your existing applications
Microsoft Access Programmer Mobile, Alabama - MS Access Solutions
• Security Setup: Locking down your valuable data with practical, effective safeguards
• Data Transfers: Moving your information between platforms without losing anything important

Fixing Broken Microsoft Access Databases

When things go wrong with Access, we know exactly where to look:

• Bringing damaged Access forms back to life so you can actually use them again
• Getting MS Access reports to show the right numbers instead of garbage
• Speeding up those queries that take forever to run
• Fixing broken macros so your automated workflows actually work
• Untangling messy VBA code that's causing mysterious errors
• Rescuing corrupted data before you lose important information

Why Business Owners Choose To Work With Us

We don't just see code and tables when we look at your database; we see the actual business problems you're trying to solve. Our work blends technical know-how with real-world business sense, making sure your database applications don't just technically function but actually help your team get their jobs done better.

Clients tell us they appreciate how we explain things in plain English and stick to deadlines. We always provide clear documentation with our projects, so your team isn't left scratching their heads trying to figure out how to use what we've built.

Whether you need a complete enterprise database system built from scratch or quick repairs to fix what's broken, we've got the hands-on experience to deliver results that actually make your workday better. Give us a call at (323) 285-0939 to chat about how we can help make your Microsoft Access and SQL Server database systems run more smoothly and reliably.

---

Find Out More About Our Programming Services

Get more information about MS Access Solutions programming services on the Microsoft Access programmer Montgomery, Alabama web page.