We will be undergoing scheduled maintenance on May 20th, 2013 at 02:00 GMT.
Microsoft Access 2013 Tutorials
Welcome / Access Grows Up
Subtitles of the Movie (Microsoft Access 2013 / Welcome / Access Grows Up)
Now here's one more for those of you who may be haven't been around Access very long. When you look at Access 2013 you're looking at a product that has really matured and grown up since it first appeared on the marketplace. And that's why you're going to see some of the glowing, almost over the top reviews and things that you're going to see on Access 2013. But let's back up just a little bit and talk about a little history here. Access first came to us, Access 1.0 the very first version was released November 13th 1992. Now there had been this massive flurry in the marketplace at that time because of a product called Ashton-Tate's dBase and then they started dBase 2, 3, 4, 5 I don't how far it went but this thing just absolutely overtook the market. And Microsoft jumped into the database, the small business, the small office team type database market with Access version 1.0 around November 13 1992. Now look at some of the numbers on this thing, it's almost comical now. It would store a database up to 10 megabytes. Now of course now 10 megabytes is no longer a database, that's a Word document. But back then that was a big deal because our average hard disk size in 1992 was under 500 megabytes. Okay. So there wasn't a whole lot of data being stored back then. So you could store up to 10 megabytes and this was a big deal. But you started to suffer from data corruption as the storage exceeded 10 megabytes. And so you know the next time you're tempted to complain just think about how all those old timers like I was, am had to deal with it back in the early 90s. Now Access 2013 just for you information, some useless trivia for the relatives. This will be version 15.0. And Access has become between version 1 and version 15 the standard small business and team database management tool. Now I've, I don't guess I've ever gone into a company that didn't have Access managing some data somewhere. Even if everybody there admits, man we got to get off Access which is where we're storing way too much data for it. You know it's having a little bit of trouble keeping up but it's there. Now one of the really neat things about Access that you don't see in a lot of other database products is it has the interface tools included. And so not only can you build your databases but you can also build the forms and the interfaces that the end user will use to speak to the database and manipulate the data. And also most of the data design management details are managed for you. Now this is both a blessing and a curse. Because especially in Access 2013, they're really done some neat stuff where you can just kind of point at some data, it will build the tables for you, create the relationships, build the interface for you. It just does everything, it's like magic. But keep in mind it's done the data design and management details for you but you probably want to go back and customize those things a bit and it is preventing you from getting in there and getting dirty and really understanding what's going on. Now the big thing with Access 2013 and the biggest sign you're sign going to see that this thing has really grown up and matured for how we're using computers now, is that it focuses on the web. A database can now be hosted through Office 365 that is a subscription service from Microsoft. At the time that I was recording this video you could sign up for a 30 day trial of Office 365 totally free and then see what you thought. You should be able to do that still by the time you see this but who knows? The databases that you build for the web on Access 2013 are securely accessible from any tablet or computer. And those tablets or computers do not require that you have Access installed on the device, why? Because it's going to connect and run through the browser. So if you've got a browser on your device you can use the Access that's being hosted in Office 365. Now Access also for the first time really strongly integrates with SharePoint as a SharePoint app. Now in previous versions Access 2010 you could work with some SharePoint lists through Access and so forth. But with this you can run an Access database as a full fledged SharePoint application we'll talk more about that later. Also Access now is beginning more and more and more to integrate with SQL Server. When you create an app in SharePoint that connects to SharePoint, you basically builds a SQL Server database to store your Access data. Kind of neat and again go out and do some reading on this, this whole SharePoint app thing with Access 2013. It's pretty fascinating stuff and some of it will get a little over our head for this level of course but I'll mention some of it. Okay. Now it also integrates with SQL Azure. Now Azure is Microsoft's Cloud storage access functionalities. And Access also works with that. So you can create an Access database, put it up in the Cloud and all the advantages of the Cloud, backups you know multiple access from different locations, all that sort of stuff is there. Now Access also in 2013 introduces automatically created user interfaces and I can hear some of you chucking right now, oh yeah, yeah, oh yeah. An automatically created user interface, I bet that's pretty. Let me tell you I've been playing with this and it is shockingly well done. So watch for that, we'll see it some in here and you can play with it yourself. And these interfaces by the way once it creates them can be customized so it's a pretty good deal here. So Access has definitely grown up, it continues to mature. I think you're going to like what you see in Access 2013 but this is what all the hoopla is about.
Tutorial Information
| Course: | Microsoft Access 2013 |
| Author: | Mark Long |
| SKU: | 34405 |
| ISBN: | 978-1-61866-090-9 |
| Release Date: | 2013-02-01 |
| Duration: | 7 hrs / 89 lessons |
| Work Files: |
Yes |
| Captions: | No |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7, Flash 8 |
VTC Sign up & Benefits
- Unlimited Access
- 81,350 Video Tutorials (14,200 free)
- Video Available as Flash or QuickTime
- Over 715 Courses
- $30 for One Month Access
- Multi-User Discounts Available
