microsoft access project 3 objectives add records to a tableadd records to a table locate...
Post on 21-Dec-2015
218 views
TRANSCRIPT
![Page 1: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/1.jpg)
Microsoft Access
Project 3Project 3
![Page 2: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/2.jpg)
Objectives
• Add records to a tableAdd records to a table• Locate recordsLocate records• Filter recordsFilter records• Change the contents of records in a tableChange the contents of records in a table• Delete records from a tableDelete records from a table• Restructure a tableRestructure a table• Change the field characteristicsChange the field characteristics
![Page 3: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/3.jpg)
Objectives cont…
• Add a fieldAdd a field• Save changes to the structureSave changes to the structure• Update the contents of a single fieldUpdate the contents of a single field• Make changes to groups of recordsMake changes to groups of records• Delete groups of recordsDelete groups of records• Create validation rulesCreate validation rules
![Page 4: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/4.jpg)
Objectives cont…
• Update a table with validation rulesUpdate a table with validation rules• Specify referential integritySpecify referential integrity• Use subdatasheetsUse subdatasheets• Order recordsOrder records• Create sing-field and multiple-field Create sing-field and multiple-field
indexesindexes
![Page 5: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/5.jpg)
Introduction
• UpdatingUpdating• Mass updatesMass updates• Mass deletionsMass deletions
• RestructureRestructure• Indexes Indexes
![Page 6: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/6.jpg)
Project Three – Maintaining the Alisa Vending Services Database
• Make changes as requested by the Make changes as requested by the companycompany
• IncludesIncludes• RestructuringRestructuring• Adding fieldsAdding fields• Validation rulesValidation rules• Indexes Indexes
![Page 7: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/7.jpg)
Opening the Database
• Open AccessOpen Access• Click Open on the Database Click Open on the Database
ToolbarToolbar• Select DatabaseSelect Database• Click the Open buttonClick the Open button
![Page 8: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/8.jpg)
Adding, Changing and Deleting
• Adding RecordsAdding Records
![Page 9: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/9.jpg)
![Page 10: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/10.jpg)
![Page 11: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/11.jpg)
![Page 12: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/12.jpg)
Adding, Changing and Deleting
• Searching for a RecordSearching for a Record• Use Find, and enter Search CriteriaUse Find, and enter Search Criteria
![Page 13: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/13.jpg)
![Page 14: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/14.jpg)
![Page 15: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/15.jpg)
Adding, Changing and Deleting
• Changing the Contents of a RecordChanging the Contents of a Record
![Page 16: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/16.jpg)
![Page 17: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/17.jpg)
Adding, Changing and Deleting
• Switching Between ViewsSwitching Between Views• Toolbar methodToolbar method• Menu methodMenu method
![Page 18: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/18.jpg)
![Page 19: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/19.jpg)
![Page 20: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/20.jpg)
![Page 21: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/21.jpg)
Adding, Changing and Deleting
• Filtering RecordsFiltering Records• Filter by SelectionFilter by Selection
![Page 22: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/22.jpg)
![Page 23: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/23.jpg)
![Page 24: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/24.jpg)
![Page 25: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/25.jpg)
Adding, Changing and Deleting
• Deleting RecordsDeleting Records• Select RecordsSelect Records• Edit Delete RecordsEdit Delete Records
![Page 26: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/26.jpg)
![Page 27: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/27.jpg)
![Page 28: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/28.jpg)
Changing the Structure
• Changing the Size of a FieldChanging the Size of a Field• Switch to Design ViewSwitch to Design View• Select Field to ResizeSelect Field to Resize• Enter SizeEnter Size
![Page 29: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/29.jpg)
![Page 30: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/30.jpg)
![Page 31: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/31.jpg)
![Page 32: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/32.jpg)
![Page 33: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/33.jpg)
Changing the Structure
• Adding a New FieldAdding a New Field• Select Insertion PointSelect Insertion Point• Press Insert KeyPress Insert Key
![Page 34: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/34.jpg)
![Page 35: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/35.jpg)
![Page 36: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/36.jpg)
![Page 37: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/37.jpg)
![Page 38: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/38.jpg)
Changing the Structure
• Deleting a FieldDeleting a Field• Click row to deleteClick row to delete• Press DELETE buttonPress DELETE button
![Page 39: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/39.jpg)
Changing the Structure
• Updating the Restructured DatabaseUpdating the Restructured Database• Switch to datasheet view Switch to datasheet view • Enter data into the new fieldEnter data into the new field
![Page 40: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/40.jpg)
![Page 41: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/41.jpg)
Changing the Structure
• Resizing ColumnsResizing Columns• Field SelectorField Selector
![Page 42: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/42.jpg)
![Page 43: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/43.jpg)
![Page 44: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/44.jpg)
![Page 45: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/45.jpg)
![Page 46: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/46.jpg)
![Page 47: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/47.jpg)
Using an Update Query
• Create the QueryCreate the Query• Enter Update ValueEnter Update Value• Run the QueryRun the Query
![Page 48: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/48.jpg)
![Page 49: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/49.jpg)
![Page 50: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/50.jpg)
![Page 51: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/51.jpg)
![Page 52: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/52.jpg)
![Page 53: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/53.jpg)
Using a Delete Query
• Create The QueryCreate The Query• Enter CriteriaEnter Criteria• Run the QueryRun the Query
![Page 54: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/54.jpg)
![Page 55: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/55.jpg)
![Page 56: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/56.jpg)
![Page 57: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/57.jpg)
Creating Validation Rules
• Specifying a Required FieldSpecifying a Required Field• Select FieldSelect Field• Change Required to YesChange Required to Yes
![Page 58: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/58.jpg)
![Page 59: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/59.jpg)
![Page 60: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/60.jpg)
Creating Validation Rules
• Specifying a RangeSpecifying a Range• Select FieldSelect Field• Go to Validation RuleGo to Validation Rule
• Enter RangeEnter Range
• Enter Validation Text Enter Validation Text
![Page 61: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/61.jpg)
![Page 62: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/62.jpg)
Creating Validation Rules
• Specifying a Default ValueSpecifying a Default Value• Select FieldSelect Field• Enter Default ValueEnter Default Value
![Page 63: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/63.jpg)
![Page 64: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/64.jpg)
Creating Validation Rules
• Specifying a Collection of Legal Specifying a Collection of Legal ValuesValues• Select FieldSelect Field• Use OR in Validation RuleUse OR in Validation Rule
![Page 65: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/65.jpg)
![Page 66: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/66.jpg)
Creating Validation Rules
• Using a FormatUsing a Format• Select FieldSelect Field• Enter FormatEnter Format
![Page 67: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/67.jpg)
![Page 68: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/68.jpg)
Creating Validation Rules
• Saving Rules, Values, and FormatsSaving Rules, Values, and Formats• Click Close Window buttonClick Close Window button• Save ChangesSave Changes
![Page 69: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/69.jpg)
![Page 70: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/70.jpg)
![Page 71: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/71.jpg)
Creating Validation Rules
• Updating a Table that Contains Updating a Table that Contains Validation RulesValidation Rules• Access makes sure that data entered Access makes sure that data entered
follows the rules or else it is not follows the rules or else it is not acceptedaccepted
![Page 72: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/72.jpg)
![Page 73: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/73.jpg)
![Page 74: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/74.jpg)
![Page 75: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/75.jpg)
![Page 76: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/76.jpg)
![Page 77: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/77.jpg)
Creating Validation Rules
• Making Individual Changes to a Making Individual Changes to a FieldField• In Datasheet View, Select Individual In Datasheet View, Select Individual
RecordRecord• Select FieldSelect Field• Make ChangesMake Changes
![Page 78: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/78.jpg)
![Page 79: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/79.jpg)
![Page 80: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/80.jpg)
Specifying Referential Integrity
• Referential IntegrityReferential Integrity• Close Open DatasheetsClose Open Datasheets• Click Relationships ButtonClick Relationships Button• Set RelationshipsSet Relationships• SaveSave
![Page 81: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/81.jpg)
![Page 82: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/82.jpg)
![Page 83: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/83.jpg)
![Page 84: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/84.jpg)
![Page 85: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/85.jpg)
![Page 86: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/86.jpg)
![Page 87: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/87.jpg)
![Page 88: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/88.jpg)
![Page 89: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/89.jpg)
Using Subdatasheets
• Subdatasheets Allow you to view Subdatasheets Allow you to view related records from a table which has related records from a table which has a relationship with the current tablea relationship with the current table
![Page 90: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/90.jpg)
![Page 91: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/91.jpg)
![Page 92: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/92.jpg)
Ordering Records
• Ordering Records on Multiple Ordering Records on Multiple FieldsFields• Click field selectorClick field selector• Select fieldsSelect fields• Click Sort button of choiceClick Sort button of choice
![Page 93: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/93.jpg)
![Page 94: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/94.jpg)
![Page 95: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/95.jpg)
![Page 96: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/96.jpg)
![Page 97: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/97.jpg)
Creating and Using Indexes
• How Does Access Use an Index?How Does Access Use an Index?• When Should You Create an Index?When Should You Create an Index?
![Page 98: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/98.jpg)
Creating and Using Indexes
• Creating Single-Field IndexesCreating Single-Field Indexes• In Design View, Select FieldIn Design View, Select Field• Change Indexed to yesChange Indexed to yes
![Page 99: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/99.jpg)
![Page 100: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/100.jpg)
Creating and Using Indexes
• Creating Multiple-Field IndexesCreating Multiple-Field Indexes• Click on Indexes buttonClick on Indexes button• In blank row below Index name, add In blank row below Index name, add
field names without new Index namefield names without new Index name
![Page 101: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/101.jpg)
![Page 102: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/102.jpg)
![Page 103: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/103.jpg)
![Page 104: Microsoft Access Project 3 Objectives Add records to a tableAdd records to a table Locate recordsLocate records Filter recordsFilter records Change the](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649d5d5503460f94a3caaa/html5/thumbnails/104.jpg)
Closing the Database
• Click the Close button for the Alisa Click the Close button for the Alisa Vending Services : Database Vending Services : Database windowwindow