{"id":"https://openalex.org/W2624616977","doi":null,"title":"Access 2010: The Missing Manual","display_name":"Access 2010: The Missing Manual","alternate_titles":[],"publication_year":2010,"publication_date":"2010-06-18","ids":{"openalex":"https://openalex.org/W2624616977","mag":"2624616977"},"language":"en","primary_location":{"id":"pmh:oai:cds.cern.ch:2735490","doi":null,"is_oa":false,"landing_page_url":"http://cds.cern.ch/record/2735490","pdf_url":null,"source":{"id":"https://openalex.org/S4306402195","display_name":"CERN Document Server (European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":null},"parent_works":[],"lineage":["https://openalex.org/W2624616977"],"child_works_count":0,"type":"article","is_traditional":true,"indexed_in":[],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5110028452","display_name":"Matthew A. MacDonald","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Matthew MacDonald","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5110028452"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":3,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":86,"max":92},"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13681","display_name":"Engineering and Information Technology","score":0.913100004196167,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T13681","display_name":"Engineering and Information Technology","score":0.913100004196167,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.052299998700618744,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11734","display_name":"Decision Support System Applications","score":0.01899999938905239,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/microsoft-access-2010","display_name":"Microsoft Access 2010","score":0.9779999852180481},{"id":"https://openalex.org/keywords/database-design","display_name":"database design","score":0.9869999885559082},{"id":"https://openalex.org/keywords/database-objects","display_name":"database objects","score":0.7799999713897705},{"id":"https://openalex.org/keywords/database-relationships","display_name":"database relationships","score":0.6420000195503235},{"id":"https://openalex.org/keywords/queries","display_name":"queries","score":0.6309999823570251},{"id":"https://openalex.org/keywords/form","display_name":"form","score":0.8069999814033508},{"id":"https://openalex.org/keywords/reports","display_name":"reports","score":0.847000002861023},{"id":"https://openalex.org/keywords/macros","display_name":"macros","score":0.6629999876022339},{"id":"https://openalex.org/keywords/modules","display_name":"modules","score":0.6340000033378601},{"id":"https://openalex.org/keywords/data-entry","display_name":"data entry","score":0.3799999952316284},{"id":"https://openalex.org/keywords/data-sharing","display_name":"data sharing","score":0.3930000066757202},{"id":"https://openalex.org/keywords/sharepoint","display_name":"SharePoint","score":0.7459999918937683},{"id":"https://openalex.org/keywords/online-databases","display_name":"online databases","score":0.6880000233650208},{"id":"https://openalex.org/keywords/sql-server","display_name":"SQL Server","score":0.503000020980835},{"id":"https://openalex.org/keywords/data-connections","display_name":"data connections","score":0.5669999718666077},{"id":"https://openalex.org/keywords/database-programming","display_name":"database programming","score":0.46700000762939453},{"id":"https://openalex.org/keywords/data-security","display_name":"data security","score":0.35100001096725464},{"id":"https://openalex.org/keywords/data-backup-and-recovery","display_name":"data backup and recovery","score":0.5},{"id":"https://openalex.org/keywords/data-import-and-export","display_name":"data import and export","score":0.4189999997615814},{"id":"https://openalex.org/keywords/data-management","display_name":"data management","score":0.3240000009536743}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7244912385940552},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.6210340261459351},{"id":"https://openalex.org/C88006597","wikidata":"https://www.wikidata.org/wiki/Q690117","display_name":"Disk formatting","level":2,"score":0.5907593965530396},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.504214882850647},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.48516780138015747},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.44815102219581604},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.4404180347919464},{"id":"https://openalex.org/C70236469","wikidata":"https://www.wikidata.org/wiki/Q1078262","display_name":"Database administrator","level":2,"score":0.42166393995285034},{"id":"https://openalex.org/C47487241","wikidata":"https://www.wikidata.org/wiki/Q5227230","display_name":"Data access","level":2,"score":0.4168210029602051},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"pmh:oai:cds.cern.ch:2735490","doi":null,"is_oa":false,"landing_page_url":"http://cds.cern.ch/record/2735490","pdf_url":null,"source":{"id":"https://openalex.org/S4306402195","display_name":"CERN Document Server (European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":null},{"id":"mag:2624616977","doi":null,"is_oa":false,"landing_page_url":"http://www.gbv.de/dms/tib-ub-hannover/622544799.pdf","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W6995533978","https://openalex.org/W114216649","https://openalex.org/W58319413","https://openalex.org/W2251555975","https://openalex.org/W80194520","https://openalex.org/W2556862879","https://openalex.org/W620222463","https://openalex.org/W1540617058","https://openalex.org/W187890843","https://openalex.org/W6989006268"],"abstract_inverted_index":{"Go":[0],"from":[1,39,819],"Access":[2,116,121,149,253,333,364,374,622,689,706,734,770,795,838],"novice":[3],"to":[4,47,59,73,95,127,147,202,281,296,322,393,401,408,443,462,557,573,592,628,648,661,681,684,721,743,776,783,792,797,801,824,847,858],"true":[5],"master":[6],"with":[7,55,103,111,138,173,214,353,464,543,596,602],"the":[8,22,67,114,153,186,199,216,269,274,300,415,421,478,483,489,494,497,515,519,523,540,563,567,603,608,638,650,685,733,874],"professional":[9],"database":[10,27,54,118,158,187,208,254,340,375,475,486,516,550,564,568,588,609,862,866],"design":[11,159,629,710],"tips":[12],"and":[13,43,50,64,86,113,125,142,155,195,286,298,305,307,379,418,470,499,505,527,538,566,605,636,656,724,781],"crystal-clear":[14],"explanations":[15],"in":[16,35,193,302,428,529,705,837],"this":[17,25,670,773],"book.":[18],"You'll":[19],"learn":[20,627,647],"all":[21,331,510,785],"secrets":[23],"of":[24,90,157,164,219,228,249,276,355,357,389,396,404,491,549,634,653,688,728],"powerful":[26],"program":[28],"so":[29],"you":[30,81,183,230,233,237,271,407,508,555,559,624,645,680,708,739,756,790,799,814,854,878],"can":[31,160,181,255,312,599,709,740,815,855],"use":[32,741,777,856],"your":[33,70,93,107,223,240,303,434,711,758,881],"data":[34,75,94,133,220,301],"creative":[36],"ways":[37,461],"--":[38],"creating":[40,552],"product":[41,424,450],"catalogs":[42],"publishing":[44],"information":[45,58,91,224,270],"online":[46,110],"producing":[48],"invoices":[49],"reports.":[51],"Build":[52,69,135],"a":[53,77,162,165,277,339,343,366,387,394,402,449,452,465,468,472,584,630,676,716,726,803,821,826,860,864],"ease.":[56],"Store":[57],"track":[60,201],"numbers,":[61],"products,":[62,405],"documents,":[63],"more":[65,872],"Customize":[66],"interface.":[68],"own":[71,712],"forms":[72,290,506,528,604],"make":[74,293,438,658,751],"entry":[76],"snap":[78],"Find":[79],"what":[80,547,554],"need":[82,272,591,617,720,800],"fast.":[83],"Search,":[84],"sort,":[85],"summarize":[87],"huge":[88],"amounts":[89],"Put":[92],"use.":[96],"Turn":[97],"raw":[98],"info":[99],"into":[100,120,675,732,863],"printed":[101],"reports":[102,279,504,606],"attractive":[104],"formatting":[105],"Share":[106],"data.":[108,544],"Collaborate":[109],"SharePoint":[112],"brand-new":[115],"web":[117],"Dive":[119],"programming.":[122],"Get":[123],"tricks":[124,154],"techniques":[126,156],"automate":[128],"common":[129,663],"tasks":[130],"Create":[131],"rich":[132],"connections.":[134],"dynamic":[136],"links":[137],"SQL":[139],"Server,":[140],"SharePoint,":[141],"other":[143,258,651],"systems":[144],"Five":[145],"Touchstones":[146],"Understanding":[148],"Lets":[150],"face":[151],"it--learning":[152],"be":[161,197,561,593],"bit":[163],"slog.":[166],"But":[167,243,570,788],"if":[168,789,844],"youre":[169,551,845],"just":[170,246,314,342,600,719,754],"starting":[171],"out":[172,268,337,493],"Access,":[174],"here":[175],"are":[176,212,245,261,459,577,693,835],"five":[177],"key":[178,259],"insights":[179],"that":[180,221,251,266,292,311,454,575,607,640,678,696,704,746,834,870],"help":[182],"understand":[184],"how":[185],"world":[188],"works.":[189],"Keep":[190],"these":[191,382,576],"points":[192],"mind,":[194],"youll":[196,616,673],"on":[198,546,880],"inside":[200],"mastering":[203],"Access.":[204,597],"1.":[205],"Databases":[206],"hold":[207,329,350],"objects.":[209],"Most":[210],"people":[211,767],"familiar":[213],"tables,":[215,378,495,524,778],"grid-like":[217],"grouping":[218],"stores":[222],"(for":[225],"example,":[226,386,436,738,868],"lists":[227,352],"items":[229],"own,":[231],"friends":[232],"have,":[234],"or":[235,451,614,753],"products":[236],"sell":[238],"through":[239,828],"small":[241],"business).":[242],"tables":[244,383,541,635],"one":[247],"type":[248,548],"object":[250],"an":[252,325,446,621,829],"hold.":[256],"The":[257,474,485,532,700,840],"ingredients":[260],"queries":[262],"(customized":[263],"search":[264],"routines":[265],"pull":[267],"at":[273,320,772,805],"drop":[275],"hat),":[278],"(similar":[280],"queries,":[282,498,525],"but":[283],"nicely":[284],"formatted":[285],"ready":[287],"for":[288,425,441,448],"printing),":[289],"(windows":[291],"it":[294,330,361,439,659],"easy":[295],"review":[297],"edit":[299],"tables),":[304],"macros":[306,713,742,782],"modules":[308],"(miniature":[309],"programs":[310,695,877],"do":[313,784,816],"about":[315],"anythingfrom":[316],"updating":[317],"10,000":[318],"records":[319],"once":[321],"firing":[323],"off":[324],"email).":[326],"2.":[327],"Relationships":[328,431],"together.":[332,384,643],"newbies":[334],"sometimes":[335],"start":[336,749],"thinking":[338],"is":[341,420,477,518,703],"glorified":[344],"spreadsheet.":[345],"After":[346],"all,":[347],"cant":[348,369],"Excel":[349,368],"long":[351],"hundreds":[354],"thousands":[356],"rows?":[358],"(And":[359],"yes,":[360],"can.)":[362],"However,":[363],"has":[365,488,796],"feature":[367],"duplicate:":[370],"relationships.":[371],"A":[372],"typical":[373],"holds":[376],"several":[377],"relationships":[380,639],"link":[381,392,400,641],"For":[385,737],"table":[388,395,403],"customers":[390,413,426],"might":[391],"orders,":[397],"which":[398],"would":[399],"allowing":[406],"answer":[409],"questions":[410],"like":[411,873],"What":[412,419],"spent":[414],"most":[416,422],"money?":[417],"popular":[423],"living":[427],"New":[429],"York?":[430],"also":[432],"safeguard":[433],"data--for":[435],"they":[437],"impossible":[440],"someone":[442],"accidentally":[444],"place":[445],"order":[447,830],"customer":[453,827],"doesnt":[455],"exist.":[456],"3.":[457],"There":[458],"two":[460],"work":[463,601],"database:":[466],"as":[467,471],"designer":[469,476,487,565,610],"user.":[473,569],"person":[479,520],"who":[480,521],"sets":[481],"up":[482,542,683,849],"database.":[484,759],"responsibility":[490],"laying":[492],"building":[496],"knocking":[500],"together":[501],"some":[502,666,850],"nice":[503],"(assuming":[507],"want":[509,556,791],"those":[511],"features).":[512],"By":[513],"comparison,":[514],"user":[517,533],"uses":[522],"reports,":[526,780],"day-to-day":[530],"life.":[531],"reviews":[534],"records,":[535],"makes":[536],"changes,":[537],"fills":[539],"Depending":[545],"(and":[553],"accomplish),":[558],"may":[560],"both":[562],"its":[571,806],"important":[572],"realize":[574],"distinct":[578],"tasks.":[579,664,699],"In":[580],"fact,":[581],"when":[582],"using":[583],"properly":[585],"designed":[586],"database,":[587],"users":[589],"dont":[590],"particularly":[594],"skilled":[595],"They":[598],"created.":[611],"4.":[612],"Sooner":[613],"later,":[615],"macros.":[618,691],"To":[619],"become":[620],"expert,":[623],"must":[625,646],"first":[626],"logical,":[631],"consistent":[632],"set":[633],"add":[637],"them":[642],"Next,":[644],"build":[649,744],"types":[652],"objects--queries,":[654],"forms,":[655,779],"reports--that":[657],"easier":[660],"perform":[662,697],"At":[665],"point,":[667,774],"while":[668],"tackling":[669],"second":[671],"stage,":[672],"run":[674,879],"challenge":[677],"forces":[679],"step":[682],"third":[686],"level":[687],"mastery:":[690],"Macros":[692],"miniature":[694],"custom":[698],"good":[701],"news":[702],"2010,":[707],"without":[714],"becoming":[715],"programmer.":[717],"You":[718],"drag,":[722],"drop,":[723],"arrange":[725],"sequence":[727],"ready-made":[729],"macro":[730,735],"commands":[731],"designer.":[736],"buttons":[745],"send":[747],"emails,":[748],"printouts,":[750],"updates,":[752],"take":[755,802],"around":[757],"5.":[760],"Expert":[761],"user,":[762],"meet":[763],"Visual":[764,808],"Basic.":[765],"Some":[766],"stop":[768],"their":[769,786],"journey":[771],"content":[775],"work.":[787],"see":[793],"everything":[794],"offer,":[798],"look":[804],"high-powered":[807],"Basic":[809],"engine.":[810],"Using":[811],"VB":[812],"code,":[813],"almost":[817],"anything,":[818],"validating":[820],"credit":[822],"card":[823],"leading":[825],"process":[831],"(two":[832],"examples":[833],"discussed":[836],"2010:":[839],"Missing":[841],"Manual).":[842],"And":[843],"willing":[846],"pick":[848],"basic":[851],"programming":[852],"concepts,":[853],"code":[857],"transform":[859],"simple":[861],"cohesive":[865],"applicationfor":[867],"something":[869],"looks":[871],"traditional":[875],"desktop":[876],"computer.":[882]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2624616977","counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2020,"cited_by_count":1}],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2017-06-15T00:00:00"}
