Queries

Queries

What is a Query?

The real power and advantage of having a database is not only to store information, but also the capability to retrieve and report on the stored data. A query is simply a question you ask the database to help locate specific information. It is the ability to request information from the database by combining data from multiple tables and retrieving data based on specified conditions.

If you simply want to recall the information stored in a single table, Microsoft Access allows you to open the table and scroll through the records contained within it.

Developing Queries

Microsoft Access has created a GUI (Graphical User Interface) called a ‘Query Designer’ that easily allows users to create queries without prior knowledge of SQL.

The Query Designer allows the users to select the Data Sources of the query (which can be tables or queries) and select the fields they want returned by clicking and dragging them into the grid. Joining tables can be created by clicking and dragging fields in specific tables to fields in other tables. Access allows users to view and manipulate the SQL code if desired. Any Access table, including linked tables from different data sources, can be used in a query.

How To Design a Query >

  • Judicial Attorney Services Inc.

    You continue to do a job well done with the design, updating and maintenance of our company's program. Work is performed in a timely and professional manner.

    - President

  • A Trucking and Warehousing Company

    Their ability to understand our industry from the ground up - just like one of my coworkers would - is their key differentiator.

    - Customer Service Manager

  • A Services Company

    I needed to believe that Access Programmers could help my company. Their team understood my hesitation and took the time to really understand my business needs.

    - Regional Sales & Operations

  • A Non-Profit Advocacy Firm

    Access Programmers has completed several projects for us - all of which we've been extremely satisfied with. The staff is very knowledgeable, accessible, professional and easy to work with.

    - Information Technology Manager

Contact Us

Please wait...