Download Your Free Ms Access Invoice Template for Engineering Now

Ms access invoice template free download for Engineering

in this first video we're going to create the customer table I'm going to choose all programs and go look for Microsoft Office and choose Access 2013 the first thing I'm going to do is start a blank database so I'll click here on the database icon for blank access forces you to save your file before you begin anything else and so we need to give it a file name and location I'm going to call mine Sloter store you can name yours something similar choose the folder pick a location and click okay click the create button the most basic building block for any access database is the table and you notice here that we have something called table one already created and it's asking for us to add some information access assumes that we're just going to start typing in some data I'm going to actually change this by right clicking on the title table one and choosing design view table one needs a name I'm going to call this customer table and so this is basically a spreadsheet that's going to hold all of the names of our customers the first field name of a table usually is something called ID in this case I'm going to call it customer ID and notice it is an a Auto number so each number will be assigned automatically to our customers as we enter them let's click on the next line down since we're collecting data about our customers we're going to collect their name and their address and some things about their business relationship with us so I'll start by naming something called last name notice how you don't use any spaces in here a short text is a good type for a name it's only 255 is long as you can see down here which is enough for most names so let's put in our first name also we'll choose short text let's do street address once more we can use short text what other kind of information do you store in your customer table things like their city and their state so city and state these are all short text let's go to zip code for zip code you might be tempted to choose number but we're going to leave it as text in case they live in a foreign country or else we have leading zeros in our ZIP code let's explore some of the other types though that are here there is a type called time and date let's choose this one let's call it customer s and so customer since is going to be the day when they became our customer another format that we see is a yes no format we could call this free shipping customer or free shipping status and so if we check that box it means they are going to get free shipping from us I'm going to rightclick now on the customer tab up at the Top push save right click again and I'm going to choose data sheet view now you'll see that this looks something like a spreadsheet now I can start entering information in here so the last name I just type in Smith and I type in any type of name let's go with the address 1 2 3 Main Street and the city let's say Phoenix and Arizona and the zip code is 85087 and what is this one customer sense now when we want to enter a date here there is a date picker icon here if you click this you can choose a date when this became a customer and so we have 250 let's scroll a little bit further to the right and we have the option to either check for free shipping or no this is their free shipping status so let's give this person free shipping now you can see why this is called the data table view because we're creating a table of data now I finished typing in about 15 names so I have their name and their address their city state ZIP when they became a customer and some of these have chosen to be part of the free shipping club and some I've left alone now you can sort your database here if you click on the word last name you can tell it to sort from A to Z or you can sort it in reverse order so you can sort any of these by their City by their state by their alphabetized or when they were joined to the company and so sorting is one thing that you can do in a table let's save the table so right click on the tab and choose save let's right click and close it if we were to go and double click the table we can open it again we can enter more data if we want we can change data we can delete data for instance if we wanted to delete this person here I could right click on the front of the row and there is an item for delete record it says you won't be able to undo this information so are you sure click yes now if I sort by the ID number you will notice that it skipped it one three four five and so ID numbers are never replaced they are always one bigger than the last so they will never be another ID for person two let's close this and save the changes one other way to enter a data is to create a form I'm going to click on the customer table up to the create menu and click here where it says form this will create a form automatically that includes all of the data that I've entered already let's save this form and we'll call it customer form so I'm going to rename it click okay down at the bottom it shows that I'm viewing the records in sequence from number one through 14 so as I click these arrows the forward and the back arrow I browse before and after through my customers when I reach the end I come to customer 14 and now when I try to create a new one the 15th customer is asking me to enter new data so I can enter data here I have to go to the right click on the tab and choose form view then I'm allowed to create a new customer so once I've entered all the information I click another next record and a new one comes up now if I go and close this form and now I reopen the table by double clicking you will see that I have the new person in the list so in most programs you want to have users enter data in through forms and so that's what forms you're created for you can also modify how your form is designed if you right click and choose layout view it allows you to adjust the width of each column you could also rightclick and choose design view inside design view you can change the format you can change the size of things but you can also adjust how things are formatted so for instance down here in this field called customer since I can come over to the right side here and choose a different format for my words I can choose things like medium date or long dates let's try what medium date looks like and then when I do form view you see the medium date now shows the abbreviation for the month inside here you can also adjust things like the the text alignment so instead of being left aligned you can Center it you can change the font size if you want to have larger letters you can change the colors you can change the font name so all of the different things that you're accustomed to seeing on most word processors you can change in these fields lastly I'm going to close this save the changes and there you have the first lesson on creating customer data in your database