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

Loading in 2 Seconds...

play fullscreen
1 / 104

Microsoft Access - PowerPoint PPT Presentation


  • 98 Views
  • Updated on

Microsoft Access. Project 3. 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. Objectives cont…. Add a field Save changes to the structure

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - 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