Download
microsoft access n.
Skip this Video
Loading SlideShow in 5 Seconds..
Microsoft Access PowerPoint Presentation
Download Presentation
Microsoft Access

Microsoft Access

122 Views Download Presentation
Download Presentation

Microsoft Access

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Microsoft Access Project 3

  2. Objectives • Add records to a table • Locate records • Filter records • Change the contents of records in a table • Delete records from a table • Restructure a table • Change the field characteristics

  3. Objectives cont… • Add a field • Save changes to the structure • Update the contents of a single field • Make changes to groups of records • Delete groups of records • Create validation rules

  4. Objectives cont… • Update a table with validation rules • Specify referential integrity • Use subdatasheets • Order records • Create sing-field and multiple-field indexes

  5. Introduction • Updating • Mass updates • Mass deletions • Restructure • Indexes

  6. Project Three – Maintaining the Alisa Vending Services Database • Make changes as requested by the company • Includes • Restructuring • Adding fields • Validation rules • Indexes

  7. Opening the Database • Open Access • Click Open on the Database Toolbar • Select Database • Click the Open button

  8. Adding, Changing and Deleting • Adding Records

  9. Adding, Changing and Deleting • Searching for a Record • Use Find, and enter Search Criteria

  10. Adding, Changing and Deleting • Changing the Contents of a Record

  11. Adding, Changing and Deleting • Switching Between Views • Toolbar method • Menu method

  12. Adding, Changing and Deleting • Filtering Records • Filter by Selection

  13. Adding, Changing and Deleting • Deleting Records • Select Records • Edit Delete Records

  14. Changing the Structure • Changing the Size of a Field • Switch to Design View • Select Field to Resize • Enter Size

  15. Changing the Structure • Adding a New Field • Select Insertion Point • Press Insert Key

  16. Changing the Structure • Deleting a Field • Click row to delete • Press DELETE button

  17. Changing the Structure • Updating the Restructured Database • Switch to datasheet view • Enter data into the new field

  18. Changing the Structure • Resizing Columns • Field Selector

  19. Using an Update Query • Create the Query • Enter Update Value • Run the Query