Queries--Reports--Forms

a) These are choices on the Admin Ribbon Bar

b) Query Wizard – If you're new to Access, the Query Wizard is a good way to start building queries. The wizard also enables you to group and summarize data. That isn't necessary for simple queries, but it can help you analyze more complex record sets, and it can also make reports much easier to read and understand. There are plenty of manuals and online tutorials that can show you how to use this wizard

1) Complete the wizard. Select the tables and fields you want to use as your record source. You can also use other queries in your record source

2) Give your new query a descriptive name and remember that it’s a good practice to avoid using spaces in the name

3) After you create your query, the wizard will run it for you. It's always a good idea to run your queries and ensure they provide the data you need. If they don't, you can start over and select new fields and other options, or you can change your queries in Design view

c) Report Wizard – Makes it easy to create reports using fields from multiple tables or queries. It even lets you choose how your data will be organized. There are plenty of manuals and online tutorials that can show you how to use this wizard

d) Form Wizard – Allows you to create forms and be selective about what fields appear. It lets you define how the data is grouped and sorted and you can use fields from more than one table or query (provided that you specified the relationships between the tables and queries beforehand).

e) Run Query Directly – Allows you to select a Query from a pull down and run it directly