Microsoft Access Expert
Microsoft Access Expert
  • Видео 472
  • Просмотров 1 834 063
Using Excel as a Database: Eating Soup with a Fork
While Excel is clearly king among spreadsheets, it is not a true relational database. Despite this fact, users far and wide often try to force Excel to function like a database, which could be compared to eating soup with a fork. When a true database is needed, Excel is not the right tool for the job. Let's talk about why!
www.linkedin.com/feed/update/urn:li:activity:7130983269755469824
#Databases #DataManagement #DatabaseProgrammers #DatabaseExpert #Microsoft #MSExcel #DatabaseHelp
WINNING SOLUTIONS, INC.
836 N. 2nd Street
Ames, Iowa 50010
(515) 239-9900
Просмотров: 60

Видео

Winning Solutions for Manufacturing!
Просмотров 289 месяцев назад
WSI had a large number of clients that are in the manufacturing sector. - Let's talk about it! WINNING SOLUTIONS, INC. 836 N. 2nd Street Ames, Iowa 50010 (515) 239-9900 Hire us for a project www.winningsolutionsinc.com/Contact-WSI.aspx www.microsoftaccessexpert.com www.winningsolutionsinc.com
What can custom manufacturing software do for your production line?
Просмотров 5310 месяцев назад
WINNING SOLUTIONS, INC. 836 N. 2nd Street Ames, Iowa 50010 (515) 239-9900 Hire us for a project www.winningsolutionsinc.com/Contact-WSI.aspx www.winningsolutionsinc.com SOCIAL MEDIA AmesWSI MSAccessExpert WSITech ruclips.net/user/msaccessexpert www.linkedin.com/company/winning-solutions-inc-
Microsoft Access Front-End Updates for Shared Databases Made Easy
Просмотров 49311 месяцев назад
Microsoft Access front-end updates to databases that are running over a network between multiple users doesn't have to be hard. We can help. Check out our blog to learn more: www.winningsolutionsinc.com/Referrer-Blog/Microsoft-Access-Front-End-Files.aspx WINNING SOLUTIONS, INC. 836 N. 2nd Street Ames, Iowa 50010 (515) 239-9900 Hire us for a project www.winningsolutionsinc.com/Contact-WSI.aspx w...
Microsoft Access Fact Check
Просмотров 7211 месяцев назад
With a 30-year pedigree, Microsoft Access has a mixed reputation, but check out the facts. This rapid development tool has endured the test of time for some very good reasons and should not be overlooked. www.linkedin.com/pulse/5-reasons-microsoft-access-has-bad-reputation-fact WINNING SOLUTIONS, INC. 836 N. 2nd Street Ames, Iowa 50010 (515) 239-9900 For more information about our services, vis...
Why Custom-Built Software is a Win-Win
Просмотров 37Год назад
Elon Musk of Tesla will not use software that is not in-house or custom made. So the lesson? If you want to be as big as Tesla, you should probably do the same. WINNING SOLUTIONS, INC. 836 N. 2nd Street Ames, Iowa 50010 (515) 239-9900 Hire us for a project www.winningsolutionsinc.com/Contact-WSI.aspx www.microsoftaccessexpert.com www.winningsolutionsinc.com SOCIAL MEDIA AmesWSI fac...
Custom is Best
Просмотров 38Год назад
Join Mark Steffen and Jenny Baynes to find out why WSI's special of customized software is the best way to go. WINNING SOLUTIONS, INC. 836 N. 2nd Street Ames, Iowa 50010 (515) 239-9900 Hire us for a project www.winningsolutionsinc.com/Contact-WSI.aspx www.microsoftaccessexpert.com www.winningsolutionsinc.com SOCIAL MEDIA AmesWSI MSAccessExpert WSITech rucli...
Microsoft Access Tutorial - Trusted Locations
Просмотров 305Год назад
If you're getting a message in Access about security warnings, why not come in and find out why? WINNING SOLUTIONS, INC. 836 N. 2nd Street Ames, Iowa 50010 (515) 239-9900 Hire us for a project www.winningsolutionsinc.com/Contact-WSI.aspx www.microsoftaccessexpert.com www.winningsolutionsinc.com SOCIAL MEDIA AmesWSI MSAccessExpert WSITech ruclips.net/user/ms...
Backing Up SQL Server Databases
Просмотров 30Год назад
WINNING SOLUTIONS, INC. 836 N. 2nd Street Ames, Iowa 50010 (515) 239-9900 Hire us for a project www.winningsolutionsinc.com/Contact-WSI.aspx www.microsoftaccessexpert.com www.winningsolutionsinc.com 0:00 Introduction 0:55 Backing up database 4:48 Conclusion SOCIAL MEDIA AmesWSI MSAccessExpert WSITech ruclips.net/user/msaccessexpert www.linkedin.com/company/...
About Being a Microsoft Partner
Просмотров 55Год назад
Find out more about the advantages of working with a Microsoft Access Partner at www.microsoftaccessexpert.com/defaultpromo.aspx WINNING SOLUTIONS, INC. 836 N. 2nd Street Ames, Iowa 50010 (515) 239-9900 Hire us for a project www.winningsolutionsinc.com/Contact-WSI.aspx www.microsoftaccessexpert.com www.winningsolutionsinc.com SOCIAL MEDIA AmesWSI MSAccessExpert twitter...
MS Access Tutorials: Linking and Re-linking SQL Server Databases
Просмотров 810Год назад
MS Access Tutorials: Linking and Re-linking SQL Server Databases
MS Access Tutorial: Linking SQL Server Databases
Просмотров 221Год назад
MS Access Tutorial: Linking SQL Server Databases
Linking and Re-Linking Tables
Просмотров 2552 года назад
Linking and Re-Linking Tables
Zip Files in Windows 10
Просмотров 922 года назад
Zip Files in Windows 10
Access Tutorial: How to Put a Login Screen In Your App
Просмотров 2602 года назад
Access Tutorial: How to Put a Login Screen In Your App
Form with ActiveX controls stops working when copied?
Просмотров 2512 года назад
Form with ActiveX controls stops working when copied?
Microsoft Access: 32 or 64 Bit
Просмотров 6332 года назад
Microsoft Access: 32 or 64 Bit
Importing Multi-Table Data From the Internet- PART 2 OF 2
Просмотров 642 года назад
Importing Multi-Table Data From the Internet- PART 2 OF 2
Importing Multi-Table Data From the Internet - PART 1 OF 2
Просмотров 992 года назад
Importing Multi-Table Data From the Internet - PART 1 OF 2
Access Tutorial Video: Progress Bars
Просмотров 1832 года назад
Access Tutorial Video: Progress Bars
Understanding WSI Invoices
Просмотров 1442 года назад
Understanding WSI Invoices
Append Only Data Fields in Access - Convenient or to be avoided?
Просмотров 3472 года назад
Append Only Data Fields in Access - Convenient or to be avoided?
Can't re-open Access database and the lock file won't go away? Here's a solution.
Просмотров 5 тыс.2 года назад
Can't re-open Access database and the lock file won't go away? Here's a solution.
Access Update: Possible Issue Opening Networked Databases Due to Update Bug
Просмотров 4092 года назад
Access Update: Possible Issue Opening Networked Databases Due to Update Bug
Access Demo: Database Compact & Repair
Просмотров 1602 года назад
Access Demo: Database Compact & Repair
NFT Terra Virtua Database Template
Просмотров 1282 года назад
NFT Terra Virtua Database Template
NFT Campus Legends Database Template
Просмотров 552 года назад
NFT Campus Legends Database Template
Access or FileMaker Pro? Part 2
Просмотров 2292 года назад
Access or FileMaker Pro? Part 2
Access or FileMaker Pro? Part 1
Просмотров 1,1 тыс.2 года назад
Access or FileMaker Pro? Part 1
Production Scheduling Database Template
Просмотров 4942 года назад
Production Scheduling Database Template

Комментарии

  • @willieguyton-sb6rl
    @willieguyton-sb6rl Год назад

    does it keep track of when training has expired and they need to take a recertification class?

  • @shaimaal-shawaf1666
    @shaimaal-shawaf1666 2 года назад

    Thanks for the demo, one question, is it accessbale by all (team/assignees) for them to update the task?

    • @wsitech
      @wsitech 2 года назад

      Thank you for watching. The database, like all others, can be customized to require a login, with certain users or levels being able to access certain screens. As-is, anyone who opens the database could use all features, but this is easily modifiable.

  • @senometalinc.6719
    @senometalinc.6719 2 года назад

    Hi, How do you display other fields from the foreign key? For example: Customer Table: CustomerID (primary key) CustomerName Link (1 is to many) Invoice table: Invoice number (primary key) CustomerID(foreign key. Dont want to display this) CustomerName (i want this to display)

    • @wsitech
      @wsitech 2 года назад

      Hi Seno, What do you mean by display other fields? If it's a query, you can include any fields in those tables.

  • @akokohjoel9854
    @akokohjoel9854 3 года назад

    Thanks, for showing a demo. Pls can you share a video on how loan amortization can be done build using ms access, how to create loan overdue. Pls kindly help

    • @wsitech
      @wsitech 3 года назад

      Hello - this template should be a good starting point for your loan amortization needs.

  • @christopheraslanidis4282
    @christopheraslanidis4282 3 года назад

    Hello there can you make a similar database that will make a schedule for students and teachers by using students information, teacher information, class location and class time? like a database that will generate a schedule for individual students by a report. Please help a brother out! I love you content by the way!

    • @wsitech
      @wsitech 3 года назад

      Hello, and thank you for the kind words. In short, we can create ANYTHING. Our templates are designed to be expanded upon and/or included in larger databases. If you reach out to us (our contact info is at www.microsoftaccessexpert.com/), we'll be glad to put together a quote for you. Thank you for watching!

  • @amal2503
    @amal2503 3 года назад

    Good one. How this can work when the data entry form is interface with excel vba form. Please advise

    • @wsitech
      @wsitech 3 года назад

      Hello Amal, and thank you for your question. The way that this technology works is that it provides a web-based interface to an Access database, so that the database can be used through a web plugin the same way you would use it if it were on your desktop. So for example, if you had a database that interacted with an Excel spreadsheet, as long as both are on the computer or server together (i.e. you would use the Access database normally on the server that the technology is stored on), the spreadsheet and database itself are not on the web, you're only accessing it over the web. I hope this answers your question, if not feel free to reply.

    • @amal2503
      @amal2503 3 года назад

      Ok, Thankyou!

  • @amyc3247
    @amyc3247 3 года назад

    Kudos for the video but the sound quality is subpar. At times, you cannot be heard even at full volume.

    • @wsitech
      @wsitech 3 года назад

      Thank you for your feedback. There actually is a newer version here ruclips.net/video/ptan8YdSs3Q/видео.html.

  • @jamesrakestraw7125
    @jamesrakestraw7125 3 года назад

    Do you have a ms-dos to make a database?

    • @wsitech
      @wsitech 3 года назад

      Our primary database tool is Microsoft Access which requires Microsoft Office, so we work with Windows systems. MS-DOS is an older operating system, incorporated into modern versions of Windows. We can also make databases that are accessible over an Internet browser, which do not require MS Access and could be accessed from any device.

  • @resaseptiana755
    @resaseptiana755 3 года назад

    How to make it (default value) empty field?

  • @akokohjoel9854
    @akokohjoel9854 3 года назад

    Pls can you create a video on loan amortization/schedule step by step

    • @wsitech
      @wsitech 3 года назад

      Thank you for your comment. I just want to clarify, are you talking about a video on how to use the loan amortization database? I will check and if we don't have one we'll put it on the list.

  • @akokohjoel9854
    @akokohjoel9854 3 года назад

    You are doing a great job, but is being long you create loan amortization/schedule. Pls can you create a simple step by step video on how to build/created loan amortization from scratch. Pls kindly give kind attention to the request. Thanks so much

    • @wsitech
      @wsitech 3 года назад

      Hello Akokoh, we have a video for this template up at ruclips.net/video/HJPy7mHff94/видео.html. Did you mean something else?

  • @jimmcpherson1133
    @jimmcpherson1133 3 года назад

    I would edit this video with a clear objective in mind. Rather scattered and with no clear outcome explained.

    • @wsitech
      @wsitech 3 года назад

      Thank you for your input, Jim. The outcome is to demonstrate the database, but we will take your input into consideration. Do you have any specific questions I can help you with?

  • @melvinv2506
    @melvinv2506 3 года назад

    Great video, is this a template I can download or is it provided on Microsoft Access?

    • @wsitech
      @wsitech 3 года назад

      Thank you! It is a fully functional Microsoft Access database. It is also used as a template to make a larger database application around, for example if you wanted a database app to keep information for a large family, etc. Please feel free to let us know if you have any questions: www.microsoftaccessexpert.com/Contact-WSI.aspx. Thank you for watching!

  • @alexxccccxbbb9952
    @alexxccccxbbb9952 3 года назад

    Hello do you have a phone number I could call you on? I have a quick question. Thanks

    • @extremeestabrooks7522
      @extremeestabrooks7522 3 года назад

      Hello - you can get our contact information at: www.microsoftaccessexpert.com/Contact-WSI.aspx

  • @KayakingCalifornia
    @KayakingCalifornia 7 лет назад

    Is there a setting you can change to prevent the session from dropping when publishing a large zip folder through ftp on expression web 4 ?

    • @wsitech
      @wsitech 7 лет назад

      Janice, if you can email Ben at bgrotzke@winningsolutionsinc.com he will be more than happy to answer that.

  • @sangaramedi
    @sangaramedi 7 лет назад

    how to step recovery split database access

    • @wsitech
      @wsitech 7 лет назад

      Hi Sangar, Yes we can show you how to do that. Please contact Ben Grotzke at bgrotzke@winningsolutionsinc.com. Thank you

    • @sangaramedi
      @sangaramedi 7 лет назад

      You sand me link website !!!....I do not understand ..i deleted split how recovery my project..its not working because I deleted step splitting 😔

    • @wsitech
      @wsitech 7 лет назад

      Can you Email Ben Grotzke BGROTZKE@winningsolutionsinc.com

  • @jeanronychavannes6828
    @jeanronychavannes6828 7 лет назад

    In Accdb format

  • @jeanronychavannes6828
    @jeanronychavannes6828 7 лет назад

    Good evening I congratulate you for the database please I could have this database on my email jrchavannes@yahoo.fr

    • @wsitech
      @wsitech 7 лет назад

      Hi there! Could I have you e-mail my colleague Ben at bgrotzke@winningsolutionsinc.com with some more details about what you are wanting? Then we can assist you from there. Thanks!

  • @slyowusu99
    @slyowusu99 7 лет назад

    Hello. Do you have a database for organising staff shifts for a year? To track shifts, annual leave, sickness absence for the year?

    • @wsitech
      @wsitech 7 лет назад

      Hey there, yes we do! We actually have multiple database templates that may work for you. You can find them on our website. One is our staff shift scheduling template: www.microsoftaccessexpert.com/Microsoft-Access-Staff-Scheduling-Database.aspx And the other is our employee schedule template: www.microsoftaccessexpert.com/Microsoft-Access-Employee-Scheduling-Database.aspx

    • @wsitech
      @wsitech 7 лет назад

      Hello I was wondering if you ever found the database that you needed?

  • @ayubkarem8697
    @ayubkarem8697 7 лет назад

    hi dear friend i am working with an international humanitarian organisation ,i have plan to use ms access on tablet with windows 7 or 10 and put ms app on it ,it will be very useful for us specialy for data collection ,there are many types of tables ,so is it possible to use any of these types ?thanks for helping me

    • @wsitech
      @wsitech 7 лет назад

      +ayub karem Based on the information you provided, that does sound possible. However, we need more detailed information to be completly sure of its possibility. If you need help developing or have another question, send an e-mail to bbundy@winningsolutionsinc.com. Thanks!

  • @micheallivingston8607
    @micheallivingston8607 7 лет назад

    Can you integrate this with SharePoint?

    • @wsitech
      @wsitech 7 лет назад

      Hey there Micheal. Yes, you can integrate this database template with SharePoint.

  • @sulaimanjalloh1785
    @sulaimanjalloh1785 7 лет назад

    I am really interesting this database membership template

    • @wsitech
      @wsitech 7 лет назад

      +sulaiman Jalloh Hi there! If you are interested in this database template, you can try out a free demo of the database template before you decide if you want to purchase the template or not. You can find the demo, as well as the purchase link, on our website at: www.microsoftaccessexpert.com/Microsoft-Access-Membership-Tracking-Database.aspx

  • @stuartmcintosh2976
    @stuartmcintosh2976 7 лет назад

    Is this suitable for people in the UK, it seemed very US orientated in the demo, if the phone numbers have to be inputted in a specific format of US phone number layout, will I not be able to input UK phone numbers?

    • @wsitech
      @wsitech 7 лет назад

      +Stuart McIntosh Yes, this database template is suitable for the UK as well. Winning Solutions, Inc. can easily develop the database to meet any wish that you want. So upon purchasing the database template, you would simply need to let us know what you want, and we will quickly develop it for you.

  • @BiohazardSleay
    @BiohazardSleay 8 лет назад

    At 5:26 there is a field called member ID, are you able to change that as we already give out member ID numbers

    • @wsitech
      @wsitech 8 лет назад

      +BiohazardSleay Yes, you can input your own member ID numbers. The template is designed to be easily customized! If you would like to try out a free demonstration of the database template, you can find it on our website here: www.microsoftaccessexpert.com/Microsoft-Access-Membership-Tracking-Database.aspx

    • @BiohazardSleay
      @BiohazardSleay 8 лет назад

      +Microsoft Access Expert How would i be able to input my own ID numbers? I have the free demonstration template and I am finding it difficult to do so, is there a guide or something that I could download in order to fully understand the workings of the file? Any Information would be greatly appreciated.

  • @NeilHolloway
    @NeilHolloway 8 лет назад

    worked great thanks - the basic box was where I was going wrong

  • @michaelrichardson7170
    @michaelrichardson7170 8 лет назад

    This was a nice video. I run a workshop of about 75 mechanics, and we have created a database that captures all labor aspects at different steps, material aspects, material inspection data, etc. Currently, the mechanics clock into, add inspection data, etc at one of the computers in the shop. Of course, this can be a bottle neck in the production process, and I'm looking to reduce this inefficiency, buy purchasing a tablet for each person. This will be used to add all data at the work bench and hopefully speed everything up. My question is, do you still think this model is my best option currently, and do you think this will work?

    • @wsitech
      @wsitech 8 лет назад

      +Michael Richardson Thank you, we are glad you liked our video. Since you haven’t already invested in iOS or Android tablets, the method shown in your video should be your best option. There are other creative ways to make iOS and Android tablets function as an interface to your Access database, not covered in this video. For those of you who already bought tablets for those OS’s. If you search sites like Microsoftstore.com, NewEgg.com and Amazon for Windows tablets, you will find lots of viable options below $200. Which is a good value. Of course, environmental conditions may be a factor in your shop environment. So, a $200 tablet may not be rugged enough to hold up. Used off-lease desktop PC’s from a local computer re-cycler can also be a cost effective option for time entry. They take up more space, but have a full keyboard and bigger screen. This solution works best when you create a specific Access FE just for time entry. That allows you to customize the button sizes, fonts, etc. to be useable and legible on the size of screen you have for the user entering the data.

  • @waqaskhan-zi4ub
    @waqaskhan-zi4ub 8 лет назад

    Nice video!

  • @james44203
    @james44203 8 лет назад

    Very well done. Brian Meyers enunciation is quite good. Enjoyed this series and will look for more.

  • @gezachewbegashaw1281
    @gezachewbegashaw1281 8 лет назад

    Thank you for posting this video. I was in the middle of a serious assignment when i found out i didn't know how to zip access files and started watching your video........concise, sharp and amazingly presented.

  • @donnaconnor8499
    @donnaconnor8499 8 лет назад

    I'm looking for a database to Keep track of my coaches and their clients. Will this do the job or can it be modified to do the job?

    • @wsitech
      @wsitech 8 лет назад

      +Donna Connor Please go to winningsolutionsinc.com and fill out the contact form or email Ben at bgrotzke@winningsolutionsinc.com and he will be able to assist you further. Thank you and have a great day.

  • @thomasjones4512
    @thomasjones4512 8 лет назад

    Great Video. Thanks. I was planning to install just the runtime on the tablet and then develop an application in MS access on my desktop. I Plan then to put the app on the Tablet and give it to a team to replace paper filled forms. I will then get the tablets back and update or append data into the db that we have. I have considered using SharePoint as a backend but some locations don't have an ip address. And I know access has an issue with sizing and aspect ratio. Your thoughts?

    • @wsitech
      @wsitech 8 лет назад

      +Thomas Jones Thank you for that. there are several options for you. you could do a .Net application or an Access one with Microsoft run-time. I recommend a SQL back end with either option for you. I would be happy to discuss your needs with you. Please feel free to email me at bgrotzke@winningsolutionsinc.com. Thanks, Ben

  • @mivanows
    @mivanows 8 лет назад

    It will be nice if it could show the name of process. eg: Running query ..."query Name"

    • @wsitech
      @wsitech 8 лет назад

      +Mark Ivanowski If you could email Ben at Bgrotzke@winningsolutionsinc.com with what you are looking for hey may be able to get those to you.

  • @ErinAsylum
    @ErinAsylum 9 лет назад

    great job, thanks alot

  • @crowsbridge
    @crowsbridge 9 лет назад

    I wonder if LinkdIn has something similar?

  • @jonbach2012
    @jonbach2012 9 лет назад

    Great. Just what i needed!

  • @wsitech
    @wsitech 9 лет назад

    Check out our new video tutorial about our Microsoft Access Record File Management Template

  • @gerfer6261
    @gerfer6261 10 лет назад

    Keep it up - clear instructions

  • @hudahakim7002
    @hudahakim7002 10 лет назад

    Yes, it doesn't explain how I can do it on my own personal database. How can I add a calculator to my own database?

  • @TommyInVancouver
    @TommyInVancouver 11 лет назад

    Nice videos

  • @wsitech
    @wsitech 11 лет назад

    No problem. Glad the video was of use to you. Feel free to contact me for DNN support or services.

  • @walterpoppevilla8423
    @walterpoppevilla8423 11 лет назад

    Thank you so much!!!!...

  • @wsitech
    @wsitech 11 лет назад

    We can make any customizations you would like. Either contact us through our Microsoft Access Expert site (link is in the description). Or call 1-866-4-WINSOL to talk directly to one of our representatives. Thank You.

  • @wsitech
    @wsitech 11 лет назад

    I will put it on the list. Thanks.

  • @lightandsounder
    @lightandsounder 11 лет назад

    nice videos! Would you be able to do a tutorial on how to set up NB_Store? Just wondering since you asked.

  • @27oslec
    @27oslec 11 лет назад

    sir, can you help me make a payroll using access by displaying the daily timesheet table. (i.e. empID, 1-Wed, 2-Thu, 3-Fri, until 31.

  • @wsitech
    @wsitech 11 лет назад

    DNN Tutorial: How to add a Twitter Feed to a DotNetNuke Website

  • @wsitech
    @wsitech 11 лет назад

    DNN Tutorial: How to add a RUclips video to a DotNetNuke website.