Forms & Reports:
Summary
Did you want: Working with Databases: Access 2007, 2010, 2013, 2016
|
Forms & Reports:
|
Did you want: Working with Databases: Access 2007, 2010, 2013, 2016 | ||||
|
|
||||||
|
Forms and reports are the usual way that you interact with a database. Forms allow you to enter new records and edit existing records. Reports allow you to sort and group results to show just exactly what you want to see. Reports can show totals (Sum, Avg, Min, Max, Count, etc) for the whole report or for groups. Forms and reports are similar in the way that you create and manage them, though each has its own special features. You can import data in a number of different formats or objects from another database. You can export datasheets in several formats for use in other programs. You can also export Access objects to another Access database. Sometimes it is better to leave the data in its original form and location and link to it instead of importing into the database. A well-designed form is easy to read and easy to use. For a data entry form, the controls should be in an order that matches the source that the user is using to enter new data. Backgrounds should not interfere with reading the data. Calculated values should be clearly different from entered values. A well-designed report prints neatly and is easy to read. Groupings and totals are clearly labeled. The report fits on the page and the controls show all of the data from the control's source. Nothing is cut off. The Properties dialog controls the look and behavior of the whole form/report, each section, and each control. There are a large number of properties for most objects. The Page Setup dialog controls the pages of a print-out, including margins, orientation, and the number and size of columns. Images that are not part of records can be inserted with an Image control or as an unbound object frame. Bound object frames are needed for images that are part of a record. Adding images or other OLE objects to records can greatly increase the size of the database. Compacting a database will usually reduce its file size. It is important to compact regularly and to keep backup copies of your database. You can create totals using aggregate functions for a whole report or for groups in a report. Doing totals of calculated controls can usually be done but requires extra effort. You can combine two or more forms/reports into a single object by using subforms/subreports. The subform/subreport must be synchronized to the main form/report if you want to show only the data that matches the current record. Access includes a number of wizards to help you create and manage objects. The Label Wizard and Chart Wizard create specialty reports. The Form and Report Wizards create a basic form/report based on one or more tables and queries. The Subform and Subreport Wizards automatically create the link(s) to the main form/report to synchronize with records. |
|
Project 4: Forms & Reports
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
What You Printed for Project 4: Forms & Reports
Skills Covered
Important Terms |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
~~ 1 Cor. 10:31 ...whatever you do, do it all for the glory of God. ~~ |
