English Subtitles for 1. Introduction (Programming in Access 2013)



Subtitles / Closed Captions - English

hello everybody my name is Steve bishop and i'm going to start doing a series in

programming and access 2013 I have been a developer of access for only about just a little over a year but i have worked on some very large projects and I think you could definitely learn from what my experience has been because i think for people who are especially starting out you'll run into pitfalls you'll start running into problems running into

issues and those are the same types of things that I've had to learn I've had no formal training in developing access I just literally learned straight off of what was on the internet and available to me through watching video series like this one and I figured I'd give back to the community a little bit by making my own especially because i think i run into some of the same pitfalls that most people do and I'm sure

during this process of going through the programming and access 2013 series i will run into some of those pitfalls and you'll see me encounter them and you'll learn how I overcome them and kind of how you sometimes have to backtrack or modify how you plan on doing something in order to make it work the way that you originally intended so let's go ahead and get started here so what is access some of you may

already know some of this may be old news but a lot of people may not really know what access is well access is essentially a relational database system with rapid rapid development basically has or rad and with access it makes it very very easy to develop both a way of maintaining your data if you were large business or a small business you just wanted to say keep track of sales or customers or as you know a client list of some sorts

access is really good for that it allows you to develop interface for your for yourself so you can enter in data into the these objects in the background called tables which we'll get to in just a little bit but it's a way of organizing your data and and making an application for yourself very quickly and easily to get to that data and put it in

so why should you use access well you should probably be using access if you're looking for something that's going to be a very quick way to design and develop your data and organize it with easy access you can print reports you can you know you can do just about anything and access with your data which makes it a very very wonderful application for you to learn and if your plant it's a good jumping start to if you're planning on getting into some of

the more developed programming languages knowing how to organize your data and developed forms create reports etc is going to be very helpful for you in the future if you plan on going into the dotnet framework so who uses access while access can be used by mostly i would say it was smaller businesses or single person just trying to organize their data

you know keep track of certain financial things or keeping track of client lists etc so if you're in the if you're interested in trying to organize your data keep track you know manage your clients you can you know print invoices that sort of thing that's really probably the primary example but really access can be useful for just about every situation and scenario you don't even have to use the

data the data tables itself you could just have a simple form that has object-oriented programming which we will get into a little bit later and i'm probably using some big terms but access is really exciting because it integrates so many of those wonderful useful features that you will find in other programming languages so do you need any necessary skills getting up to access well hopefully you

understand English well enough because that's the language I speak I don't honestly speak any other languages you need to be able to have some pretty good logical skills in and this is no I'm not trying to put down anybody but there are certain people that just may not be able to catch on to what access is about or programming in general and it's not it may just take some time for those people to get used to it but i

know that there are people in here that was just the moment they start thinking about organized seeing my data visual basic oh my gosh I don't really want to get into that they get overwhelmed and they don't really want to do it but other than that I mean as long as you have access on your computer which comes with office professional or home and business as long as you have that on your computer

that's really all you need you don't need to have any at least for this particular course i'm going to try to walk you through as best as I can how to go about creating and designing access with as few skills as possible required up of upfront because I started out with no skills so if i can do it i think anybody else can so i'm going to divide access into three basic sections and these different

sections really integrate with one another but it's helpful if we if we organize things and try to cover them in in some sort of organization but you'll see later on how these all integrate with one another and the first thing is you really have something called a database this is a kind of your this is where your data is actually stored ok as it's essentially your database so where does where does your database what

is a database where does it go where your data go and that could be any number of different types of database systems and these are just some of these are the more popular ones you got oracle my sequel ms much Microsoft's equal access itself is actually a database system which accesses call is runs on something called the jet engine so you may hear that term frequently whenever you're dealing with access so

oracle my sequel ms sequel and access are all different types of bait database systems there are many others there's a post agree you know there's you know honestly and none of them none of the other ones are coming off the top of my head but you can really there's a bunch of ones out there called no sequel which are really interesting

there's also other types of ways that you can store information like xml files or JSON which are more web based web oriented ways of storing your data but primarily your relational databases are oracle my sequel ms sequel and access these are the ones that will be focusing on during this course so in databases there will be types of data because obviously not all data is the same sometimes you have numbers sometimes you have geographical locations

sometimes you have what we call string or text which is just you know it like say for example and addresses bait up of both numbers and letters well that would actually be considered string or text and when it comes to databases they're stored as a form of text different types of data can be like and bar car or in Access it's just text or you can have numeric or float or double

and we'll get all those different data types a little bit later but just understand that you're different kinds of data will have to be you will need to know what what is the type of data that you're planning on putting into your database in in any particular circumstance and it will become pretty obvious to you as you start going along

what it is it's going to happen so you also will need to know when it comes to databases how is it organized what first of all you have these things called tables and we'll get into all of that but essentially your data gets stored into these tables which her if you've ever dealt with excel you'llyou'll your you'll see these tables and they'll make a lot of sense to you because tables are very similar

to the way that information is organized in Excel you have cells you have columns you have rose and you know it's really very simple as far as how those tables are funk function relationships are the way in which different tables interact with each other because you may have say for example an address and you want to break

down your address into different sections maybe you want to have your addresses the first line is in one table the second line is in another table and your zip codes are stored in another table and how all of those interact and become one one piece of information is very important you need to be able to know I have this customer and this is their address you may store the customer names

in one table and the address information and another table which is a very common situation will go into the relationships obviously in great detail so how do you get to the data and that's where we have these things called queries you have a special what they call sequel language or SQL on and the sequel the sequel is a query language that basically is a type of coding in a way which organize your data

tells the database how you want your data what kind of data you're going for and how that you want it organized and you can do calculations and such there's a lot that you can do with your queries to really organize your data and tell your tale your database is exactly the format in which you want that data to come back the second part will be going over is the user interface

this is things like how do you get the person actually put in data obviously you've got a database in the background you want to be able to have somebody put data into that data into that database so you have these things called forms which allow somebody to type data and store it etc then obviously you need to know how that information is supposed to be displayed to the user ok and that's primarily in the form of reports and forms and then you also have

and I put exporting as part of the user interface because essentially would what you're doing with an export is you're trying to either interact with another storage system of data which the user then we'll deal with on their own sometimes you can have some automatic integration like if you want to print something for you want to store it to PDF but usually once you export the file

out to another system then the user has to interact with that so it's kind of a user interface way of dealing with the data wants to put out and you will have different ways that this information gets displayed to the user in the exports so the third and final section we're going to talk about is the code behind and this is this consists of vba and there is also something called macros

which we'll get to in just a second but vba is essentially visual basic for applications and this is a this vba is used in all office applications including Excel Word and access all use vba so if you know vba which is just essentially visual basic 6 with a little application twist so if you know any visual basic 6 which has been discontinued by Microsoft by

the way vba will be very very simple to you and actually that's one of the nice things about learning from the vba standpoint is that you actually are learning vb 6 which was the version of visual basic prior to the dotnet releases and code behind can be you know your your vba is basically organized into either modules uh-oh looks like I'm missing out there we go or classes and classes are a form

of object-oriented programming and vba uses classes and can use object oriented programming in order to design your your code and how things are interact interact with the with the person who's using your application macros are a simple way of there are very kind of dumbed down version and not to say that they're not complex that they can't do complex things they're just kind of a very simple way of of doing things and interacting with your

application that you know if you want to like move back and forth between screens but you want to do it quickly without having to do all the vba code in the background you can do that with macros I personally tend to stay away from macros I don't really find them useful in any way but certainly some people can they will not be covered in this course I don't really want to get into macros because honestly everything you can do

it macros you can do with vba and vba is just much more extensive and gives you a little bit more control over how everything operates in the background alright so let's go ahead and get started with the first section here and i hope you guys are as excited as I am to get this this party started thank you very much



Video Description

In this video Introduction to "Programming in Microsoft Access 2013", host Steve Bishop discusses what will be covered in this Programming In Access 2013 series.
In this video series Steve will be going over Database Development in Access, creating the User Interface, and coding the backend of the application in Visual Basic for Applications (VBA).

Click here for the full playlist of"Programming in Access 2013"
http://www.youtube.com/playlist?list=PLYMOUCVo86jEeMMdaaq03jQ_t9nFV737s

Click here for the Work Files of this series:
https://drive.google.com/folderview?id=0BzRSeswr8T9kZUtXRmJ1VS1yQUU&usp=sharing