Create a Query That Uses Two or More Tables

Create a Query That Uses Two or More Tables If you want to view data from two or more tables or queries, you can create a query that pulls the data from multiple tables or queries. The tables and queries from which you pull your data   Should have a relationship. To create a query that uses two or more tables: 1.   Open the tables and/or queries you want to use in Query Design view. 2.   Choose the...

Read More

Sort Multiple Columns in a Query

Sort Multiple Columns in a Query As you learned in the previous section, you can sort the rows your query returns. You can also create sorts within a sort. For example, you can sort by state and then within a state, you can sort by last name and then by first name. You specify the sort in the order you want the sort to occur. If you want to sort by state and then by last name within a state and then by first name within last name,...

Read More

Sort a Query

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 the Sort row in Query Design view. To perform a sort: 1.   Open a table or query in Query Design view. 2.   Choose the field names you want to retrieve in the order you want to retrieve them. 3.   Under the field you want to sort, click the down-arrow and then...

Read More

Retrieve Multiple Columns

Retrieve Multiple Columns You can use an Access query to retrieve multiple columns of data. On the Field line in Query Design view, choose the field name of each field you want to retrieve in the order you want to retrieve them. To retrieve multiple columns:  1.   Open a table or query in Query Design view. 2.   Choose the field names you want to retrieve in the order you want to retrieve them. 3. ...

Read More

Retrieve a Single Column

Retrieve a Single Column You can use an Access query to retrieve a single column of data. Instead of choosing the tablename.* option on the Field line in Query Design view, choose the name of the field you want to retrieve. To retrieve a single column: 1.   Open a table or query in Query Design view. 2.   Choose the field name you want to display in the field line. 3.   Click the Run button. Access...

Read More

Change from Datasheet View to Query Design View

Change from Datasheet View to Query Design View After you run a query, you can easily change back to Query Design view and make modifications to your query or create a new query. To change to Query Design view: 1.   Activate the Home tab. 2.   Click the down-arrow below View in the Views group. A menu appears. 3.   Click Design View. Access changes to Query Design view. You can modify your ...

Read More

Creating Microsoft Access Queries

Creating Microsoft Access Queries A query can be based on tables or on other queries. To create a query, you open the tables or queries on which you are going to base your query in Query Design view, and then use the options in Design view to create your query. You then click the Run button to display the results. You can save queries for later use. To open tables or queries in Query Design view: 1.   Activate the Create...

Read More

Hide Columns

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 hide the column or columns from view. Later, if you want to display them column again, you can unhide them. To hide columns: To create relationships: 1.   Close all tables and forms. (Right-click on the tab of any Object. A menu appears. Click Close All.) 2. ...

Read More

Filter a Table

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 states of DE, NJ, and PA and you only want to see the students from DE. You can filter your data so only DE students display. Each time you apply a filter to a column, it replaces any previous filter you applied to that column. For example, if you apply a filter so you only see students in...

Read More

Sorting, Filtering, and Creating Relationships

Sorting, Filtering,and Creating Relationships You can sort Access data so you can view records in the order you want to view them, and you can filter data so you only see the records you want to see. This lesson teaches you how to sort and filter an Access table.Access data is stored in multiple tables. Relationships join tables together so you can work with the data from multiple tables. This lesson also teaches you how to create relationships.Sort...

Read More

Modify a Table

Modify a TableAfter you create a table, you may need to modify it. You can delete columns, insert columns, or move columns.Delete ColumnsThe Delete option permanently deletes columns and all the data contained in them. You cannot undo a column delete.To delete columns:1.   Click and drag to select the columns you want to delete.2.   Activate the Datasheet tab.3.   Click Delete in the Fields & Columns group....

Read More

Working with Microsoft Access Tables

Working with Microsoft Access TablesAfter you create an Access table, you can modify it, enter data into it manually or import data from somewhere else, such as Excel. This lesson teaches you how to modify a table and enter data.Enter RecordsAfter you have created a table, you can enter data into it.To enter data into an AutoNumber field: ·               Press...

Read More