| 0 | 0 B | ||
| 1. A Short Demo of the Finished Database.mp4 | 7.6 MB | ||
| 1. A Short Demo of the Finished Database.srt | 0 B | ||
| 1. Basic Queries.mp4 | 140.6 MB | ||
| 1. Basic Queries.srt | 14.3 KB | ||
| 1. Create a Prototype Button.mp4 | 112.4 MB | ||
| 1. Create a Prototype Button.srt | 9 KB | ||
| 1. Create an Invoice Report from the Orders Subform.mp4 | 207.3 MB | ||
| 1. Create an Invoice Report from the Orders Subform.srt | 17.6 KB | ||
| 1. Creating Our First Table and Field Data Types.mp4 | 192.5 MB | ||
| 1. Creating Our First Table and Field Data Types.srt | 18.2 KB | ||
| 1. Creating a Form with the Wizard.mp4 | 174 MB | ||
| 1. Creating a Form with the Wizard.srt | 15.5 KB | ||
| 1. Finish Orders Form and Using TAB Controls - Part 1.mp4 | 141.1 MB | ||
| 1. Finish Orders Form and Using TAB Controls - Part 1.srt | 12.4 KB | ||
| 1. Getting Excel Data Ready for Access.mp4 | 136.3 MB | ||
| 1. Getting Excel Data Ready for Access.srt | 12.4 KB | ||
| 1. Lookup Wizard and Multi Valued Combo Boxes.mp4 | 237.4 MB | ||
| 1. Lookup Wizard and Multi Valued Combo Boxes.srt | 21 KB | ||
| 1. Overview of Reports and Report Views.mp4 | 191.7 MB | ||
| 1. Overview of Reports and Report Views.srt | 17.6 KB | ||
| 1. Reports based on the Parameter Query Trick.mp4 | 156.1 MB | ||
| 1. Reports based on the Parameter Query Trick.srt | 14.1 KB | ||
| 1. Table and Field Properties.mp4 | 119.3 MB | ||
| 1. Table and Field Properties.srt | 10.4 KB | ||
| 1. The 10 Minute Access Quick Tour.mp4 | 113.7 MB | ||
| 1. The 10 Minute Access Quick Tour.srt | 19.3 KB | ||
| 1. The FILE Menu - Part 1.mp4 | 74.5 MB | ||
| 1. The FILE Menu - Part 1.srt | 7.8 KB | ||
| 1. The Relationships Window.mp4 | 152.6 MB | ||
| 1. The Relationships Window.srt | 16.7 KB | ||
| 1. Updating the ProdName and Unit Price from ProdCode.mp4 | 205.8 MB | ||
| 1. Updating the ProdName and Unit Price from ProdCode.srt | 20.2 KB | ||
| 1. Using Functions and the Builder.mp4 | 130.1 MB | ||
| 1. Using Functions and the Builder.srt | 11.8 KB | ||
| 1. Using TOTAL Queries.srt | 11.2 KB | ||
| 1 | 0 B | ||
| 1. Using TOTAL Queries.mp4 | 126.3 MB | ||
| 1.1 Access Common Functions.pdf | 160.7 KB | ||
| 1.1 Data Type Quick Reference.pdf | 136.3 KB | ||
| 2 | 1.7 MB | ||
| 3 | 1.1 MB | ||
| 10. The VALIDATION RULE Property.mp4 | 239 MB | ||
| 10. The VALIDATION RULE Property.srt | 19.7 KB | ||
| 11. QUERY Properties.mp4 | 168.5 MB | ||
| 11. QUERY Properties.srt | 15.9 KB | ||
| 12. Report Properties and Fixing a Report Mess.mp4 | 180.3 MB | ||
| 12. Report Properties and Fixing a Report Mess.srt | 17.7 KB | ||
| 13. Fixing a Report Mess and Adding Page Footers.mp4 | 211.5 MB | ||
| 13. Fixing a Report Mess and Adding Page Footers.srt | 19.9 KB | ||
| 14. PROPERTIES Making Thousands of Choices Manageable.html | 204.8 B | ||
| 2. ACTION Queries - APPEND.mp4 | 103 MB | ||
| 2. ACTION Queries - APPEND.srt | 9.8 KB | ||
| 2. Adding, Editing and Deleting Records.mp4 | 142.1 MB | ||
| 2. Adding, Editing and Deleting Records.srt | 12.5 KB | ||
| 2. Create a Go To Customer Button.mp4 | 103.1 MB | ||
| 2. Create a Go To Customer Button.srt | 9.8 KB | ||
| 2. Create a Report with the Wizard and Work with Controls.mp4 | 370.8 MB | ||
| 2. Create a Report with the Wizard and Work with Controls.srt | 35.9 KB | ||
| 2. Finish Orders Form and Using TAB Controls - Part 2.mp4 | 126.3 MB | ||
| 2. Finish Orders Form and Using TAB Controls - Part 2.srt | 10.4 KB | ||
| 2. How to Get the Most Out of This Course.mp4 | 36.3 MB | ||
| 2. How to Get the Most Out of This Course.srt | 3.3 KB | ||
| 2. More Form Modifications.mp4 | 227.7 MB | ||
| 2. More Form Modifications.srt | 21.2 KB | ||
| 2. More Formatting on the Invoice Report.mp4 | 192.4 MB | ||
| 2. More Formatting on the Invoice Report.srt | 15.4 KB | ||
| 2. Query Criteria.mp4 | 95.2 MB | ||
| 2. Query Criteria.srt | 8.5 KB | ||
| 2. Subtotals in Reports.mp4 | 246.9 MB | ||
| 2. Subtotals in Reports.srt | 23.2 KB | ||
| 2. THREE Best Practices in Table Design with PDF.mp4 | 178.1 MB | ||
| 2. THREE Best Practices in Table Design with PDF.srt | 15.6 KB | ||
| 2. The Calculated Data Type.mp4 | 111.7 MB | ||
| 2. The Calculated Data Type.srt | 10 KB | ||
| 2. The FILE Menu - Part 2.mp4 | 97.7 MB | ||
| 2. The FILE Menu - Part 2.srt | 10.3 KB | ||
| 2. The Field INDEXED Property and Options, Object Designers.mp4 | 85 MB | ||
| 2. The Field INDEXED Property and Options, Object Designers.srt | 6.4 KB | ||
| 2. The Rest of the Database Tools.mp4 | 102.6 MB | ||
| 2. The Rest of the Database Tools.srt | 10.2 KB | ||
| 2. Update ProdCode and Unit Price from the ProdName Combo box.mp4 | 61.6 MB | ||
| 2. Update ProdCode and Unit Price from the ProdName Combo box.srt | 5.3 KB | ||
| 2. Using Mid and Instr.mp4 | 149.6 MB | ||
| 2. Using Mid and Instr.srt | 13.7 KB | ||
| 2. Working with the Navigation Pane, Menu, Ribbons and Objects.mp4 | 172.9 MB | ||
| 2. Working with the Navigation Pane, Menu, Ribbons and Objects.srt | 16.7 KB | ||
| 2.1 Access Table Movement and Editing.pdf | 104.7 KB | ||
| 2.1 Access365START.accdb | 9.2 MB | ||
| 2.1 Three Best Practices in Designing Table Structures.pdf | 242.3 KB | ||
| 3. A NOTE about VBA.html | 1.3 KB | ||
| 3. ACTION Queries - UPDATE.mp4 | 68.5 MB | ||
| 3. ACTION Queries - UPDATE.srt | 6 KB | ||
| 3. Add a Combo Box to our Form.mp4 | 302 MB | ||
| 3. Add a Combo Box to our Form.srt | 26.9 KB | ||
| 3. Conditional Formatting.mp4 | 97.9 MB | ||
| 3. Conditional Formatting.srt | 7.2 KB | ||
| 3. Create a To Orders Button in a Subform.mp4 | 130.3 MB | ||
| 3. Create a To Orders Button in a Subform.srt | 11.7 KB | ||
| 3. Create an Invoice Button on the Orders Form.mp4 | 71.2 MB | ||
| 3. Create an Invoice Button on the Orders Form.srt | 5.7 KB | ||
| 3. Create the Customer Form.mp4 | 322.9 MB | ||
| 3. Create the Customer Form.srt | 25.4 KB | ||
| 3. Date Criteria and Between.mp4 | 79 MB | ||
| 3. Date Criteria and Between.srt | 6.8 KB | ||
| 3. Example of using Switch.mp4 | 159.6 MB | ||
| 3. Example of using Switch.srt | 13.9 KB | ||
| 3. Getting Started with Access.html | 204.8 B | ||
| 3. OPTIONS 1 - General through Languages.mp4 | 124.5 MB | ||
| 3. OPTIONS 1 - General through Languages.srt | 11.8 KB | ||
| 3. Primary Keys What They Are and Why They Are Important.mp4 | 176.3 MB | ||
| 3. Primary Keys What They Are and Why They Are Important.srt | 15.8 KB | ||
| 3. REPORT Objects - the Basics.html | 204.8 B | ||
| 3. TABLE Design.html | 204.8 B | ||
| 3. The Database Tools Menu.html | 204.8 B | ||
| 3. The Hyperlink Data Type.mp4 | 64.2 MB | ||
| 3. The Hyperlink Data Type.srt | 5.4 KB | ||
| 3. The Text Field ALLOW ZERO LENGTH Property.mp4 | 74.5 MB | ||
| 3. The Text Field ALLOW ZERO LENGTH Property.srt | 6.3 KB | ||
| 3. Update the Main Form Total.mp4 | 284.9 MB | ||
| 3. Update the Main Form Total.srt | 28.5 KB | ||
| 3.1 Combo Boxes.pdf | 113.4 KB | ||
| 4. A New Order Button on the Customer Form.mp4 | 111.2 MB | ||
| 4. A New Order Button on the Customer Form.srt | 10.8 KB | ||
| 4. ACTION Queries - MAKE TABLE.mp4 | 105.3 MB | ||
| 4. ACTION Queries - MAKE TABLE.srt | 9.6 KB | ||
| 4. Basic Table Sorting and Filtering.mp4 | 96.6 MB | ||
| 4. Basic Table Sorting and Filtering.srt | 8 KB | ||
| 4. Changing Tab Order.mp4 | 81.2 MB | ||
| 4. Changing Tab Order.srt | 7.5 KB | ||
| 4. Create an Afterupdate for the UnitPrice and create a Delete Button.mp4 | 223.6 MB | ||
| 4. Create an Afterupdate for the UnitPrice and create a Delete Button.srt | 21.1 KB | ||
| 4. Create the Orders Subform.mp4 | 141.7 MB | ||
| 4. Create the Orders Subform.srt | 11.7 KB | ||
| 4. Domain Functions.mp4 | 105 MB | ||
| 4. Domain Functions.srt | 8.8 KB | ||
| 4. OPTIONS 2 - Client Settings through Trust Center.mp4 | 114 MB | ||
| 4. Using OR in Criteria.mp4 | 79.9 MB | ||
| 4 | 1.1 MB | ||
| 4. OPTIONS 2 - Client Settings through Trust Center.srt | 11.1 KB | ||
| 4. Predefined Formats in the FORMAT Property.mp4 | 90.3 MB | ||
| 4. Predefined Formats in the FORMAT Property.srt | 6.9 KB | ||
| 4. The OLE Object and Attachment Data Types.mp4 | 125.3 MB | ||
| 4. The OLE Object and Attachment Data Types.srt | 11.2 KB | ||
| 4. Using OR in Criteria.srt | 7.2 KB | ||
| 4.1 Attachment Data Type.pdf | 155.1 KB | ||
| 4.1 Custom-Formatting-Quick-Reference.pdf | 191.6 KB | ||
| 5. A Demonstration of Database Sharing.srt | 4.8 KB | ||
| 5. ACTION Queries - DELETE.mp4 | 66.8 MB | ||
| 5. ACTION Queries - DELETE.srt | 5.8 KB | ||
| 5. Advanced Sorting and Filtering.srt | 6.1 KB | ||
| 5. Create the Order Product List Subform.mp4 | 126.5 MB | ||
| 5. Custom Formats for TEXT in the FORMAT Property.srt | 11.1 KB | ||
| 5 | 1 MB | ||
| 5. A Demonstration of Database Sharing.mp4 | 57 MB | ||
| 5. Advanced Sorting and Filtering.mp4 | 63.8 MB | ||
| 5. Create the Order Product List Subform.srt | 11.7 KB | ||
| 5. Custom Formats for TEXT in the FORMAT Property.mp4 | 130.5 MB | ||
| 5. FORM Objects - the Basics.html | 204.8 B | ||
| 5. Modify the Add Order Macro to Plug the Name and Address.mp4 | 103.4 MB | ||
| 5. Modify the Add Order Macro to Plug the Name and Address.srt | 9.6 KB | ||
| 5. Parameter Queries and Showing All Fields.mp4 | 156.7 MB | ||
| 5. Parameter Queries and Showing All Fields.srt | 13.5 KB | ||
| 5. Testing Data Entry from Customer to Order.mp4 | 165.5 MB | ||
| 5. Testing Data Entry from Customer to Order.srt | 14.6 KB | ||
| 5. The FILE Menu.html | 204.8 B | ||
| 6. ACTION Queries - CROSSTAB.mp4 | 76.5 MB | ||
| 6. ACTION Queries - CROSSTAB.srt | 6.3 KB | ||
| 6. Add Subforms to Main Forms.mp4 | 133 MB | ||
| 6. Add Subforms to Main Forms.srt | 10.6 KB | ||
| 6. Advanced TABLES.html | 204.8 B | ||
| 6. Custom Formats for NUMBERS in the FORMAT Property.mp4 | 105.1 MB | ||
| 6. Custom Formats for NUMBERS in the FORMAT Property.srt | 8.5 KB | ||
| 6. Multi-Table Queries.mp4 | 191.5 MB | ||
| 6. Multi-Table Queries.srt | 18.2 KB | ||
| 6 | 563.8 KB | ||
| 6. New CustomerExit Buttons – Autoexec Macro.mp4 | 127.6 MB | ||
| 6. New CustomerExit Buttons – Autoexec Macro.srt | 10.7 KB | ||
| 6. Recalc Domain Functions and Force Proper Case.mp4 | 118.7 MB | ||
| 6. Recalc Domain Functions and Force Proper Case.srt | 11.3 KB | ||
| 6. TABLE Objects - the Basics.html | 204.8 B | ||
| 7. A Parameter Query Trick.mp4 | 76.9 MB | ||
| 7. A Parameter Query Trick.srt | 6.4 KB | ||
| 7. Afterupdate on City and Fill In State and Zip.mp4 | 184.8 MB | ||
| 7. Afterupdate on City and Fill In State and Zip.srt | 17.1 KB | ||
| 7. Custom Formats for DATES in the FORMAT Property.mp4 | 122.6 MB | ||
| 7. Custom Formats for DATES in the FORMAT Property.srt | 10.3 KB | ||
| 7. Macro Commands Used in This Section.html | 102.4 B | ||
| 7. Using Query Dynasets.mp4 | 91 MB | ||
| 7. Using Query Dynasets.srt | 7.2 KB | ||
| 7.1 MacroCommands.pdf | 154.5 KB | ||
| 8. Calculations in Queries Introduction to Functions.mp4 | 46.9 MB | ||
| 8. Calculations in Queries Introduction to Functions.srt | 3.9 KB | ||
| 8. Create an Unbound Company Search Combo Box.mp4 | 171 MB | ||
| 8. Create an Unbound Company Search Combo Box.srt | 14.4 KB | ||
| 8. QUERY Objects - the Basics.html | 204.8 B | ||
| 8. Using the INPUT MASK Property.mp4 | 124.8 MB | ||
| 8. Using the INPUT MASK Property.srt | 9.6 KB | ||
| 8.1 Input Masks.pdf | 182.8 KB | ||
| 9. Advanced QUERIES.html | 204.8 B | ||
| 9. Using an INPUT MASK with Phone Numbers.mp4 | 113 MB | ||
| 9. Using an INPUT MASK with Phone Numbers.srt | 9.8 KB | ||
| 9. VBA Code Used in This Section.html | 102.4 B | ||
| 9.1 VBACode.pdf | 115.5 KB | ||
| TutsNode.com.txt | 102.4 B | ||
| [TGx]Downloaded from torrentgalaxy.to .txt | 614.4 B | ||
| 7 | 317.9 KB | ||
| 8 | 456.5 KB | ||
| 9 | 507.1 KB | ||
| 10 | 702.9 KB | ||
| 11 | 198.8 KB | ||
| 12 | 1.5 MB | ||
| 13 | 1.6 MB | ||
| 14 | 283.2 KB | ||
| 15 | 465.8 KB | ||
| 16 | 1.2 MB | ||
| 17 | 1.7 MB | ||
| 18 | 1.9 MB | ||
| 19 | 1.7 MB | ||
| 20 | 2.1 KB | ||
| 21 | 1.1 MB | ||
| 23 | 1.5 MB | ||
| 24 | 503.5 KB | ||
| 25 | 394.4 KB | ||
| 26 | 1.3 MB | ||
| 27 | 1.9 MB | ||
| 28 | 1.4 MB | ||
| 29 | 360.6 KB | ||
| 30 | 1.9 MB | ||
| 31 | 328.1 KB | ||
| 32 | 894.4 KB | ||
| 33 | 1.4 MB | ||
| 34 | 1.7 MB | ||
| 35 | 981.9 KB | ||
| 36 | 1.5 MB | ||
| 37 | 1.7 MB | ||
| 38 | 1.9 MB | ||
| 39 | 439.1 KB | ||
| 40 | 1.5 MB | ||
| 41 | 1.7 MB | ||
| 42 | 1.7 MB | ||
| 43 | 682.8 KB | ||
| 44 | 1.2 MB | ||
| 45 | 1.5 MB | ||
| 46 | 1.4 MB | ||
| 47 | 709.9 KB | ||
| 48 | 1.3 MB | ||
| 49 | 2 MB | ||
| 50 | 317.4 KB | ||
| 51 | 977.3 KB | ||
| 52 | 1.6 MB | ||
| 53 | 284.3 KB | ||
| 54 | 840.2 KB | ||
| 55 | 764.5 KB | ||
| 56 | 928.4 KB | ||
| 57 | 1 MB | ||
| 58 | 609.9 KB | ||
| 59 | 938.8 KB | ||
| 60 | 975.1 KB | ||
| 61 | 1.4 MB | ||
| 62 | 88.2 KB | ||
| 63 | 279.1 KB | ||
| 64 | 1.4 MB | ||
| 65 | 822.5 KB | ||
| 67 | 1.7 MB | ||
| 68 | 1 MB | ||
| 69 | 806.3 KB | ||
| 70 | 94.7 KB | ||
| 71 | 988.3 KB | ||
| 72 | 1.1 MB | ||
| 73 | 1.5 MB | ||
| 74 | 1.5 MB | ||
| 75 | 1.5 MB | ||
| 76 | 858 KB | ||
| 77 | 1.5 MB | ||
| 78 | 1.2 MB | ||
| 79 | 1.8 MB | ||
| 80 | 209.8 KB | ||
| 81 | 367.9 KB | ||
| 82 | 1 MB | ||
| 83 | 1.1 MB | ||
| 84 | 1.7 MB | ||
| 85 | 772 KB | ||
| ▲ 283 total files | |||
Description
Just about everyone knows and uses Microsoft Excel, but many of the things they use Excel for would be better done with Access. In just about every office, there are people struggling with long, multi-step processes with Excel that could literally be done with a single mouse click in Access. The problem is that while Excel is the most awesome data analysis tool on the planet, it is not an effective database! BUT people are using it for that purpose anyway because it is all they know.
So why doesn’t everyone just use Access? Well, here is the bad news:
It is harder and takes longer to get productive with Access.
But then again there is some good news too:
It is harder and takes longer to get productive with Access.
What? Is that a typo? How can the good and bad news be exactly the same?
Here is the deal – MOST people won’t take the time to learn Access. They will continue to struggle doing their laborious, complex Excel database processes because they do not have the discipline and determination to learn new ways of doing things. BUT these people, and the companies they work for, are VERY HAPPY to pay someone who can show them a simple database that does these same tasks with a few mouse clicks.
No matter what office environment you are in, if you take the time to learn Access and implement it to automate some of your own tasks, you will soon be “discovered” by your co-workers and you will start getting requests for “help” with their work. Bosses who are not accustomed to getting exactly the report they want ahead of time will start asking for more detailed reports and the person who can deliver on these requests becomes much more valuable as an employee.
For you, the person who decided to work extra or work on your own time to get productive with Access, you will benefit for that short time of intense work for the rest of your life. Things that other people assume are very hard to do are not hard at all and every time you are confronted with something new, you learn a little more about Access.
The more you work with it, the better and more skilled you become. You will find that you have transitioned from semi-manual labor with Excel (copying and pasting, doing many steps), to THINKING about how to use the power of Access to automate the entire process. You will have enriched your work environment and your life!
I’ve worked with Access just about every day since it was first released and I learn more about what it can do every week! There is just about no limit to what you can do and you are limited only by your imagination.
So are you the one who wants to make a positive change in their life? Are YOU the one who is willing to work hard for awhile to reap the benefits forever? The person who will stand out, who will be as close to “layoff-proof” as possible and always in demand?
Take this course and let me layout the basics of Access and explain why everything I’ve said above is true – and could be true in YOUR LIFE too!
Who this course is for:
This course is for students who are dissatisfied with how they are handling data now and know there must be a better way.
This course is also for those who have attempted to learn Access before and been confused with courses that don’t seem to address real world problems, or explain the basics before burying the student in an avalanche of detail.
Students who realize that, if they make the effort to learn Access, they will save a great deal of time later.
Requirements
Students need a general knowledge of Windows and using Microsoft Office programs like Excel
Students should have an Office 365 subscription and have the latest version of Office installed, which includes Access
No database experience is needed. You will learn all that in the course!
Last Updated 9/2021
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 1.31 GB | stegguntbc | 1 year | 2 | 1 | |
| 826.7 MB | freecoursewb | 1 year | 12 | 0 | |
|
Udemy - Microsoft Access 365 - Access VBA and Automating Outlook Email Posted by
freecoursewb in Other
|
2.7 GB | freecoursewb | 2 years | 3 | 1 |
|
Microsoft Identity and Access Administrator Associate (SC-300) Cert Prep Posted by
freecoursewb in Other
|
513 MB | freecoursewb | 2 years | 2 | 0 |
| 1.1 GB | freecoursewb | 2 years | 0 | 0 |
All Comments