Library||Complete Microsoft Access Project|| Library Books issue Record Database||

hello everyone welcome to another ms success project tutorial in this video i would make another complete microsoft access project for library this project is for library where a library can issue books to the students and teachers both and save all record librarian can add new books add new users and save all required user record with respective name and date in simple words this system uses to maintain the record of library okay so let's start so first of all you should right right click from mouse and select new and select microsoft access database i will tell you from the beginning to end each and every step so just follow my steps this is very interesting so open microsoft access project sorry microsoft access database click on new select new blank deskt desktop database so here you can give or set location of this so i will set desktop ok so you can give also name of this database so i will give name library and click on create okay so now i will create tables so i need three tables so okay let's start so first of all save first table with the name book okay so now again right click on this table and go to design view and here set field name so first of all first field is book name other is author and serial number of book okay so data types should be in short text and save this table okay our first table has been created successfully now again click on create and select another table and save this with the name of user user so go to design view of this table and here give field name user role and save this okay close our two tables has been created successfully now we will take another table and this is our last table so first save this with the name menu okay and again go to design view of this table and here write field name so first table was book and other user so i will use combo box for these these fields so combo box only accept number data type so here i need two to three more fields so here first name and last name and here also book issue date so issue date okay so date for date data type should be in date time and last last name and first name data type is also short text so save this okay our table has been successfully created now i will make query i apply query wizard so first select menu click on create and click on query wizard okay and here selected all fields click on next next and finish okay our query has been successfully created now i will create or make relationships so select main query and go to database tools and select relationship so select all tables and click on add okay this is our main table menu and you can connect book id with book and press enter in user with user ok that's all friend over relationships have been created successfully so close this and our table is ready i applied successfully liquidy and i made relationship and now i will make forms ok so select book first table and click on create go to form and remove this press enter select and press delete sorry or go to design view and take one button go to design and here this is button so take button drag and drop simple and click on record next next and finish okay this form is ready and here you can set name of this form book form okay so close this and now make form for user table okay select user click on create and click on form select this and press delete okay now go to design view of this form and here select button as like before okay select button go to record operation click on next and here select text next and finish save this user form okay now close this and now select menu query and click on create again and again select form this is very very important form because this form have our menu so first of all select book and user and delete this and select this first name last name and issued it and but don't delete this just cut cut it ctrl plus x press and now go to design and select combo box here and click on next okay next and here just select only one field book name okay click on next and here also select book name next next and here select store and book okay now track and here also set name book name okay again select combo box we need three to four combo box click on next and here select this click on next here also select click on next next and store store in book table because this field related to book table here after okay again select combo box click on next next and select serial number again select serial number serial number is a field of book so here you select book and finish this okay and here write serial number and now here press ctrl v you already selected three fields cut it and now here paste it first name last name and issued it okay so okay select issue date and data format format select short date okay now everything is okay id book name author serial number first name last name and issued it sorry one field is required more again control plus x and select one more combo box here for user select user table click on next select user role click on next user role next next click on store and here also select user next and finish this okay here give name user role okay now press ctrl v and here okay everything is good okay now select button go to design and select button drag and drop simple click record operation and add new record select finish okay save this menu form okay this form is ready now select menu query and click on create i need report so select revert wizard and here select id this is very important step focus it select book and select here book name or the serial number okay now go to user table and select user row and now select again main query and here select three fields first name last name and issued it okay click on next next next and here give ascending order click on next and here select lens landscape um here if you want to give name of report so you can give so just simple write report finish okay our report has been successfully created now design this report so design it okay this is good and okay just follow my steps this is very very interesting okay now select these fields and design it go to format and here you can set font size and bold it okay select all fields change a font size of every field and bold all fields bolt and font size should be 12. select this and increase font size bolt in select this is last okay now you can change name of this here you can write library book issue regarding drag it into center and change background color and front color so white font bold and change font family um this is good okay now save this and go to report view okay now it's looking good so this step has been successfully created now click on create and select blank form and here you design interface of this system okay select this and here you can write name of this system library this database library book issue record okay select this and design go to format and select font size 20 i think 22 is good bold it and select font family fun family is this no it's looking bad okay this is good so select front theme color okay it's good but drag and drop in center okay here so now go to design and select button go to form option operations open form and open form for book next text in here you can write add new book next and finish this okay take one more button select form operation open form click on next and this is for user click on text and here you write add new user and here take one more button go to form operation open form and select menu form and here write main menu or rename this okay main menu is good our issue book sorry ishoof book and select one more button go to report open report next next and here saved book record our book issue record okay next and finish this now design these buttons select this and go to format here select background color front color bold it and change font family increase this size okay select this and this should be green hold it and change one family fun family is now this is hdl round 14 okay so select these two buttons and give background and font this is looking not good okay now it's looking good and save this give name library okay go to form view and select add new form and here i need one more more button back back button so select button click confirm operation open form go to next and here select library next and here give name back next and finish this save go to form view and here you can add book so i want to add book name computer other is to serial double zero double one double zero serial number of this book okay back now click on add user in here also add button back button select button and go to form operation open form and select library click on next text in here right back finish this okay save and go to form view and add user so you can add students and teachers t is ch teacher student and teacher are library users you can add more as your requirement so okay book issue and here so go to design view and add back button form operation open form click on next and select library next click on text and here right back next and finish this save okay now select book name i added only one book computer and here automatically write author and serial number so here you can select user role student or teacher so student and first name of student is the sir and consume last name and here you can select date and here is calendar and you can select today date and click on add so back and this record will be saved in here in report book issue record here you can see our record has been successfully saved okay now close this all and again open this database go to library this is our main menu here so here user and our librarian add new book so i added only one book and now i want to add two to three books math and other is james and serial number one one one okay add one more book um physics physics and other is john and serial number is 222 okay save this okay users are student and teacher okay now issue book if librarian issue books then click on this and here select book name and i select math okay and author is this serial number is this and user role student want to borrow this book or teacher okay select teacher and here you can give teacher name so who want to borrow book from library a molly okay here you can select date and click on add record and this record will be saved here you can see our record has been successfully created if your record has not not showing here then you can refresh all so record will display okay now add one more issue book i want to issue one more book physics physics and here user role student and select first name so the first name give ali okay issued it to the date and add record you can see our record has been successfully okay in our display so refresh okay now you can see the card has been successfully saved so you can save this report in your desktop as a in pdf format so or you can print this record so simply press ctrl p and click on ok and here you can set location i select desktop and here i give name and library record okay press click on save and now you can check our record is saved in pdf format you can see library book issue record here is id book name other serial number user role who borrow book from library student or teacher and here you uh student or teacher first name and last name and here issue book issue date so you can see our record has been successfully saved and we can change in pdf format i hope guys you enjoy this tutorial and i don't need anything from you just i need one subscribe and one like for this video take care bye bye we will meet in next tutorial okay goodbye

Channel: Madu Web Tech

Views: 40,502

Rating: 4.9201331 out of 5

Keywords: How to create ms access project, ms access, how to create a library management system in ms access, how to create ms access project, MS ACCESS DATABASE, How to create database project, How to create project in Ms access, Student Result System, Ms Access Project, How to Create MS access database, How to Create Library project in ms access, Library project in MS access, How to create database in ms access, Ms access library project, How to make Library project in ms access

Id: U_NC4pBDWaM

Length: 30min 25sec (1825 seconds)

Published: Wed May 20 2020