Queries are instructions to the database that ask for information. The information that an Access query brings back is in a spreadsheet-like, tabular format.

Don't have access to Access? You can use Excel to open the database you want, using the MS Query Wizard. Here's how to multitask using Office's versatile spreadsheet program.

How to Build a Data Dictionary in Access. A data dictionary is like a bill of materials for a database; it lists all database components, including reports, tables, field names and field types ...

Use saved queries as opposed to SQL statements as the data sources for Access objects. The wizard will create a corresponding SQL Server object for each saved query.

Learn how to export an Access database to Excel. When you export data from Access to Excel, Access stores the copied data in a file that can be open in Excel.

A professional database designer can build interactive query screens, assemble complex reports, and incorporate features that will protect the integrity of your valuable data.