1 / 57

Database Systems Introduction to Microsoft Access Part 1

Database Systems Introduction to Microsoft Access Part 1. Introduction. In its simplest form, Access is a database application It uses a relational database management model, which means you can relate each piece of information to other pieces of information by joining them. Create Tables.

fancy
Download Presentation

Database Systems Introduction to Microsoft Access Part 1

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 1

  2. Introduction • In its simplest form, Access is a database application • It uses a relational database management model, which means you can relate each piece of information to other pieces of information by joining them.

  3. Create Tables • By using wizard • By entering data • By design view • specify field name, data type • set general attributes • set primary key

  4. Establish Relationships • Click the relationships button on the toolbar • Tables are related by matching fields.

  5. Types of Queries • Select query • Update query • Append query • Delete query

  6. Create Queries • By using wizard • select table, fields • Not convenient to design complex query • By design view • By SQL view • Input SQL sentence directly

  7. Microsoft Access

  8. Defining a New Data Base

  9. Naming the Data Base File Name OK Change Name/Directory

  10. The New Data Base

  11. Tables General Relational Data base Table Fields Id Name Age Address Row or Record 214 Jones 25 1 New St, Malvern 215 320 Key Field (Indexed)

  12. Access Table

  13. Define Fields in Table

  14. Add The Name Field

  15. Select Field Type

  16. Set the Field’s Parameters

  17. Name as Primary Key

  18. Define the Image Field Select OLE Object

  19. Image Parameters

  20. Click to Save the Table Click Yes

  21. Name the Table

  22. Table1 is now in the Database

  23. Select Forms Select New Form

  24. Associate Form with Table Relate Form To Table

  25. Create Form for Table1 Select Form Wizard

  26. Select AutoForm

  27. New Form -Run Mode

  28. Close the Form

  29. Save the Form Select Yes

  30. Name the Form

  31. Form is part of the Database Form in Database

  32. Modify the Form

  33. Delete the Current Title Click The Title and Press Delete

  34. Select A in ToolBox for Title

  35. Properties

  36. Save the Change

  37. Run The Form Click Open or Double Click The Form

  38. Add an Image Record

  39. Type in the Name

  40. Select ClipArt File

  41. Copy Butterfly to Clipboard

  42. Paste Butterfly to Image

  43. The Butterfly goes to Image

  44. Enter Next Record

  45. Insert Object Right Mouse Click

  46. Select Object Type

  47. Select Graph

  48. Graph

  49. Clip Art

  50. Cartoon

More Related