Microsoft Access Reports

Try our Search Box:

Microsoft Access Reports: microsoft access database.

Check out the table of contents for this extensive tutorial that teaches users how to build a simple database application and reports using MS Access.

Microsoft Access Reports: Forms

Access Forms have two purposes in life. The first is to present the table or query's data in a format that is easy to view or update. The second is to create the interface portion of any Access application--for example, you can create a switchboard t use as the control center of a database. Many engineers would rather see the raw database, but most people would rather not--so forms are helpful when you have "ordinary" users inputting data.

Microsoft Access Reports: Reports

You can use Access' Report function to get the standard row and column format--but you need not be confined to that format.. You can also use Report to make charts, graphs, catalogs of products and services, or even  mailing labels.

Microsoft Access Reports: Macros

1. Think of a macro as a pre-recorded set of actions. For example, if you had a macro for starting your car, you'd record every step of the process--opening the door, getting in, putting the key in the ignition, etc. In Access, you might write a macro for automatically sorting data entries by last name.

2. Access has 49 different actions you can use in a macro.

Microsoft Access Reports: Modules

1. Think of modules as containers in which you store programming code. You can even think of  them as having a plastic lid you must burp, if that helps!

2. Modules will be global (available everywhere in your application), form (available only in the particular form that uses it), or report (available only to the particular report that uses it). If a module is form or report, then you store it inside a form or inside a report. Global modules don't travel with exported data, but form and report modules travel with their forms and reports if you export those forms and reports.

There's a view that should be part of the tabs, in my opinion. Instead, Microsoft buried it under the tools menu. That view is none other than:

Microsoft Access Reports: Relationships

This view tells you how all the tables link together, and modify that as you need to.

1.It's common to have a tblMain table that lists, for example, all of your customers. That table will have field names such as customer number (primary key), company name, taxpayer ID, and other information not likely to change.

2. Then you'd have a table called tblContact, and it would have field names such as customer number, title, last name, first name, phone, fax, e-mail, personal data, preferences, hours, comments, etc.

3. Then you'd have a table called tblOrders, with all the appropriate field names.

4. You'd have any other tables pertinent to dealing with your customers.

5. The relationships view would show lines connecting the customer number field headings of each table.

6. You can set up "data integrity" so that you don't lose, confuse, or duplicate entities (make sure to read the Help menu about data integrity--it is a major reason for using a relational database in the first place).