Access

Resolved · Low Priority · Version Standard

Tue 12 Feb 2008, 16:46 Delegate Maria said...

Maria has attended:
Access Intermediate course

Access

how do you know when you should use a query, form, report or table?

Tue 12 Feb 2008, 16:51 Trainer David said...

RE: Access

Hi Maria

Each item has a different purpose. A table is the underlying storage table and is essential. A query is used to extract data from one or many tables, this data can then be viewed in much nicer layout using a report. Forms are mostly used for data entry, much easier than entering data into a table especially when multiple linked tables are involved.

Hope this helps
David

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Create own ribbon tab - Access 2010

a. In Access click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the New Tab button (below the list of tabs on the right hand side of the dialog box)
e. Select the New Tab (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
f. Select the New Group (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
g. Add commands to your tab and group by locating them on the list on the right hand side (remembering that you can change the list using the drop down box at the top of the list of commands) and clicking the Add button between the two panes to add them to your tab and group
h. You can rearrange the commands in your group, the groups on any tab or the tabs, using the up and down arrow buttons beside the list of tabs.
i. Click OK to apply your changes

View all Access hints and tips