1 / 48

Database Systems Introduction to Microsoft Access Part 3

Database Systems Introduction to Microsoft Access Part 3. Create Form by Using Wizard. Create Form by Using Wizard. Create Form by Using Wizard. Create Form in Design View. Create Form in Design View. Sample Form. Adding Records Using A Form. Form Controls. Reports. Reports.

vaughn
Download Presentation

Database Systems Introduction to Microsoft Access Part 3

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. Database SystemsIntroduction toMicrosoft AccessPart 3

  2. Create Form by Using Wizard

  3. Create Form by Using Wizard

  4. Create Form by Using Wizard

  5. Create Form in Design View

  6. Create Form in Design View

  7. Sample Form

  8. Adding Records Using A Form

  9. Form Controls

  10. Reports

  11. Reports

  12. An Access Report with All Sections Shown

  13. Exporting Access Query to Excel Workbook File

  14. Reposition and Resize Controls in Subreport

  15. Query Data Exported to an Excel Worksheet

  16. Import Data from Other Applications as an Access Table • You can import data from a variety of other applications, including Excel lists, as an Access table. • If you import data from an Excel list, be sure that the range of the list is named before attempting to import the data in the list.

  17. Import Spreadsheet Wizard Dialog Box

  18. First Row Contains Column Headings

  19. “Choose primary key” Option

  20. Imported Trial Balance Table in Datasheet View

  21. Macros in Microsoft Access • Use to Open or Close Forms and Reports • Print Reports, or send to other Applications • Build Menus • Execute a command from a Menu • Display Messages or Sound Beeps • Start Other Applications

  22. A Simple Button Menu Form Open Form A Open Form B Exit

  23. Button for Form A

  24. Name the Button and Finish

  25. The Button to Open Form A

  26. Button Wizard gives VB Event Procedure

  27. Event Procedure for the OpenA Button

  28. Cancel Wizard to Define a OpenB Wizard Off OpenB Open Form B Adjust Size

  29. Define a Macro for OpenB OnClick Event Click Dots Select Macro Click

  30. Name the Macro Click Open Form B

  31. Select OpenForm Click

  32. Macro: Open Form B FormB Click

  33. System Check Click

  34. Add the Exit Button Wizard On Click Click

  35. The Exit Button

  36. Exit.OnClick Event Procedure

  37. Run the Simple Menu Click

  38. Event Procedure - Form A

  39. Event Macro - Form B

  40. Form with Local Event Procedures

  41. Local Event Procedures or Functions Click

  42. Local VBA Code

  43. Module Area

  44. Global Values and Procedures

  45. How Big with Access There are file size limitations with MS Access. Tables 95 Queries 29 Forms 511 Reports 185 Code 500 (200,000 statements) Table Space 800Mb Code Space 60Mb

  46. Garbage Collection Regular Compacting is required to keep size down. (Tools/Utilities/Compact)

  47. MS Access - Offers Tables Database Table Definition/Entry Queries SQL Queries against Tables Forms Forms to be displayed Reports Reports to be Printed Macros Macro Commands Modules Visual Basic Code

  48. End of Lecture • MS Access is include with some versions of MS Office. It can be learned by experimentation. • MS Access is not a full featured database like Oracle but it comes very close and is a good alternative for the PC desktop environment.

More Related