A database application used to store in order for web or desktop applications. Tables are the substance in Microsoft contact used to query the in order and display it to the user. If you have already put jointly an Access query and need to edit your tables, you can change the queried table in the application's Design Viewer. The Design watcher permit you to add and remove objects using drag-and-drop features in Windows.

Instructions

Step 1

Open Microsoft Access and open the folder that contain the query you desire to edit. Click "Queries" in the major Access window. This display a list of all your currently automatic queries.

Step 2

Right-click the query you want to edit and pick "Design View." This open your question with a view of the topical table and field used to come reverse data to the user.

Step 3

Click the "Query" menu item and select "Tables." This opens a list of tables bent in the Access file. the table you want to use in the question. This routinely adds it to the Design View window where you can edit the query statement.

Step 4

Click "Close" in the table window. Drag and drop the field from the new bench to the meadow list at the base of your Design View window.

Step 5

Right-click the old table and choose "Remove." This removes the old board from your query down with the fields in the return fallout. Click "Save" at the top of the Access window to save your new table settings.