Create a Que r y That Uses T w o or More T a bles If you want to view data from two or more tables or queries, you can create a query that ... [Read More]

Sort Multiple Columns i n a Query As you learned in the previous section, you can sort the rows your query returns. You can also create so... [Read More]

Sort a Query When creating a query, you can sort the rows you retrieve in ascending or descending order by choosing the option you want on t... [Read More]

Retrieve Mult i ple Colu m ns You can use an Access query to retrieve multiple columns of data. On the Field line in Query Design view, choo... [Read More]

Retrieve a Si n gle Column You can use an Access query to retrieve a single column of data. Instead of choosing the tablename.* option on t... [Read More]

Change from Da t asheet View to Query De s ign View After you run a query, you can easily change back to Query Design view and make modific... [Read More]

Creating Micr o soft Access Queries A query can be based on tables or on other queries. To create a query, you open the ta b les or queries ... [Read More]

Hide Columns There may be times when you may not want to display a certain column or set of columns. In such cases, you can temporarily hid... [Read More]

Filter a Table You can apply a filter to see only the records you want to see. For example, perhaps your database contains students from the... [Read More]

Sorting, Fi l tering, and Creating R elationships You can sort Access data so you can view records in the order you want to view them,... [Read More]

Modify a Ta b le After you create a table, you may need to modify it. You can delete columns, insert columns, or move columns. Delete Column... [Read More]

Working with Microsoft Ac c ess Tables After you create an Access table, you can modify it, enter data into it manually or import data f... [Read More]