{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Home Page","Basic","Searchable","Database with Picture","Dynamic","UserForm","Relational","Client","Student","Library","Excel to Access"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":1},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Home Page","index":0,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Database in Excel"]
[null,"Learn to create different types of database with this free workbook. Read the article and practice yourself."]
[]
[null,"Prepared By","MD Tanvir Rahman"]
[null,"Last Update",{"$f":"TODAY()","v":"2023-12-07"}]
[null,"Reviewed By","Nehad Ulfat"]
[null,"Article Link"]
[]
[null,"Methods"]
[null,"How to Create a Basic Database in Excel"]
[null,"How to Make a Searchable Database in Excel"]
[null,null,"Using Basic Filter Tool"]
[null,null,"Applying FILTER Function"]
[null,null,"Creating Drop-down List"]
[null,"How to Create a Database with Pictures in Excel"]
[null,"How to Create a Database That Updates Automatically in Excel"]
[null,"How to Use User Form to Add Records in the Database"]
[null,"How to Create a Relational Database in Excel"]
[null,"How to Make a Client Database in Excel"]
[null,"How to Create a Student Database in Excel"]
[null,"How to Make a Library Database in Excel"]
[null,"How to Copy or Export Your Database from Excel to Access"]
[]
[]
[null,"Copyright © 2013-2023 ExcelDemy.com | All rights reserved."]

{"sheet":"Basic","index":1,"n_rows":17,"n_cols":22,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"Create Basic Database in Excel",null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Rank","Movie Title","Year","Rating","Director","Genre","Runtime (mins)","Country","Language","Stars","Summary/Description"]
[null," 1    ","The Dark Knight    ",2008,9," Christopher Nolan","Action",152,"USA","English","Christian Bale, Heath Ledger ","A gritty superhero film depicting Batman's battle against the Joker. "]
[null," 2    ","Inception          ",2010,8.8000000000000007," Christopher Nolan","Sci-Fi",148,"USA","English","Leonardo DiCaprio, Joseph Gordon-Levitt ","A mind-bending heist movie set within dreams. "]
[null," 3    ","The Godfather      ",1972,9.1999999999999993," Francis Ford Coppola ","Crime",175,"USA","English","Marlon Brando, Al Pacino ","A powerful crime drama about the Corleone family. "]
[null," 4    ","Pulp Fiction       ",1994,8.9," Quentin Tarantino ","Crime",154,"USA","English","John Travolta, Uma Thurman ","A nonlinear story of intersecting lives in the criminal underworld. "]
[null," 5    ","The Shawshank Redemption ",1994,9.3000000000000007," Frank Darabont  ","Drama",142,"USA","English","Tim Robbins, Morgan Freeman ","A story of hope and friendship in a prison setting. "]
[null," 6    ","Forrest Gump       ",1994,8.8000000000000007," Robert Zemeckis  ","Drama",142,"USA","English","Tom Hanks, Robin Wright ","A man's extraordinary life journey through pivotal moments in history. "]
[null," 7    ","The Matrix         ",1999,8.6999999999999993," The Wachowskis   ","Sci-Fi",136,"USA","English","Keanu Reeves, Laurence Fishburne ","A sci-fi action film exploring simulated reality. "]
[null," 8    ","Fight Club         ",1999,8.8000000000000007," David Fincher    ","Drama",139,"USA","English","Brad Pitt, Edward Norton ","A tale of underground fight clubs and societal critique. "]
[null," 9    ","Interstellar       ",2014,8.6," Christopher Nolan","Sci-Fi",169,"USA","English","Matthew McConaughey, Anne Hathaway ","A space odyssey exploring wormholes and time dilation. "]
[null," 10   ","Gladiator          ",2000,8.5," Ridley Scott     ","Action",155,"USA","English","Russell Crowe, Joaquin Phoenix ","A Roman general seeks revenge in ancient Rome. "]
[null,null,null,null,null,null,null,null,null,"",null,null,"","","","","","","","","",""]
[]
[]
["Home Page"]

{"sheet":"Searchable","index":2,"n_rows":40,"n_cols":16,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[null,"Create Searchable Database in Excel",null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Using Power Query Tool"]
[]
[null,"Rank","Movie Title","Year","Rating","Director","Genre","Runtime (mins)","Country","Language","Stars","Summary/Description"]
[null," 1    ","The Dark Knight    ",2008,9," Christopher Nolan","Action",152,"USA","English","Christian Bale, Heath Ledger ","A gritty superhero film depicting Batman's battle against the Joker. "]
[null," 2    ","Inception          ",2010,8.8000000000000007," Christopher Nolan","Sci-Fi",148,"USA","English","Leonardo DiCaprio, Joseph Gordon-Levitt ","A mind-bending heist movie set within dreams. "]
[null," 3    ","The Godfather      ",1972,9.1999999999999993," Francis Ford Coppola ","Crime",175,"USA","English","Marlon Brando, Al Pacino ","A powerful crime drama about the Corleone family. "]
[null," 4    ","Pulp Fiction       ",1994,8.9," Quentin Tarantino ","Crime",154,"USA","English","John Travolta, Uma Thurman ","A nonlinear story of intersecting lives in the criminal underworld. "]
[null," 5    ","The Shawshank Redemption ",1994,9.3000000000000007," Frank Darabont  ","Drama",142,"USA","English","Tim Robbins, Morgan Freeman ","A story of hope and friendship in a prison setting. "]
[null," 6    ","Forrest Gump       ",1994,8.8000000000000007," Robert Zemeckis  ","Drama",142,"USA","English","Tom Hanks, Robin Wright ","A man's extraordinary life journey through pivotal moments in history. "]
[null," 7    ","The Matrix         ",1999,8.6999999999999993," The Wachowskis   ","Sci-Fi",136,"USA","English","Keanu Reeves, Laurence Fishburne ","A sci-fi action film exploring simulated reality. "]
[null," 8    ","Fight Club         ",1999,8.8000000000000007," David Fincher    ","Drama",139,"USA","English","Brad Pitt, Edward Norton ","A tale of underground fight clubs and societal critique. "]
[null," 9    ","Interstellar       ",2014,8.6," Christopher Nolan","Sci-Fi",169,"USA","English","Matthew McConaughey, Anne Hathaway ","A space odyssey exploring wormholes and time dilation. "]
[null," 10   ","Gladiator          ",2000,8.5," Ridley Scott     ","Action",155,"USA","English","Russell Crowe, Joaquin Phoenix ","A Roman general seeks revenge in ancient Rome. "]
[]
[null,"Using FILTER Function"]
[]
[null,"Rank","Movie Title","Year","Rating","Director","Genre","Runtime (mins)","Country","Language","Stars","Summary/Description"]
[null,{"$f":"_xlfn._xlws.FILTER(B6:L15, G6:G15=\"Drama\")","v":" 5    "},"The Shawshank Redemption ",1994,9.3000000000000007," Frank Darabont  ","Drama",142,"USA","English","Tim Robbins, Morgan Freeman ","A story of hope and friendship in a prison setting. "]
[null," 6    ","Forrest Gump       ",1994,8.8000000000000007," Robert Zemeckis  ","Drama",142,"USA","English","Tom Hanks, Robin Wright ","A man's extraordinary life journey through pivotal moments in history. "]
[null," 8    ","Fight Club         ",1999,8.8000000000000007," David Fincher    ","Drama",139,"USA","English","Brad Pitt, Edward Norton ","A tale of underground fight clubs and societal critique. "]
[]
[]
[]
[]
[null,"Searching with Drop-Down List"]
[]
[null,"Genre","Drama"]
[]
[null,"Rank","Movie Title","Year","Rating","Director","Genre","Runtime (mins)","Country","Language","Stars","Summary/Description"]
[null,{"$f":"_xlfn._xlws.FILTER(B6:L15, G6:G15=C29)","v":" 5    "},"The Shawshank Redemption ",1994,9.3000000000000007," Frank Darabont  ","Drama",142,"USA","English","Tim Robbins, Morgan Freeman ","A story of hope and friendship in a prison setting. "]
[null," 6    ","Forrest Gump       ",1994,8.8000000000000007," Robert Zemeckis  ","Drama",142,"USA","English","Tom Hanks, Robin Wright ","A man's extraordinary life journey through pivotal moments in history. "]
[null," 8    ","Fight Club         ",1999,8.8000000000000007," David Fincher    ","Drama",139,"USA","English","Brad Pitt, Edward Norton ","A tale of underground fight clubs and societal critique. "]
[]
[]
[]
[]
[]
["Home Page"]

{"sheet":"Database with Picture","index":3,"n_rows":17,"n_cols":23,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"Create Database with Picture in Excel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Rank","Movie Title","Cover","Year","Rating","Director","Genre","Runtime (mins)","Country","Language","Stars","Summary/Description"]
[null," 1    ","The Dark Knight    ",{"$error":"#VALUE!"},2008,9," Christopher Nolan","Action",152,"USA","English","Christian Bale, Heath Ledger ","A gritty superhero film depicting Batman's battle against the Joker. "]
[null," 2    ","Inception          ",{"$error":"#VALUE!"},2010,8.8000000000000007," Christopher Nolan","Sci-Fi",148,"USA","English","Leonardo DiCaprio, Joseph Gordon-Levitt ","A mind-bending heist movie set within dreams. "]
[null," 3    ","The Godfather      ",{"$error":"#VALUE!"},1972,9.1999999999999993," Francis Ford Coppola ","Crime",175,"USA","English","Marlon Brando, Al Pacino ","A powerful crime drama about the Corleone family. "]
[null," 4    ","Pulp Fiction       ",{"$error":"#VALUE!"},1994,8.9," Quentin Tarantino ","Crime",154,"USA","English","John Travolta, Uma Thurman ","A nonlinear story of intersecting lives in the criminal underworld. "]
[null," 5    ","The Shawshank Redemption ",{"$error":"#VALUE!"},1994,9.3000000000000007," Frank Darabont  ","Drama",142,"USA","English","Tim Robbins, Morgan Freeman ","A story of hope and friendship in a prison setting. "]
[null," 6    ","Forrest Gump       ",{"$error":"#VALUE!"},1994,8.8000000000000007," Robert Zemeckis  ","Drama",142,"USA","English","Tom Hanks, Robin Wright ","A man's extraordinary life journey through pivotal moments in history. "]
[null," 7    ","The Matrix         ",{"$error":"#VALUE!"},1999,8.6999999999999993," The Wachowskis   ","Sci-Fi",136,"USA","English","Keanu Reeves, Laurence Fishburne ","A sci-fi action film exploring simulated reality. "]
[null," 8    ","Fight Club         ",{"$error":"#VALUE!"},1999,8.8000000000000007," David Fincher    ","Drama",139,"USA","English","Brad Pitt, Edward Norton ","A tale of underground fight clubs and societal critique. "]
[null," 9    ","Interstellar       ",{"$error":"#VALUE!"},2014,8.6," Christopher Nolan","Sci-Fi",169,"USA","English","Matthew McConaughey, Anne Hathaway ","A space odyssey exploring wormholes and time dilation. "]
[null," 10   ","Gladiator          ",{"$error":"#VALUE!"},2000,8.5," Ridley Scott     ","Action",155,"USA","English","Russell Crowe, Joaquin Phoenix ","A Roman general seeks revenge in ancient Rome. "]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"","","","","","","","","",""]
[]
[]
["Home Page"]

{"sheet":"Dynamic","index":4,"n_rows":59,"n_cols":19,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[null,"Create Database That Updates Automatically",null,null,null,null,null,null,null,null,null,null,null,null,"Link>> ","https://en.wikipedia.org/wiki/List_of_states_and_territories_of_the_United_States"]
[]
[null,"Using Power Query Tool",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Flag, name and postal abbreviation[8]","Flag, name and postal abbreviation[8]2","Cities Capital","Cities Largest[12]","Ratification or admission[A]","Population (2020 census)[10]","Total area[11] mi2","Total area[11] km2","Land area[11] mi2","Land area[11] km2","Water area[11] mi2","Water area[11] km2","Number of Reps."]
[null,"Flag, name and\r\npostal abbreviation","Flag, name and\r\npostal abbreviation","Cities","Cities","Ratification or\r\nadmission","Population\r\n(2020 census)","Total area","Total area","Land area","Land area","Water area","Water area","Number\r\nof Reps."]
[null,"Flag, name and\r\npostal abbreviation","Flag, name and\r\npostal abbreviation","Capital","Largest","Ratification or\r\nadmission","Population\r\n(2020 census)","mi","km","mi","km","mi","km","Number\r\nof Reps."]
[null,"Alabama","AL","Montgomery","Huntsville","Dec 14, 1819","5,024,279","52,420","135,767","50,645","131,171","1,775","4,597","7"]
[null,"Alaska","AK","Juneau","Anchorage","Jan 3, 1959","733,391","665,384","1,723,337","570,641","1,477,953","94,743","245,384","1"]
[null,"Arizona","AZ","Phoenix","Phoenix","Feb 14, 1912","7,151,502","113,990","295,234","113,594","294,207","396","1,026","9"]
[null,"Arkansas","AR","Little Rock","Little Rock","Jun 15, 1836","3,011,524","53,179","137,732","52,035","134,771","1,143","2,961","4"]
[null,"California","CA","Sacramento","Los Angeles","Sep 9, 1850","39,538,223","163,695","423,967","155,779","403,466","7,916","20,501","52"]
[null,"Colorado","CO","Denver","Denver","Aug 1, 1876","5,773,714","104,094","269,601","103,642","268,431","452","1,170","8"]
[null,"Connecticut","CT","Hartford","Bridgeport","Jan 9, 1788","3,605,944","5,543","14,357","4,842","12,542","701","1,816","5"]
[null,"Delaware","DE","Dover","Wilmington","Dec 7, 1787","989,948","2,489","6,446","1,949","5,047","540","1,399","1"]
[null,"Florida","FL","Tallahassee","Jacksonville","Mar 3, 1845","21,538,187","65,758","170,312","53,625","138,887","12,133","31,424","28"]
[null,"Georgia","GA","Atlanta","Atlanta","Jan 2, 1788","10,711,908","59,425","153,910","57,513","148,959","1,912","4,951","14"]
[null,"Hawaii","HI","Honolulu","Honolulu","Aug 21, 1959","1,455,271","10,932","28,313","6,423","16,635","4,509","11,678","2"]
[null,"Idaho","ID","Boise","Boise","Jul 3, 1890","1,839,106","83,569","216,443","82,643","214,045","926","2,398","2"]
[null,"Illinois","IL","Springfield","Chicago","Dec 3, 1818","12,812,508","57,914","149,995","55,519","143,793","2,395","6,202","17"]
[null,"Indiana","IN","Indianapolis","Indianapolis","Dec 11, 1816","6,785,528","36,420","94,326","35,826","92,789","593","1,537","9"]
[null,"Iowa","IA","Des Moines","Des Moines","Dec 28, 1846","3,190,369","56,273","145,746","55,857","144,669","416","1,077","4"]
[null,"Kansas","KS","Topeka","Wichita","Jan 29, 1861","2,937,880","82,278","213,100","81,759","211,754","520","1,346","4"]
[null,"Kentucky","KY","Frankfort","Louisville","Jun 1, 1792","4,505,836","40,408","104,656","39,486","102,269","921","2,387","6"]
[null,"Louisiana","LA","Baton Rouge","New Orleans","Apr 30, 1812","4,657,757","52,378","135,659","43,204","111,898","9,174","23,761","6"]
[null,"Maine","ME","Augusta","Portland","Mar 15, 1820","1,362,359","35,380","91,633","30,843","79,883","4,537","11,750","2"]
[null,"Maryland","MD","Annapolis","Baltimore","Apr 28, 1788","6,177,224","12,406","32,131","9,707","25,142","2,699","6,990","8"]
[null,"Massachusetts[B]","MA","Boston","Boston","Feb 6, 1788","7,029,917","10,554","27,336","7,800","20,202","2,754","7,134","9"]
[null,"Michigan","MI","Lansing","Detroit","Jan 26, 1837","10,077,331","96,714","250,487","56,539","146,435","40,175","104,052","13"]
[null,"Minnesota","MN","Saint Paul","Minneapolis","May 11, 1858","5,706,494","86,936","225,163","79,627","206,232","7,309","18,930","8"]
[null,"Mississippi","MS","Jackson","Jackson","Dec 10, 1817","2,961,279","48,432","125,438","46,923","121,531","1,508","3,907","4"]
[null,"Missouri","MO","Jefferson City","Kansas City","Aug 10, 1821","6,154,913","69,707","180,540","68,742","178,040","965","2,501","8"]
[null,"Montana","MT","Helena","Billings","Nov 8, 1889","1,084,225","147,040","380,831","145,546","376,962","1,494","3,869","2"]
[null,"Nebraska","NE","Lincoln","Omaha","Mar 1, 1867","1,961,504","77,348","200,330","76,824","198,974","524","1,356","3"]
[null,"Nevada","NV","Carson City","Las Vegas","Oct 31, 1864","3,104,614","110,572","286,380","109,781","284,332","791","2,048","4"]
[null,"New Hampshire","NH","Concord","Manchester","Jun 21, 1788","1,377,529","9,349","24,214","8,953","23,187","397","1,027","2"]
[null,"New Jersey","NJ","Trenton","Newark","Dec 18, 1787","9,288,994","8,723","22,591","7,354","19,047","1,368","3,544","12"]
[null,"New Mexico","NM","Santa Fe","Albuquerque","Jan 6, 1912","2,117,522","121,590","314,917","121,298","314,161","292","757","3"]
[null,"New York","NY","Albany","New York City","Jul 26, 1788","20,201,249","54,555","141,297","47,126","122,057","7,429","19,240","26"]
[null,"North Carolina","NC","Raleigh","Charlotte","Nov 21, 1789","10,439,388","53,819","139,391","48,618","125,920","5,201","13,471","14"]
[null,"North Dakota","ND","Bismarck","Fargo","Nov 2, 1889","779,094","70,698","183,108","69,001","178,711","1,698","4,397","1"]
[null,"Ohio","OH","Columbus","Columbus","Mar 1, 1803","11,799,448","44,826","116,098","40,861","105,829","3,965","10,269","15"]
[null,"Oklahoma","OK","Oklahoma City","Oklahoma City","Nov 16, 1907","3,959,353","69,899","181,037","68,595","177,660","1,304","3,377","5"]
[null,"Oregon","OR","Salem","Portland","Feb 14, 1859","4,237,256","98,379","254,799","95,988","248,608","2,391","6,191","6"]
[null,"Pennsylvania","PA","Harrisburg","Philadelphia","Dec 12, 1787","13,002,700","46,054","119,280","44,743","115,883","1,312","3,397","17"]
[null,"Rhode Island","RI","Providence","Providence","May 29, 1790","1,097,379","1,545","4,001","1,034","2,678","511","1,324","2"]
[null,"South Carolina","SC","Columbia","Charleston","May 23, 1788","5,118,425","32,020","82,933","30,061","77,857","1,960","5,076","7"]
[null,"South Dakota","SD","Pierre","Sioux Falls","Nov 2, 1889","886,667","77,116","199,729","75,811","196,350","1,305","3,379","1"]
[null,"Tennessee","TN","Nashville","Nashville","Jun 1, 1796","6,910,840","42,144","109,153","41,235","106,798","909","2,355","9"]
[null,"Texas","TX","Austin","Houston","Dec 29, 1845","29,145,505","268,596","695,662","261,232","676,587","7,365","19,075","38"]
[null,"Utah","UT","Salt Lake City","Salt Lake City","Jan 4, 1896","3,271,616","84,897","219,882","82,170","212,818","2,727","7,064","4"]
[null,"Vermont","VT","Montpelier","Burlington","Mar 4, 1791","643,077","9,616","24,906","9,217","23,871","400","1,035","1"]
[null,"Virginia","VA","Richmond","Virginia Beach","Jun 25, 1788","8,631,393","42,775","110,787","39,490","102,279","3,285","8,508","11"]
[null,"Washington","WA","Olympia","Seattle","Nov 11, 1889","7,705,281","71,298","184,661","66,456","172,119","4,842","12,542","10"]
[null,"West Virginia","WV","Charleston","Charleston","Jun 20, 1863","1,793,716","24,230","62,756","24,038","62,259","192","497","2"]
[null,"Wisconsin","WI","Madison","Milwaukee","May 29, 1848","5,893,718","65,496","169,635","54,158","140,268","11,339","29,367","8"]
[null,"Wyoming","WY","Cheyenne","Cheyenne","Jul 10, 1890","576,851","97,813","253,335","97,093","251,470","720","1,864","1"]
[]
["Home Page"]

{"sheet":"UserForm","index":5,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"Use User Form to Add Records in Database"]
[]
[null,"Making UserForm with VBA Macro",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Client Name","Company","City","State","Contact No","Email"]
[null,"Mino","Softeko","Houston","Texas","911-061245","Mino@softeko"]
[null,"Monty","Delta","Atalanta","Georgia","922-521365","Monty@Delta.com"]
[null,"Zahid","Softeko","Mohammadput","Dhaka",1567446546,"zahid@softeko.com"]
[null,"Jonayed","Softeko","Mirpur","Dhaka",155555555,"jonayed@softeko.com"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Home Page"]

{"sheet":"Relational","index":6,"n_rows":25,"n_cols":15,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,"Create a Relational Database in Excel"]
[]
[null,"Using Excel Table and Pivot Table Tools",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Sales Person","Product",null,"Sales Person","Net Sales",null,null,null,null,"Sales Person","Product",null,"Sales Person","Net Sales"]
[null,"Nathan","AC",null,"Nathan",42000,null,null,null,null,"Nathan","AC",null,"Nathan",42000]
[null,"Simon","TV",null,"Simon",91100,null,null,null,null,"Simon","TV",null,"Simon",91100]
[null,"Lily","Fridge",null,"Lily",25500,null,null,null,null,"Lily","Fridge",null,"Lily",25500]
[null,"Cameron","Laptop",null,"Cameron",31000,null,null,null,null,"Cameron","Laptop",null,"Cameron",31000]
[null,"Kimberly","Smart Phone",null,"Kimberly",88100,null,null,null,null,"Kimberly","Smart Phone",null,"Kimberly",88100]
[]
[null,"Row Labels","Sum of Net Sales"]
[null,"AC",42000]
[null,"Fridge",25500]
[null,"Laptop",31000]
[null,"Smart Phone",88100]
[null,"TV",91100]
[null,"Grand Total",277700]
[]
[]
[]
[]
[]
[]
["Home Page"]

{"sheet":"Client","index":7,"n_rows":20,"n_cols":16,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,"Make Client Database in Excel"]
[]
[null,"Client ID","Client Name","Company","Sex","Age","Marital Status","City","State","Contact No","Email",null,null,null,null,"Practice Section"]
[null,"C-100001","Amanda Wilson","ABC Traders","Female",32,"Married","Tallahassee","Florida","911-3254564",{"$f":"LOWER(SUBSTITUTE(C4, \" \", \"\")) & \"@example.com\"","v":"amandawilson@example.com"}]
[null,"C-100002","John Smith","Believe Motors","Male",34,"Unmarried","Atlanta","Georgia","911-5653254",{"$f":"LOWER(SUBSTITUTE(C5, \" \", \"\")) & \"@example.com\"","v":"johnsmith@example.com"}]
[null,"C-100003","Jimmy Ted","OS Corporation","Male",36,"Unmarried","Springfield","Illinois","911-3256654","jimmyted@example.com"]
[null,"C-100004","Mick Ferguson","Believe Motors","Male",24,"Unmarried","Louisville","Kentucky","911-3256745","mickferguson@example.com"]
[null,"C-100005","Diana Brown","OS Corporation","Female",32,"Married","Boston","Massachusetts","911-5683254","dianabrown@example.com"]
[null,"C-100006","Rahul Sachin","HRT Academy","Male",28,"Married","Jefferson City","Missouri","911-4532569","rahulsachin@example.com"]
[null,"C-100007","Gigi Witkins","ABC Traders","Female",37,"Married","Atlanta","Georgia","911-7032545","gigiwitkins@example.com"]
[null,"C-100008","Henry Miller","Believe Motors","Male",32,"Unmarried","Springfield","Illinois","911-5457132","henrymiller@example.com"]
[null,"C-100009","Westin Mino","Softeko","Male",28,"Unmarried","Houston","Texas","911-0612451","westinmino@example.com"]
[null,"C-100010","Malvika Ruthela","OS Corporation","Female",24,"Married","Louisville","Kentucky","911-8356254","malvikaruthela@example.com"]
[]
[]
[]
[]
[]
[]
["Home Page"]

{"sheet":"Student","index":8,"n_rows":19,"n_cols":15,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"Create Student Database in Excel"]
[]
[null," Student ID "," First Name "," Last Name  "," Gender "," Date of Birth "," Email                "," Phone Number "," Address               "," City       ",null,null,null,null,"Practice Section"]
[null,"S-2023-10-002"," John       "," Doe        "," Male   "," 1998-05-15    "," john@example.com     "," 123-456-7890 "," 123 Main St           ","Miami"]
[null,"S-2023-10-001"," Jane       "," Smith      "," Female "," 1999-09-20    "," jane@example.com     "," 987-654-3210 "," 456 Elm St            ","Orlando"]
[null,"S-2023-10-003"," Michael    "," Johnson    "," Male   "," 2000-03-10    "," michael@example.com  "," 567-890-1234 "," 789 Oak St            ","Tampa"]
[null,"S-2023-10-004"," Emily      "," Williams   "," Female "," 1998-12-28    "," emily@example.com    "," 234-567-8901 "," 321 Maple Ave         ","Jacksonville"]
[null,"S-2023-10-005"," David      "," Brown      "," Male   "," 1999-07-03    "," david@example.com    "," 876-543-2109 "," 654 Pine St           ","Tallahassee"]
[null,"S-2023-10-006"," Sarah      "," Garcia     "," Female "," 2001-02-18    "," sarah@example.com    "," 345-678-9012 "," 987 Cedar St          ","Key West"]
[null,"S-2023-10-007"," Daniel     "," Martinez   "," Male   "," 1999-11-09    "," daniel@example.com   "," 789-012-3456 "," 111 Walnut St         ","Fort Lauderdale"]
[null,"S-2023-10-008"," Olivia     "," Rodriguez  "," Female "," 2000-08-25    "," olivia@example.com   "," 456-789-0123 "," 222 Birch St          ","St. Petersburg"]
[null,"S-2023-10-009"," Ethan      "," Wilson     "," Male   "," 2001-05-30    "," ethan@example.com    "," 901-234-5678 "," 333 Oakwood St        ","Tampa"]
[null,"S-2023-10-010"," Ava        "," Anderson   "," Female "," 1998-04-12    "," ava@example.com      "," 678-901-2345 "," 444 Spruce St         ","Jacksonville"]
[null,"S-2023-10-011"," Mia        "," Thomas     "," Female "," 2000-10-05    "," mia@example.com      "," 210-987-6543 "," 555 Pinecrest Ave     ","Tallahassee"]
[]
[]
[]
[]
["Home Page"]

{"sheet":"Library","index":9,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"Make a Library Database in Excel"]
[]
[null,"Book ID","Book Title","Author","Member ID","Member Name","Date Borrowed","Date Due","Address","Phone",null,null,null,null,"Practice Section"]
[null,"B-02351","The Alchemist","Paulo Coelho","M2021-00152","Oliver Queen","2023-11-29","2023-12-14","1230,Old Street, Boston","911-3256654"]
[null,"B-02552","The Art of War","Sun Tzu","M2023-00453","Lio Malkova","2023-11-29","2023-12-14","80/A, Down town, Boston","911-3256745"]
[null,"B-05323","Fire and Blood","George R. R. Martin","M2020-00554","Monty Spencer","2023-12-01","2023-12-16","11/1, Lake Road, Boston","911-5683254"]
[null,"B-04235","Twilight","Stephenie Meyer","M2022-01555","Julian Roberto","2023-12-02","2023-12-17","12A, Silk Road, Boston","911-4532569"]
[null,"B-02535","Harry Potter","J. K. Rowling","M2021-00111","Matt Payne","2023-12-02","2023-12-17","85/C, Down Town, Boston","911-7032545"]
[null,"B-07125","To Kill a Mockingbird","Harper Lee","M2022-01456","Emily Johnson","2023-12-04","2023-12-19","35, Maple Street, Boston","911-7536982"]
[null,"B-09457","The Great Gatsby","F. Scott Fitzgerald","M2023-00654","Grace Parker","2023-12-05","2023-12-20","25, Park Place, Boston","911-3698521"]
[null,"B-10358","Pride and Prejudice","Jane Austen","M2022-01122","Noah Garcia","2023-12-06","2023-12-21","50, Chestnut Street, Boston","911-8523697"]
[null,"B-11259","The Lord of the Rings","J.R.R. Tolkien","M2021-00456","Lily Bennett","2023-12-06","2023-12-21","8/B, Main Road, Boston","911-9632587"]
[null,"B-12260","The Chronicles of Narnia","C.S. Lewis","M2023-00876","Ethan Ramirez","2023-12-07","2023-12-22","75, Willow Avenue, Boston","911-7458963"]
[null,"B-13461","Gone with the Wind","Margaret Mitchell","M2022-01987","Ava Turner","2023-12-08","2023-12-23","90, Cedar Street, Boston","911-6325874"]
[null,"B-14262","The Hunger Games","Suzanne Collins","M2021-00789","Mason Scott","2023-12-08","2023-12-23","30, Pine Lane, Boston","911-9874521"]
[null,"B-15463","The Da Vinci Code","Dan Brown","M2023-01111","Chloe Hughes","2023-12-09","2023-12-24","65, Birch Road, Boston","911-8745963"]
[]
["Home Page"]

{"sheet":"Excel to Access","index":10,"n_rows":19,"n_cols":15,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"Copy or Export Your Database from Excel to Access"]
[]
[null," Student ID "," First Name "," Last Name  "," Gender "," Date of Birth "," Email                "," Phone Number "," Address               "," City       ",null,null,null,null,"Practice Section"]
[null,"S-2023-10-002"," John       "," Doe        "," Male   "," 1998-05-15    "," john@example.com     "," 123-456-7890 "," 123, Main St           ","Miami"]
[null,"S-2023-10-001"," Jane       "," Smith      "," Female "," 1999-09-20    "," jane@example.com     "," 987-654-3210 "," 456, Elm St            ","Orlando"]
[null,"S-2023-10-003"," Michael    "," Johnson    "," Male   "," 2000-03-10    "," michael@example.com  "," 567-890-1234 "," 789, Oak St            ","Tampa"]
[null,"S-2023-10-004"," Emily      "," Williams   "," Female "," 1998-12-28    "," emily@example.com    "," 234-567-8901 "," 321, Maple Ave         ","Jacksonville"]
[null,"S-2023-10-005"," David      "," Brown      "," Male   "," 1999-07-03    "," david@example.com    "," 876-543-2109 "," 654, Pine St           ","Tallahassee"]
[null,"S-2023-10-006"," Sarah      "," Garcia     "," Female "," 2001-02-18    "," sarah@example.com    "," 345-678-9012 "," 987, Cedar Park     ","Key West"]
[null,"S-2023-10-007"," Daniel     "," Martinez   "," Male   "," 1999-11-09    "," daniel@example.com   "," 789-012-3456 "," 111, Walnut St         ","Fort Lauderdale"]
[null,"S-2023-10-008"," Olivia     "," Rodriguez  "," Female "," 2000-08-25    "," olivia@example.com   "," 456-789-0123 "," 222, Birch St          ","St. Petersburg"]
[null,"S-2023-10-009"," Ethan      "," Wilson     "," Male   "," 2001-05-30    "," ethan@example.com    "," 901-234-5678 "," 333, Oakwood St        ","Tampa"]
[null,"S-2023-10-010"," Ava        "," Anderson   "," Female "," 1998-04-12    "," ava@example.com      "," 678-901-2345 "," 444, Spruce St         ","Jacksonville"]
[null,"S-2023-10-011"," Mia        "," Thomas     "," Female "," 2000-10-05    "," mia@example.com      "," 210-987-6543 "," 555, Pinecrest Ave     ","Tallahassee"]
[]
[]
[]
[]
["Home Page"]