1 / 32

FORMS, CONTROLS and REPORTS In Microsoft ACCESS

FORMS, CONTROLS and REPORTS In Microsoft ACCESS. Dan Ricky Ong Lecturer. WHAT ARE FORMS? Forms created in Access is similar to an ordinary paper form which you fill out with a pen or pencil.

jrainey
Télécharger la présentation

FORMS, CONTROLS and REPORTS In Microsoft ACCESS

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. FORMS, CONTROLS and REPORTS In Microsoft ACCESS Dan Ricky Ong Lecturer

  2. WHAT ARE FORMS? • Forms created in Access is similar to an ordinary paper form which you fill out with a pen or pencil. • Forms provide an easy way to enter and view data in a table. As you encode data, the corresponding table is automatically updated.

  3. Easier to View and Use: • Instead of scrolling back and forth in a table's data sheet, a Form lets you focus on one record at a time. • See Data Any Way You Want: • You can design Forms to present information any way you like.

  4. WORKING WITH FORMS • WHAT WE WILL LEARN • Creating a Form with AutoForm • a.1. Automatic • a.2. Selective • b. Creating a Form using a Form Wizard

  5. a.1. Creating a Form with AutoForm

  6. a.1. Creating a Form with AutoForm

  7. b. Creating a Form with Form Wizard

  8. b. Creating a Form with Form Wizard 1 2 3 4

  9. b. Creating a Form with Form Wizard 5

  10. MODIFYING FORMS After you create a Form, you may decide to modify it to add additional features or make it easier to use. For example, you might want to add or delete a field or change the location of a field on the form. You can modify a Form in Design view, which you can get to in two ways.

  11. CONTROL BUTTONS • are objects on forms that enable you to access data or manage the form. Examples of Control Buttons Text Boxes Combo Boxes Check Boxes Command (push) Buttons

  12. Modifying Forms

  13. Modifying Forms

  14. Modifying Forms

  15. Control Toolbox

  16. WHAT WE WILL LEARN a. Choosing One/Multiple Controls b. Moving and Sizing c. Adding and Deleting Controls d. Changing Appearances

  17. To select and move a single Control 1

  18. To select and move a group of Controls • Click and drag from top left corner to bottom • right corner of the group 2. Release the mouse 3. Move to desired location

  19. Adding Fields • Add a field to a form by clicking and dragging it from the Field List

  20. Adding buttons to the Form 1 2

  21. To view the changes to the Form

  22. To redesign the Form From a form window

  23. To add your company logo to the Form 1 2

  24. To add your company logo to the Form

  25. To add your company logo to the Form

  26. PRACTICE MAKES PERFECT!!! Create a NEW, DELETE, SAVE, and FIND BUTTON. Include a company logo if necessary

  27. WHAT ARE REPORTS? Reports present information from tables in a format ideal when printed. Reports can also help summarize and analyze the information in your database.

  28. WHAT WE WILL LEARN Creating Reports Altering the Wizards Output Designing your reports

  29. CREATING REPORTS

  30. Practice Makes Perfect! Dan Ricky Ong Lecturer

More Related