Collaborate on Ms Access Invoice Template Free Download for Logistics with Ease Using airSlate SignNow

Ms access invoice template free download for Logistics

this video is going to show you how to use microsoft access for the first part of this find a job project should create an access database or table within a database with information the second part would be to create a live application in microsoft word it'll be a form letter and you'll be pulling information in from your database to very easily create 25 nearly identical letters but with some personalizing included but here i'm just going to talk about access so the first step is to open microsoft access click on blank desktop database to create a new database give it a name i'll just call it find find a job hit create it'll open up with a blank table see there's nothing in the table and there are no forms in the table no fields in the table just a blank table so what you want this would be what's called the datasheet view which will show you all the information within a table so the first thing you want to do is click on this little button here to take you to the design view give your table a name i'll just call it contact info this first field is just an id number automatically fills in as you add more information to your table you'll update so the first company is walmart they'll be named one you hit enter start typing target that would be number two so you can just leave that as is the rest of the fields you want to fill in using these 13 fields i want you to have included in the table just to mention this table is one of many you could have within an access database you could also have multiple forms multiple reports and multiple queries where queries would be used to connect more than one table maybe pull our article description from one table and a price from another table for example we should create one table for this project in one report so start with company name data type short text everything else will be the default contact title this would be mr mrs mez doctor etc and this just makes it easier in the form letter so you can have a letter says dear mr smith and then dear mrs jones without having to do much typing at all contact first name most of these are going to be just the default contact last name contact job title contact address state contact zip zip code and here there's one case we will not use the default the key to short text but if you come down here to the bottom part of the screen and click on this input mask and this blank spot to the right then over on the ellipsis it will actually say a table say yes pick the one says zip code say next take away these last four digits because you probably will not find the nine digit zip code and you probably only find a five digit zip code so you can just delete these nines delete the dashes if you want to try it see what see why you don't want to use this type in a zip code say six five seven one four try typing more than five numbers it will not let you try to type in letters which is what i'm doing now it just gives this error sound all right so click next this one you can record with the symbols or without doesn't matter because there are no symbols in the zip code of course click finish then go into contact phone number here use input mask again and click in the blank fill to the right of the input mask clip on the elix ellipsis save the table click phone number say next next this time you want to use a story with the symbols in the mask so then before that pull this into your microsoft word letter you won't have to worry about typing in parentheses or dashes you'll have a formatted phone number already and all you're gonna have to type in to this database is numbers so then click finish there contact email the things i had to list would be position applying for and source i'd recommend you spell things correctly even though i did not hear source and what the source is going to be here it would be something that would finish the sentence i heard about this job blank so then in source if you heard about something from an email from dr kent in this field you type in from dr kent at missouri state university if you read about the newspaper you'd say this field would say in the thursday edition of the springfield news leader if you heard about the job on a website this is phil would read from your corporate website or on your corporate website etc so you don't want to print this just put it in there and you can even in the sentence with a period put the period in there then when you type your formula you'll make sure you leave the uh punctuation off of that so these are the 13 fields one two three four five six seven eight nine ten eleven twelve thirteen is this id you're done with that go back here and click on view to go back to the datasheet view save the table here you can enter information so let me just show you how you do that so it's walmart contact title mr jim smith uh ceo of course this is not correct information i'm just typing things in here address 4560 south walton i don't know what south walton boulevard is correct address other than that i am not sure bentonville arkansas 727 i'm not sure the zip code in bentonville just make one up here phone number 479-352-4876 that's not the correct phone number either you would want to make this information correct so you can use this database to actually apply for jobs email john smith at walmart.com applying for buyer source so you just would finish the sentence i heard about this job on your corporate website for example then hit enter it takes you next field you start entering your new information let's say jb hunt et cetera et cetera keep going through this entering information you can start your database start your table come back to it later fill in more information so every time you get a job contact throughout the semester put it in your database if you get an email from dr kent about a job if it's something you're interested in put that contact information in this table in your database and then you're ready to start applying for jobs you can use your form letter to very easily have a bunch of letters ready to be sent out you could also use this in a form letter to put address on envelope for example so you could print out your envelope labels as well so go contact so that's that's how you create the table once you have the table created you don't have to have it filled in because once it create it is created you could create a report you'll have to create a report every time you open a report if it references the particular table it will update any information so if you create the report we have two um companies filled into your your table you'll only have two companies in the report if you update your table to have all 25 reopen that report it will then have the information from 25 entries in your in your table so you can create the table or the report as soon as you create the table so go to create just use report wizard is the easiest way if you have experience with access you probably won't be watching the video but you could create your own report but the easiest thing click on report wizard we're going to use the table contact info it's the only table we have we want to make sure we include all of these fields so just click on this button here click next we don't need any grouping we don't need any sorting the only thing i want you to change for sure is change this layout from tabular to columnar if you send me the report in tabular it would be very hard to read it won't fit on one page or it will cut off all your entries and you'll lose quite a bit of points so click on columner just takes a second to do orientation leave it as portrait that's fine click next for the title of the report just go ahead and put your name in there so it look look like a professional report click finish now you have a report as your name at the top has a con first company contact information there if i had more than one field it would have that other information list as well so let's show you again let me close this out close the report go good contact info let's fill this out mr john's stevens use correct punctuation capitalization in these fields to make it easier to do the form letter but we can just type any anything in here arkansas lowell arkansas and jb hunt so just type anything in there and i get the point of this i'm just going to show you how you can update to report updates automatically so we added a new field or a new entry into our table close that table out open our report and i have two entries right i have the one from walmart followed by the one from jb hunt if i were to close this out go back in my table and add four or five more entries reopen the table they would all show up here so it's very easy to do so create a table make sure you create a report make sure it's in columnar layout looks very similar to this with different information in it and turn that in now sometimes you might find a job on a corporate website and you don't see an actual address and a name of someone to send that to in that case leave contact title blank it just won't show up on your form letter it won't even show up as spaces contact last name just put in hiring manager as a contact last name then when you type your letter instead of saying dear mr smith it would say dear blank hiring manager and that would still work just fine for you for the address if you don't find address for a person because you're applying online just use the corporate address or their hr address if you can find that or just a corporate address phone number contact email use their if you don't find it use human resources find the human resources address and phone number and that would be fine so let me know if you have any questions when you create a new database