sunday business systems using access more efficiently tips and tricks to improve productivity
TRANSCRIPT
![Page 1: Sunday Business Systems Using Access More Efficiently Tips and tricks to improve productivity](https://reader035.vdocuments.us/reader035/viewer/2022062715/56649d9d5503460f94a86513/html5/thumbnails/1.jpg)
Sunday Business Systems
Using Access More Efficiently
Tips and tricks to improve productivity
![Page 2: Sunday Business Systems Using Access More Efficiently Tips and tricks to improve productivity](https://reader035.vdocuments.us/reader035/viewer/2022062715/56649d9d5503460f94a86513/html5/thumbnails/2.jpg)
Sunday Business Systemswww.SundayBizSys.com
The Basics
Microsoft Access is a database with Tables
Where data is stored Queries
Questions asked of the database Forms
Displays data (or records) Controls the entry & editing of data Records are made up of fields
Reports Displayed and formatted information
![Page 3: Sunday Business Systems Using Access More Efficiently Tips and tricks to improve productivity](https://reader035.vdocuments.us/reader035/viewer/2022062715/56649d9d5503460f94a86513/html5/thumbnails/3.jpg)
Sunday Business Systemswww.SundayBizSys.com
Editing Records in Forms
►Is called a
Record Selector
Record Selector changes when a record is being
edited
At this point the edit may be cancelled by
pressing Esc on the keyboard
Select the ► and press Delete to
delete the individual record
![Page 4: Sunday Business Systems Using Access More Efficiently Tips and tricks to improve productivity](https://reader035.vdocuments.us/reader035/viewer/2022062715/56649d9d5503460f94a86513/html5/thumbnails/4.jpg)
Sunday Business Systemswww.SundayBizSys.com
Finding records in forms
1. Select the field on the form that you want to search
2. Select Find1. Select Edit-Find2. Hold down Ctrl-F3. Select the binocular tool
![Page 5: Sunday Business Systems Using Access More Efficiently Tips and tricks to improve productivity](https://reader035.vdocuments.us/reader035/viewer/2022062715/56649d9d5503460f94a86513/html5/thumbnails/5.jpg)
Sunday Business Systemswww.SundayBizSys.com
The Find and Replace Window
Find What:Enter the text to find. Can be any part of the
desired field
Look In:Determines which field
on the form will be searched
Match:Any part of fieldWhole Field orStart of field
![Page 6: Sunday Business Systems Using Access More Efficiently Tips and tricks to improve productivity](https://reader035.vdocuments.us/reader035/viewer/2022062715/56649d9d5503460f94a86513/html5/thumbnails/6.jpg)
Sunday Business Systemswww.SundayBizSys.com
Find more records
Select to find the next record matching your
search criteria
Once a record or field is found, you can filter the form to display only the records that match your search criteria
![Page 7: Sunday Business Systems Using Access More Efficiently Tips and tricks to improve productivity](https://reader035.vdocuments.us/reader035/viewer/2022062715/56649d9d5503460f94a86513/html5/thumbnails/7.jpg)
Sunday Business Systemswww.SundayBizSys.com
Sorting Forms
1. Select the field on the form that you want sorted
2. Select A-Z or Z-A
![Page 8: Sunday Business Systems Using Access More Efficiently Tips and tricks to improve productivity](https://reader035.vdocuments.us/reader035/viewer/2022062715/56649d9d5503460f94a86513/html5/thumbnails/8.jpg)
Sunday Business Systemswww.SundayBizSys.com
Using Form Filters
Find one instance of the value you want in the filter's results. Select all or part of a value in a field by doing one of the following:
Note: How you select the value determines what records the filter returns. Find records in which the entire contents of that field match the selection
Select the entire contents of a field or place the insertion point in a field without selecting anything.
Find records in which the value in that field starts with the same characters you selected.
Select part of a value starting with the first character in a field.
Find records in which all or any part of the value in that field contains the same characters you selected.
Select part of a value starting after the first character in a field.
Click Filter By Selection on the toolbar. To reset the filter, click Remove Filter on the toolbar.
![Page 9: Sunday Business Systems Using Access More Efficiently Tips and tricks to improve productivity](https://reader035.vdocuments.us/reader035/viewer/2022062715/56649d9d5503460f94a86513/html5/thumbnails/9.jpg)
Sunday Business Systemswww.SundayBizSys.com
Example
Select “Sipex”
Select Filter by Selection to show all records containing
“SIPEX” in the Program name
The results show as “(Filtered)”
![Page 10: Sunday Business Systems Using Access More Efficiently Tips and tricks to improve productivity](https://reader035.vdocuments.us/reader035/viewer/2022062715/56649d9d5503460f94a86513/html5/thumbnails/10.jpg)
Sunday Business Systemswww.SundayBizSys.com
To remove the filterClick on the funnel
shape in the tool bar
The results are now unfiltered
![Page 11: Sunday Business Systems Using Access More Efficiently Tips and tricks to improve productivity](https://reader035.vdocuments.us/reader035/viewer/2022062715/56649d9d5503460f94a86513/html5/thumbnails/11.jpg)
Sunday Business Systemswww.SundayBizSys.com
Time saving tricks
Press ESC while editing a record Undoes the changes you have made to the current field
Press ESC twice Undoes the changes you have made to the current field and current
record Keyboard combinations:
Press the keyboard Ctrl key and other special keys at the same time: Press and hold Ctrl and ; keys
Enters the current date in a field Press and hold Crtl and Shift and : keys
Enters the current time in a field Press and hold Ctrl and ‘ keys
Enters the previous value in the field Good for when information does not change from record-to-record
![Page 12: Sunday Business Systems Using Access More Efficiently Tips and tricks to improve productivity](https://reader035.vdocuments.us/reader035/viewer/2022062715/56649d9d5503460f94a86513/html5/thumbnails/12.jpg)
Sunday Business Systems
Fueling Small Business EfficiencyFueling Small Business Efficiency
Visit www.SundayBizSys.com for:•Additional information•Free product demos•Pricing•Links to purchase software
© 2006 Sunday Business Systems. All rights reserved. This presentation is for informational purposes only. Sunday Business Systems MAKES NO WARRANTIES, EXPRESS OR IMPLIED, IN THIS SUMMARY.
Microsoft is a registered trademark of Microsoft Corporation in the United States and/or other countries.