Microsoft Access

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 • Update the contents of a single field • Make changes to groups of records • Delete groups of records • Create validation rules

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

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

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

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

Adding, Changing and Deleting • Adding Records

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

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

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

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

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

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

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

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

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

Changing the Structure • Resizing Columns • Field Selector

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

Microsoft Access