SOLVED

Microsoft Office 2019 Now Available – Comparing 2019 vs 2016 vs 365, New Features in Access & Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-332079%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Office%202019%20Now%20Available%20%E2%80%93%20Comparing%202019%20%3Avs_button%3A%202016%20%3Avs_button%3A%20365%2C%20New%20Features%20in%20Access%20%26amp%3Bam%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-332079%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F259205%22%20target%3D%22_blank%22%3E%40Mwandingi_03%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20use%20either%20of%20the%20following%202%20formulas%20in%20Excel%20to%20accomplish%20what%20you%20had%20asked%20about%2C%20so%20that%20the%20first%20non-blank%20date%20cell%20is%20returned%2C%20either%20in%20Sheet1%20A4%20(preferred)%20or%20else%20Sheet1%20A1%2C%20or%20else%2C%20if%20both%20are%20empty%2C%20then%20the%20result%20is%20an%20empty%20string%2C%20so%20that%20the%20result%20is%20also%20a%20blank.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIFS(NOT(ISBLANK(Sheet1!A4))%2CSheet1!A4%2CNOT(ISBLANK(Sheet1!A1))%2CSheet1!A1%2C%20TRUE%2C%20%22%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(ISBLANK(Sheet1!A4)%2CIF(ISBLANK(Sheet1!A1)%2C%22%22%2CSheet1!A1)%2CSheet1!A4)%3CBR%20%2F%3E%3CBR%20%2F%3EAs%20you%20can%20see%20this%20common%20use%20case%20is%20far%20more%20complicated%20than%20it%20should%20be.%20That%20is%2C%20in%20part%2C%20why%20I%20had%20developed%20%3CA%20href%3D%22http%3A%2F%2Fwww.PowerExcel.net%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EPowerExcel%20AI%20Tools%20%26amp%3B%20Power%20Functions%20Add-in%20for%20Excel%20(www.PowerExcel.net)%3C%2FA%3E%2C%20which%20is%20an%20install-free%20(JavaScript-based)%20and%20workbook%20embedded%20Excel%20Add-in%20which%20brings%20dozens%20of%20new%20functions%20for%20use%20in%20formulas%2C%20enabling%20the%20following%20instead%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DFirstOf(Sheet1!A4%2CSheet1!A1)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPowerExcel%20also%20provides%20other%20functions%20like%20IsNotBlank%2C%20IfsOr%2C%20IfsOrZero%2C%20IfsOrBlank%20and%20dozens%20of%20other%20powerful%2C%20intuitive%20and%20convenient%20functions%20for%20Excel%2C%20as%20well%20as%20a%20number%20of%20new%20Dynamic%20Array%20functions%20(which%20can%20return%20multiple%20results%20which%20can%20spill%20over%20into%20multiple%20cells%20automatically).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESimilar%20to%20the%20new%20functions%20provided%20for%20formulas%20in%20PowerExcel%2C%20%3CA%20href%3D%22https%3A%2F%2Fwww.PowerAccess.net%2FMicrosoft-Access-Toolset-VBA-Framework-Excel-SQL-Addin%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EPowerAccess%20All-in-One%20Toolset%20%26amp%3B%20Framework%20for%20Microsoft%20Access%20(PowerAccess.net)%3C%2FA%3E%20provides%20hundreds%20of%20new%20PowerSQL%20functions%20for%20Query%20Design%20and%20hundreds%20for%20MS%20Access%2C%20along%20with%20dozens%20of%20new%20tools%20and%20common%20database%20features.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20%3CA%20href%3D%22http%3A%2F%2Fwww.PowerExcel.net%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EPowerExcel%20AI%20Add-in%3C%2FA%3E%20and%20the%20%3CA%20href%3D%22https%3A%2F%2Fwww.CrushErrors.com%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ECrushErrors.com%20AI%20Excel%20Add-in%20and%20Cloud%20Platform%3C%2FA%3E%20are%20two%20new%20install-free%20Excel%20Add-ins%20which%20automate%20and%20simplify%20creation%20of%20Pivot%20Tables%20(auto-generated%20with%20template%20support)%2C%20Power%20Query%2C%20Slicers%2C%20Interactive%20Dashboards%20%26amp%3B%20Charts%2C%20Named%20Table%20%2F%20Range%20%2F%20Column%20use%2C%20Split%20%26amp%3B%20Merge%20(for%20Spreadsheets%2C%20Folders%20of%20Workbooks%2C%20Row%20Groups)%2C%20Pivot%20%2F%20Unpivot%2C%20Duplicate%20Removal%2C%20Fuzzy%20Lookup%20%2F%20Merge%20%2F%20Compare%2C%20Data%20Prep%20%2F%20Transform%2C%20Finance%2C%20Accounting%2C%20Reporting%2C%20Reconciliation%2C%20QuickBooks%2C%20converting%20Hierarchical%20%2F%20Multi-dimensional%20data%20(eg.%20accounts%20with%20rollup%20grouping%20or%20indentation%20levels%20from%20Hyperion%2C%20OLAP%20cubes%2C%20etc.)%20into%20usable%20form%20(for%20Pivot%20Tables%2C%20Grouping%2C%20Filtering)%2C%20as%20well%20simplifying%20and%20automating%20daily%20use%20of%20Excel%20%E2%80%94%20all%20through%20machine%20learning%20guidance%20and%20artificial%20intelligence%2C%20which%20understands%20your%20data%20and%20learns%20from%20your%20actions%20and%20Pivot%20Table%20and%20other%20designs%20to%20automate%20what%20is%20otherwise%20tedious%20and%20make%20it%20auto-maintained%20instead%20of%20broken%20whenever%20columns%20names%20or%20orders%20are%20changed%20or%20differ.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-321145%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Office%202019%20Now%20Available%20%E2%80%93%20Comparing%202019%20%3Avs_button%3A%202016%20%3Avs_button%3A%20365%2C%20New%20Features%20in%20Access%20%26amp%3Bam%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-321145%22%20slang%3D%22en-US%22%3EHi%20Dan%3CBR%20%2F%3E%3CBR%20%2F%3EThat%20sounds%20impressive.%20Kindly%20assist%20me%20with%20a%20formula%20that%20will%20return%20a%20date%20in%20one%20cell%20from%20two%20cells%20depending%20on%20which%20cell%20is%20filled.%3CBR%20%2F%3E%3CBR%20%2F%3EFor%20instance%2C%20a%20date%20should%20be%20returned%20in%20Sheet2%20A7%20from%20sheet1%20A1%20if%20sheet1%20A4%20is%20empty%20(no%20date%20filled)%20or%20from%20sheet1%20A4%20if%20sheet1%20A1%20is%20empty(no%20date%20filled)%20else%20return%20an%20empty%20cell%20if%20both%20(Sheet1%20A1%20and%20A4)%20are%20empty.%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-292250%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Office%202019%20Now%20Available%20%E2%80%93%20Comparing%202019%20%3Avs_button%3A%202016%20%3Avs_button%3A%20365%2C%20New%20Features%20in%20Access%20%26amp%3Bam%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-292250%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20just%20installed%20Office%202019%20click%20to%20run.%3CBR%20%2F%3EI%20am%20astonished%2C%20very%20bad%20experience.%3CBR%20%2F%3EFirst%20of%20all%20I%20run%20the%20installer%20and%20nothing%20happens%2C%20I%20got%20any%20message%20of%20installation%20procedure%20starting%26nbsp%3B%20and%20even%20no%20any%20message%20of%20end%20of%20installing%20procedure.%20Curious.%3CBR%20%2F%3EAfter%20I%20look%20for%20the%20installation%20folders%20and%20it%20look%20like%20Microsoft%20people%20has%20not%20enough%20time%20to%20made%20order%20to%20the%20things.%3CBR%20%2F%3EOffice%202019%20(Office%2017)%26nbsp%3B%20it%20create%20a%20folder%20Office%2015%20(why%3F)%26nbsp%3B%20and%20is%20located%20in%20folder%20Office%2016%20(why%3F).%3CBR%20%2F%3EI%20think%20that%20you%20need%20a%20little%20more%20care%20to%20your%20software.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-288160%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Office%202019%20Now%20Available%20%E2%80%93%20Comparing%202019%20%3Avs_button%3A%202016%20%3Avs_button%3A%20365%2C%20New%20Features%20in%20Access%20%26amp%3Bam%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-288160%22%20slang%3D%22en-US%22%3EEven%20when%20using%20Modern%20Charts%2C%20as%20are%20new%20in%20Access%202019%20and%20365%2C%20you%20can%20still%20open%20the%20Access%20database%20file%20with%20Access%202016%20and%20many%20earlier%20versions%20that%20support%20.ACCDB%20files%2C%20but%20just%20without%20the%20chart%20showing%20for%20those%20versions%20which%20don't%20support%20them.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-288159%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Office%202019%20Now%20Available%20%E2%80%93%20Comparing%202019%20%3Avs_button%3A%202016%20%3Avs_button%3A%20365%2C%20New%20Features%20in%20Access%20%26amp%3Bam%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-288159%22%20slang%3D%22en-US%22%3EYes%20Microsoft%20Access%202019%20and%20365%20are%20backwards-compatible%20with%20Access%202016%2C%20so%20that%20databases%20produced%20with%20them%20can%20be%20opened%20and%20used%20by%20Access%202016%20and%20vice%20versa.%3CBR%20%2F%3EEven%20if%20you%20use%20new%20features%20in%20Office%20365%20like%20Modern%20Charts%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-288155%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Office%202019%20Now%20Available%20%E2%80%93%20Comparing%202019%20%3Avs_button%3A%202016%20%3Avs_button%3A%20365%2C%20New%20Features%20in%20Access%20%26amp%3Bam%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-288155%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Dan%20could%20you%20tell%20me%20if%20access%202019%20has%20backward%20compability%20with%20access%202016%20and%20access%202010.%3C%2FP%3E%0A%3CP%3Ereally%20thanks%20!!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-286984%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Office%202019%20Now%20Available%20%E2%80%93%20Comparing%202019%20%3Avs_button%3A%202016%20%3Avs_button%3A%20365%2C%20New%20Features%20in%20Access%20%26amp%3Bam%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-286984%22%20slang%3D%22en-US%22%3E%3CP%3EThat%20said%2C%20you%20can%20install%20%3CA%20href%3D%22https%3A%2F%2Fwww.parallels.com%2Fproducts%2Fdesktop%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%3EParallels%3C%2FSPAN%3E%3C%2FA%3E%20(with%20Coherence%20Mode%20enabled)%20or%20%3CA%20href%3D%22https%3A%2F%2Fwww.vmware.com%2Fproducts%2Ffusion.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%3EVMware%20Fusion%3C%2FSPAN%3E%3C%2FA%3E%20(with%20Unity%20mode%20enabled)%20on%20a%20Mac%20and%20use%20that%20to%20run%20Microsoft%20Access%20inside%20of%20a%20native%20Mac%20window%20as%20if%20it%20was%20a%20native%20Mac%20app%20(though%2C%20under%20the%20hood%2C%20it%20uses%20Windows%20virtualization).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20a%20similar%20fashion%2C%20you%20can%20use%20%3CSPAN%3ERemoteApp%3C%2FSPAN%3E%2C%20a%20form%20of%20Remote%20Desktop%20which%20allows%20%3CSPAN%3Emany%20simultaneous%20users%20to%20connect%20to%20the%20same%20Windows%20Server%20(or%20PC)%20with%20Microsoft%20Access%3C%2FSPAN%3E%20installed%2C%20so%20that%20all%20they%20ever%20see%20is%20the%20launched%20application%20Window%2C%20appearing%20on%20their%20own%20%3CSPAN%3EPC%2C%20iPad%2C%20Mac%2C%20Android%2C%20web%20browser%20or%20mobile%20device%3C%2FSPAN%3E%20via%20an%20RDP%20client%2C%20allowing%20%3CSPAN%3Efull-screen%2C%20almost%20native%20app-like%20use%3C%2FSPAN%3E%20(full%20screen%20on%20in%20an%20app%20window%2C%20%3CSPAN%3Ewithout%20ever%20seeing%20a%20Windows%20desktop%3C%2FSPAN%3E%20or%20having%20to%20launch%20the%20app%20from%20it).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EServer%20Bandwidth%20may%20be%20more%20of%20a%20constraining%20factor%20with%20RemoteApp-based%20Access%20usage%2C%20limiting%20the%20maximum%20number%20of%20effective%20simultaneous%20users%20for%20different%20reasons%2C%20and%20can%20sometimes%20result%20in%20lag%20and%2For%20reduced%20frame%20rate%20(which%20may%20or%20may%20not%20be%20noticeable)%20especially%20with%20very%20slow%20cellular%20connections%2C%20even%20if%20the%20database%20operations%20themselves%20end%20up%20running%20much%20faster%20than%20with%20a%20typical%20multi-user%20Access%20database%20deployment%20via%20VPN%20%2F%20network%20share%20folders.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%20RemoteApp%20does%20provide%20its%20own%20performance%20and%20reliability%20benefits%2C%20such%20as%20a%20much%20reduced%20chance%20of%20database%20corruption.%20It%20can%20allow%20the%20Access%20database%20transactions%2Fqueries%20(and%20underlying%20JET%2FACE%2FAccess%20database%20engine)%20to%20operate%20as%20if%20each%20client%20has%20the%20database%20located%20locally%20on%20their%20own%20PC%20(assuming%20you%20locate%20it%20on%20the%20same%20server%2FPC%20hosting%20RemoteApp%2C%20though%20in%20some%20cases%20even%20if%20not)%20resulting%20in%20the%20database%20itself%20performing%20like%20it%20would%20if%20you%20were%20to%20open%20multiple%20instances%20of%20Microsoft%20Access%20with%20the%20same%20database%20(saved%20to%20your%20local%20drive)%20at%20the%20same%20time%20on%20your%20PC.%20RemoteApp%20presents%20a%20tradeoff%20(vs.%20VPN%20multi-user%20deployment)%20with%20bandwidth%20usage%20and%20performance%20being%20more%20fixed%2Fconstant%2C%20meaning%20higher%20bandwidth%20usage%20even%20idle%20(vs.%20VPN)%20for%20all%20users%20but%20potentially%20lower%20bandwidth%20usage%20or%20latency%20in%20cases%20which%20would%20otherwise%20be%20slow%20on%20VPN%20(such%20as%20with%20heavy%20data%20processing%2Fupdates).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThough%20RemoteApp%20is%20designed%20for%20Windows%20Server%20use%2C%20it%20can%20be%20hosted%20from%20any%20Windows%20PC%20(for%20running%20in%20the%20background%20while%20using%20that%20PC)%2C%20though%20limited%20to%20just%201%20connection%20at%20a%20time%20for%20Windows%20PC%20vs.%20up%20to%20255%20simultaneous%20connections%20(or%20much%20higher%20if%20using%20a%20SQL%20Server%20database%20backend)%20with%20Windows%20Server.%20RemoteApp%20can%20even%20enable%20simultaneous%20use%20by%20many%20mobile%20devices%20(such%20as%20iPads)%20over%20cellular%20connections.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20said%2C%20I've%20implemented%20a%20workaround%20for%20that%20limitation%2C%20as%20part%20of%20the%20%3CA%20href%3D%22https%3A%2F%2Fwww.PowerAccess.net%2FMicrosoft-Access-Toolset-VBA-Framework-Excel-SQL-Addin%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EPowerAccess%20All-in-One%20Toolset%20%26amp%3B%20Framework%20for%20Microsoft%20Access%3C%2FA%3E%20solutions%20platform%2C%20with%20tools%20for%20simplifying%20RemoteApp%20deployment%20and%20even%20enabling%20hosting%20from%20a%20single%20Windows%20Desktop%20PC%20(workstation)%20instead%20of%20just%20Windows%20Server%2C%20which%20avoids%20additional%20licensing%20costs%20and%20complexity.%26nbsp%3B%20I%20have%2C%20through%20this%20method%2C%20enabled%20Microsoft%20Access%20to%20run%20on%20multiple%20iPads%2C%20Macs%2C%20phones%20and%20even%20in%20Web%20Browsers%20simultaneously%20(with%20full-featured%2C%20touch-optimized%20support%20for%20the%20same%20Access%20Forms%2C%20Queries%2C%20Macros%20used%20on%20Windows%20desktop)%20based%20on%20one%20Microsoft%20Access%20installation%20on%20a%20single%20Windows%20desktop%20PC.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20this%20way%2C%20through%20%3CSTRONG%3ERemoteApps%20for%20mobile%2Fweb%2FMac%20use%20and%20Parallels%20or%20VMware%20Fusion%20for%20Macs%2C%20Microsoft%20Access%20can%20be%20used%20on%20Macs%2C%20iPads%2C%20Android%2C%20Web%20Browsers%20and%20mobile%20devices%2C%20as%20a%20viable%20alternative%20to%20PowerApps%3C%2FSTRONG%3E%20and%20the%20like%2C%20for%20or%20most%20clients%20and%20use%20cases%2C%20which%20typically%26nbsp%3B%20than%20255%20different%20users%20connecting%20to%20and%20using%20the%20same%20Access%20database%20at%20the%20same%20time%2C%20and%20for%20which%20an%20unlimited%20number%20of%20authorized%20potential%20users%20are%20supported.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-286983%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Office%202019%20Now%20Available%20%E2%80%93%20Comparing%202019%20%3Avs_button%3A%202016%20%3Avs_button%3A%20365%2C%20New%20Features%20in%20Access%20%26amp%3Bam%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-286983%22%20slang%3D%22en-US%22%3E%3CP%3EYes%2C%20like%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127914%22%20target%3D%22_blank%22%3E%40Karl%20Donaubauer%3C%2FA%3E%20had%20mentioned%2C%20Microsoft%20Access%20is%20not%20available%20for%20Mac%20and%20isn't%20expected%20to%20be%20any%20time%20soon%2C%20as%20much%20as%20I%20(and%20many%20others)%20may%20wish%20to%20the%20contrary.%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20can%20see%20the%20main%20User%20Voice%20suggestion%20for%20this%2C%20%22%3CA%20href%3D%22https%3A%2F%2Faccess.uservoice.com%2Fforums%2F319956-access-desktop%2Fsuggestions%2F12499587-access-for-apple-pc-s%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAccess%20for%20Apple%20PC's%3C%2FA%3E%22%20with%2072%20vote.%20Microsoft%20has%20rejected%20as%20%22No%20Current%20Plan%22%20for%20that%20as%20well%20as%20each%20of%20the%20other%20dozen%2B%20suggestions%20for%20this%2C%20with%20Microsoft%20Access%20Senior%20Program%20Manager%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F36243%22%20target%3D%22_blank%22%3E%40Michal%20Bar%3C%2FA%3E%20replying%3A%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E%26nbsp%3B%20%22We%20understand%20your%20frustration%20but%20at%20this%20point%20we%20have%20no%20plan%20to%20create%20a%20version%20of%20Access%20for%20Macs.%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESimilarly%2C%20Microsoft%20has%20rejected%20%3CA%20href%3D%22https%3A%2F%2Faccess.uservoice.com%2Fforums%2F319956-access-desktop-application%2Fsuggestions%2F33404554-when-will-access-have-a-mobile-version%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Esuggestions%20for%20mobile%20support%3C%2FA%3E%2C%20suggesting%20that%20PowerApps%20be%20used%20in%20those%20cases.%20However%2C%20unfortunately%2C%20PowerApps%20still%20doesn't%20currently%20support%20connecting%20to%20Microsoft%20Access%20as%20a%20data%20source%20(even%20though%20it%20shares%20the%20same%20On-Premises%20Date%20Gateway%20with%20Power%20BI%2C%20which%20does%20support%20connecting%20to%20Microsoft%20Access%20through%20it%2C%20and%20even%20though%20PowerApps%20is%20being%20pushed%20as%20a%20replacement%20for%20Microsoft%20Access%20Web%20Apps.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-286935%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Office%202019%20Now%20Available%20%E2%80%93%20Comparing%202019%20%3Avs_button%3A%202016%20%3Avs_button%3A%20365%2C%20New%20Features%20in%20Access%20%26amp%3Bam%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-286935%22%20slang%3D%22en-US%22%3E%3CP%3ECorrect.%20No%20Mac%20version%20as%20in%20the%20past%2026%20years%20and%20in%20the%20coming%2026.%3C%2FP%3E%0A%3CP%3E%3B)%3C%2Fimg%3E%3C%2FP%3E%0A%3CP%3EKarl%3C%2FP%3E%0A%3CP%3E*********%3CBR%20%2F%3E%3CA%20title%3D%22Access%20DevCon%20Vienna%22%20href%3D%22http%3A%2F%2Fwww.accessdevcon.com%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CFONT%20color%3D%22%230066cc%22%3Ehttp%3A%2F%2Fwww.AccessDevCon.com%3C%2FFONT%3E%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fwww.donkarl.com%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CFONT%20color%3D%22%230066cc%22%3Ehttp%3A%2F%2Fwww.donkarl.com%20%3C%2FFONT%3E%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-286734%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Office%202019%20Now%20Available%20%E2%80%93%20Comparing%202019%20%3Avs_button%3A%202016%20%3Avs_button%3A%20365%2C%20New%20Features%20in%20Access%20%26amp%3Bam%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-286734%22%20slang%3D%22en-US%22%3E%3CP%3ESo%20no%20Mac%20version%20of%20Access%3F%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-531745%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Office%202019%20Now%20Available%20%E2%80%93%20Comparing%202019%20%3Avs_button%3A%202016%20%3Avs_button%3A%20365%2C%20New%20Features%20in%20Access%20%26amp%3Bam%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-531745%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F73244%22%20target%3D%22_blank%22%3E%40Dan%20Moorehead%20%7C%20PowerAccess%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20use%20ACCESS%20for%20many%20years%20to%20manage%20an%20art%20collection.%3C%2FP%3E%3CP%3EWe%20have%201500%20Items.%3C%2FP%3E%3CP%3EWe%20can%20%22join%22%20JPEG%20pictures%2C%20but%20it%20is%20long%20to%20do%20it%2C%20slow%20in%20result%20and%20not%20efficient%20when%20we%20move%20the%20pictures.%3C%2FP%3E%3CP%3EIs%20it%20better%20with%20Access%202019%20%3F%3C%2FP%3E%3CP%3EDo%20you%20suggest%20to%20use%20OLE%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-780072%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Office%202019%20Now%20Available%20%E2%80%93%20Comparing%202019%20%3Avs_button%3A%202016%20%3Avs_button%3A%20365%2C%20New%20Features%20in%20Access%20%26amp%3Bam%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-780072%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F73244%22%20target%3D%22_blank%22%3E%40Dan%20Moorehead%20%7C%20PowerAccess%3C%2FA%3E!%20The%20Dark%20Gray%20%26amp%3B%20Black%20Office%20Themes%20need%20configuration%20for%20use%20in%20Access.%20Please%20let%20me%20know%20if%20there%20is%20a%20better%20place%20to%20comment%20on%20this.%20(Image%20provided)%20I%20really%20like%20the%20Dark%20Grey%20theme%2C%20but%20as%20a%20frequent%20MS%20Access%20user%20I%20have%20to%20switch%20to%20white%20or%20colorful%20in%20order%20to%20function%20in%20the%20query%20UI.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20525px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F125008i4937EA58E8243D56%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222019-07-30_14-19-50.png%22%20title%3D%222019-07-30_14-19-50.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-780689%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Office%202019%20Now%20Available%20%E2%80%93%20Comparing%202019%20%3Avs_button%3A%202016%20%3Avs_button%3A%20365%2C%20New%20Features%20in%20Access%20%26amp%3Bam%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-780689%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F177234%22%20target%3D%22_blank%22%3E%40Olivia%20Dudley%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3EYou%20have%20a%20good%20point.%3C%2FP%3E%3CP%3EI%20would%20suggest%20you%20submit%20a%20feature%20request%20for%20changing%20Dark%20Themes%20to%20have%20improved%20readability%20with%20font%20colors%20used%20on%20%3CA%20href%3D%22https%3A%2F%2Faccess.uservoice.com%2F%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EUserVoice%20for%20Microsoft%20Access%3C%2FA%3E%2C%20as%20the%20official%20site%20for%20adding%20feature%2Fchange%2Fbug%20fix%20requests%20for%20Access.%3C%2FP%3E%3CP%3EIf%20others%20vote%20for%20it%2C%20then%20Microsoft%20may%20have%20address%20it.%20You%20can%20then%20post%20a%20link%20here%20or%20elsewhere%20suggesting%20others%20vote%20for%20that%20feature%20(or%20they%20can%20do%20so%20if%20searching%20for%20existing%20similar%20requests%20to%20vote%20for).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20also%20vote%20for%20and%20comment%20on%20other%20feature%20requests%20there%2C%20as%20well%20as%20on%20the%20other%20User%20Voice%20sites%20for%20%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2F%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMicrosoft%20Excel%20suggestions%3C%2FA%3Eand%20%3CA%20href%3D%22https%3A%2F%2Fofficespdev.uservoice.com%2F%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EOffice%20Developer%20Platform%20suggestions%3C%2FA%3E(for%20Office.js%2C%20VBA%2C%20Add-in%20development%2C%20VSTO%2C%20and%20the%20like).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EComments%20can%20also%20help%20to%20encourage%20others%20to%20vote%20or%20provide%20details%20later%20on%20(as%20can't%20edit%20once%20you%20post)%20or%20to%20provide%20details%20on%20why%20this%20should%20be%20considered%20important.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20that%20helps%2C%3C%2FP%3E%3CP%3EDan%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E--%3C%2FP%3E%3CP%3EDan%20Moorehead%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%224%22%3ECTO%2C%26nbsp%3B%20%3CA%20href%3D%22https%3A%2F%2Fwww.PowerSheet.ai%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%3EPowerSheet.ai%20BI%20for%20Excel%3C%2FSPAN%3E%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%224%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.PowerSheet.ai%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EPowerSheet.ai%3C%2FA%3E%26nbsp%3B%20%E2%97%8F%26nbsp%3B%20%3CA%20href%3D%22https%3A%2F%2Fwww.linkedin.com%2Fin%2FDanMoorehead%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ELinkedIn%3C%2FA%3E%26nbsp%3B%20%E2%97%8F%26nbsp%3B%20%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2FPowerSheetAI%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ETwitter%3C%2FA%3E%26nbsp%3B%20%E2%97%8F%26nbsp%3B%20%3CA%20href%3D%22https%3A%2F%2Fwww.facebook.com%2FDanLMoorehead%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EFacebook%3C%2FA%3E%26nbsp%3B%20%E2%97%8F%26nbsp%3B%20%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fchannel%2FUCgmqX5jfVjZHlVnfc2HwXrA%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EYouTube%3C%2FA%3E%26nbsp%3B%20%E2%97%8F%26nbsp%3B%20(206)%20792-9969%26nbsp%3B%20%E2%97%8F%26nbsp%3B%20dan.moorehead%20(Skype)%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%224%22%3E%3CSPAN%3EFree%20Easy%20AI-powered%20BI%2C%20Data%20Cleaning%20%26amp%3B%20Collaboration%20in%20Excel%20%26amp%3B%20Online%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%224%22%3E%E2%97%8F%20Business%20Intelligence%20%E2%97%8F%20Reporting%20%E2%97%8F%20Collaboration%20%E2%97%8F%20Data%20Cleaning%20%E2%97%8F%20BI%20Dashboards%20%E2%97%8F%20Database%20Building%20%E2%97%8F%20Forms%20%E2%97%8F%20Accounting%20%E2%97%8F%20Financial%20Reporting%20%E2%97%8F%20Cloud%20Templates%20%E2%97%8F%20Instant%20Version%20History%20%26amp%3B%20Compare%20%E2%97%8F%20Collaborative%20Editing%20Anywhere%2FOffline%20%E2%97%8F%20Web%20Publishing%20in%20%E2%97%8F%20Excel%20%E2%97%8F%20PowerPoint%20%E2%97%8F%20SharePoint%20%E2%97%8F%20Online%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-823088%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Office%202019%20Now%20Available%20%E2%80%93%20Comparing%202019%20%3Avs_button%3A%202016%20%3Avs_button%3A%20365%2C%20New%20Features%20in%20Access%20%26amp%3Bam%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-823088%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F73244%22%20target%3D%22_blank%22%3E%40Dan%20Moorehead%20%7C%20PowerAccess%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20feel%20distinctly%20short-changed%20buying%20a%20new%20version%20of%20Excel%20that%20has%20dynamic%20arrays%20missing.%26nbsp%3B%20Most%20of%20the%20new%20features%20are%20just%20frills%2C%20nice%20if%20you%20need%20them.%26nbsp%3B%20DAs%20are%20changing%20the%20way%20one%20can%20build%20solutions%20from%20the%20ground%20up%20so%20it%20is%20also%20going%20to%20be%20a%20pain%20if%20clients%20are%20missing%20such%20core%20functionality.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOne%20thing%20that%20concerns%20me%20with%20the%20365%20Cloud%20model%20is%20how%20would%20I%20guarantee%20to%20a%20client%20that%20none%20of%20their%20data%20is%20ever%20stored%20or%20visible%20on%20a%20third-party%20server%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-838325%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Office%202019%20Now%20Available%20%E2%80%93%20Comparing%202019%20%3Avs_button%3A%202016%20%3Avs_button%3A%20365%2C%20New%20Features%20in%20Access%20%26amp%3Bam%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-838325%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F73244%22%20target%3D%22_blank%22%3E%40Dan%20Moorehead%20%7C%20PowerAccess%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhy%20is%20the%20support%20period%20for%20Office%202019%20%5BOffice%20Professional%20Plus%202019%5D%20shorter%20than%20it%20use%20to%20be%20(mainstrem%205Y%20%2B%20extended%205Y)%3F%20And%20is%20there%20any%20information%20available%20about%20Office%20will%20be%20available%20for%20on-prem%20installation%20(rather%20then%20only%20Web%20based)%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-858103%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Office%202019%20Now%20Available%20%E2%80%93%20Comparing%202019%20%3Avs_button%3A%202016%20%3Avs_button%3A%20365%2C%20New%20Features%20in%20Access%20%26amp%3Bam%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-858103%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F73244%22%20target%3D%22_blank%22%3E%40Dan%20Moorehead%20%7C%20PowerAccess%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Dan%2C%20I%20see%20with%20the%20latest%20MS%20Access%20365%20the%20Access%20form%2Freport%20tabs%20(the%20tabs%20that%20appear%20along%20the%20top%20of%20the%20screen%20when%20you%20open%20forms%2Freports)%20have%20their%20own%20close%20(x)%20buttons%20now%20and%20they%20can%20also%20be%20dragged%20to%20rearrange.%20Can%20you%20tell%20me%20if%20this%20is%20also%20now%20part%20of%20the%20latest%20Access%202019%20and%20if%20not%20when%20it%20will%20be.%3C%2FP%3E%3CP%3EMany%20thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-859106%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Office%202019%20Now%20Available%20%E2%80%93%20Comparing%202019%20%3Avs_button%3A%202016%20%3Avs_button%3A%20365%2C%20New%20Features%20in%20Access%20%26amp%3Bam%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-859106%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F73244%22%20target%3D%22_blank%22%3E%40Dan%20Moorehead%20%7C%20PowerAccess%3C%2FA%3E%26nbsp%3B%20Thank%20you%20for%20your%20clarity%20and%20future%20of%20both%20Microsoft%20Office%202019%20and%20cloud%20based%20365.%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20possible%2C%20I%20would%20suggest%20to%20offer%20the%20best%20of%20both%20worlds%20to%20your%20customers%20they%20cannot%20refuse.%20Thanks%20for%20all%20the%20innovation%20and%20progress.%20Kudos.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-965471%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Office%202019%20Now%20Available%20%E2%80%93%20Comparing%202019%20%3Avs_button%3A%202016%20%3Avs_button%3A%20365%2C%20New%20Features%20in%20Access%20%26amp%3Bam%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-965471%22%20slang%3D%22en-US%22%3E%3Athumbs_up%3A%3Arose%3A%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-965623%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Office%202019%20Now%20Available%20%E2%80%93%20Comparing%202019%20%3Avs_button%3A%202016%20%3Avs_button%3A%20365%2C%20New%20Features%20in%20Access%20%26amp%3Bam%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-965623%22%20slang%3D%22en-US%22%3E%3Athumbs_up%3A%3Arose%3A%3Aheart_suit%3A%3Asmiling_face_with_smiling_eyes%3A%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-965670%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Office%202019%20Now%20Available%20%E2%80%93%20Comparing%202019%20%3Avs_button%3A%202016%20%3Avs_button%3A%20365%2C%20New%20Features%20in%20Access%20%26amp%3Bam%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-965670%22%20slang%3D%22en-US%22%3E%3Athumbs_up%3A%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-970347%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Office%202019%20Now%20Available%20%E2%80%93%20Comparing%202019%20%3Avs_button%3A%202016%20%3Avs_button%3A%20365%2C%20New%20Features%20in%20Access%20%26amp%3Bam%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-970347%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20update%20about%20%3CU%3E%3CA%20href%3D%22https%3A%2F%2Fwww.koenig-solutions.com%2Fmicrosoft-training-certification-courses.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMicrosoft%20Office%3C%2FA%3E%3C%2FU%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F73244%22%20target%3D%22_blank%22%3E%40Dan%20Moorehead%20%7C%20PowerAccess%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-261677%22%20slang%3D%22en-US%22%3EMicrosoft%20Office%202019%20Now%20Available%20%E2%80%93%20Comparing%202019%20vs%202016%20vs%20365%2C%20New%20Features%20in%20Access%20%26amp%3B%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-261677%22%20slang%3D%22en-US%22%3E%3CH2%20id%3D%22toc-hId-1701901182%22%20id%3D%22toc-hId-1701901182%22%3EMicrosoft%20Office%202019%20is%20out!%3C%2FH2%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMicrosoft%20started%20the%20roll-out%20today%20of%20Microsoft%20Office%202019%20for%20Windows%20%26amp%3B%20Mac%20%E2%80%93%20with%20major%20updates%20to%20Access%2C%20Excel%2C%20Word%2C%20PowerPoint%2C%20Outlook%2C%20Project%2C%20Visio%2C%20and%20Publisher%20%E2%80%93%20to%20commercial%20volume%20license%20customers.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMicrosoft%20is%20following%20up%20with%20Office%202019%20releases%20to%20consumers%20and%20other%20business%20customers%2C%20as%20well%20as%20SharePoint%20%2F%20Exchange%20%2F%20Skype%20%2F%20Project%20Server%202019%20releases%2C%20in%20the%20coming%20weeks.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F54326iD4632F610C15A06B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20border%3D%220%22%20alt%3D%22Example%20screenshot%20of%20Microsoft%20Word%2C%20Excel%2C%20Powerpoint%20and%20Outlook%22%20title%3D%22Office%202019%20Apps%202x2.png%22%20%2F%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOffice%202019%20provides%20a%20subset%20of%20features%20Microsoft%20has%20added%20to%20Office%20365%20over%20the%20past%20three%20years.%20As%20Office%202019%20is%20a%20one-time%20release%2C%20Office%20365%20is%20still%20the%20better%20choice%20with%20not%20only%20far%20more%20features%20(Co-Authoring%2C%20etc)%20unavailable%20in%20Office%202019%2C%20but%20also%20far%20earlier%20access%20to%20them%20than%20on-premises%2C%20non-subscription%20Office%202019%2C%20etc.%20editions.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESpeculation%20has%20been%20that%20Office%202019%20may%20be%20the%20last%20perpetual%20license%20(on-premises%20%2F%20non-subscription)%20release%20of%20Office%2C%20so%20that%20Microsoft%20can%20focus%20in%20on%20its%20Office%20365%20subscription%20offerings.%20However%2C%20Microsoft%20has%20responded%20in%20one%20case%20that%20there%20is%20likely%20to%20be%20one%20more%20perpetual%20license%20release%20after%20this%20one.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EEither%20way%2C%20Microsoft%20Office%202019%20product%20pages%20even%20describe%20Office%202019%20as%20a%20%22one-time%20release%22%20with%20Office%20365%20being%20needed%20to%20gain%20access%20to%20new%20features%20after%20that.%20It%20may%20also%20be%20that%20there%20are%20fewer%20editions%20available%20for%20Office%202019%20than%20for%20Office%202016.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhether%20you%20move%20to%20Office%202019%20or%20365%2C%20it's%20suggested%20you%20don't%20delay%20doing%20so%2C%20as%20Office%202016%20cloud%20support%20will%20be%20dropped%20in%202020%2C%20with%20Office%202016%20installs%20barred%20from%20connecting%20to%20Microsoft's%20cloud-based%20services%2C%20including%20hosted%20email%20(Exchange)%20and%20online%20storage%20(OneDrive%20for%20Business)%2C%20after%20Oct.%2013%2C%202020.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%20%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F54325i2B107185F631A418%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20border%3D%220%22%20alt%3D%22Drawing%20a%20floorplan%20and%20extension%20on%20a%20Microsoft%20Surface%20Pro%20with%20a%20Microsoft%20Surface%20pen%22%20title%3D%22Office%202019%20PowerPoint%20with%20Pen%20from%20The%20Verge.png%22%20%2F%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId--850255779%22%20id%3D%22toc-hId--850255779%22%3E%3CSPAN%3ENew%20in%20Office%202019%3C%2FSPAN%3E%3C%2FH2%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CSPAN%3EWord%26nbsp%3B%E2%80%93%20text-to-speech%2C%20improved%20inking%20%26amp%3B%20accessibility%2C%20focus%20mode%2C%20translator%2C%20Learning%20tools%20(captions%20%26amp%3B%20audio%20descriptions)%2C%20%40%20Mentions%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3EPowerPoint%20%E2%80%93%20Morph%20transitions%2C%20Zoom%2C%20SVG%2C%203D%20model%2C%20play%20in-click%20sequence%2C%204k%20video%2C%20%40%20Mentions%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3EExcel%20%E2%80%93%20Power%20Query%20(Get%20%26amp%3B%20Transform)%20enhancements%2C%20Power%20Pivot%20included%20with%20all%20editions%2C%20new%20functions%20%26amp%3B%20connectors%2C%20publish%20to%20Power%20BI%2C%20AI-driven%20Excel%20Insights%20for%20chart%20suggestions%2C%20new%20charts%2C%20%40%20Mentions%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CUL%3E%0A%3CLI%3E%3CSPAN%3EExcludes%20Co-Authoring%2C%20new%20Data%20Types%20like%20Stocks%2C%20and%20some%20other%20new%20features%20only%20available%20in%20Office%20365%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CLI%3E%3CSPAN%3EOutlook%20%E2%80%93%26nbsp%3B%40%20Mentions%2C%20Office%20365%20Groups%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3EOneNote%20%E2%80%93%20OneNote%20for%20Windows%2010%20(Modern%20App%20included%20with%20Windows)%20has%20replaced%20OneNote%20desktop%20app%20(though%20OneNote%202016%20will%20be%20available%20via%20Volume%20License%20Install%20tool)%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3EAll%20Office%20apps%20%E2%80%93%20Ribbon%20customizations%20and%20roaming%20pencil%20case%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3EMicrosoft%20Access%20-%20including%20the%20many%20updates%20we've%20seen%20recently%20such%20as%3A%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CUL%3E%0A%3CLI%3E%3CSPAN%3EModern%20Charts%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3ENew%20Linked%20Table%20Manager%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3EDark%20theme%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3EBig%20Int%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3ESalesforce%20%26amp%3B%20Dynamics%20connectors%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%20%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F54323iFCAC8E14F7A75AE0%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20border%3D%220%22%20alt%3D%22Example%20of%20Microsoft%20Modern%20Charts%20in%20Microsoft%20Excel%202019%22%20title%3D%22Modern%20Charts%20in%20Microsoft%20Access%20-%20Combo%20Chart.png%22%20%2F%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F54324iB77FB7496D989C89%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20border%3D%220%22%20alt%3D%22Example%20of%20PowerAccess%20in%20Query%20Design%20SQL%22%20title%3D%22PowerAccess-Screenshot-Query%20Design%20SQL.png%22%20%2F%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId-892554556%22%20id%3D%22toc-hId-892554556%22%3EOther%20Recent%20Developments%20with%20Microsoft%20Access%3C%2FH2%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt's%20especially%20exciting%20to%20see%20all%20the%20new%20features%2C%20growing%20user%20base%20and%20communities%2C%20new%20integrations%2C%20and%20development%20team%20responsiveness%20seen%20with%20Microsoft%20Access%20of%20late.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EInclusion%20on%20the%20Office%20templates%20page%3CUL%3E%0A%3CLI%3EWhich%20I%20hope%20will%20become%20permanent%20soon%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3CLI%3ESQL%20Server%20Migration%20Assistant%20(SSMA)%20updates%3C%2FLI%3E%0A%3CLI%3EODBC%20and%20OLE%20DB%20driver%20updates%20%E2%80%93%20for%20optimized%20use%20and%20new%20feature%20support%20for%20SQL%20Server%2C%20Azure%20SQL%20and%20other%20back-ends%20databases%3C%2FLI%3E%0A%3CLI%3EPower%20BI%20support%20(via%20On-Premises%20Data%20Gateway)%3CUL%3E%0A%3CLI%3EConsidering%20On-Premises%20Data%20Gateway%20is%20shared%20with%20PowerApps%2C%20hopefully%20that%20means%20we%20may%20see%20PowerApps%20support%20too%20in%20the%20future%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3CLI%3ENew%20%26amp%3B%20growing%20Access%20conferences%20and%20user%20communities%3A%3CBR%20%2F%3E%3CUL%3E%0A%3CLI%3ENew%20Access%20Developers'%20Day%20in%20Amsterdam%3C%2FLI%3E%0A%3CLI%3EDevCon%20in%20Vienna%2C%20AEK%20in%20Germany%2C%20UKAUG%20in%20UK%2C%20PAUG%20in%20Portland%2C%20Access%20Day%20in%20Redmond%2C%20Access%20Madrid%20in%20Spain%3C%2FLI%3E%0A%3CLI%3EPresence%20at%20Microsoft%20Ignite%20and%20other%20conferences%3C%2FLI%3E%0A%3CLI%3EAccess%20User%20Groups%20(AUG)%20webinars%20and%20local%20chapters%20(Chicago%2C%20Denver%2C%20Madrid%2C%20Hertfordshire%2C%20etc.)%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3CLI%3EAccess%20now%20included%20in%20most%20Office%20editions%3CUL%3E%0A%3CLI%3EIncluded%20in%20nearly%20all%20(besides%20Online-only)%20editions%3C%2FLI%3E%0A%3CLI%3EAccess%20in%20Office%20365%20Home%2C%20Personal%2C%20Business%2C%20Business%20Premium%2C%20ProPlus%2C%20E3%2C%20and%20E5%20editions%3C%2FLI%3E%0A%3CLI%3EAccess%20in%20Office%202016%20Professional%20and%20ProPlus%20editions%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWith%20MS%20Access%20having%20been%20added%20to%20most%20Office%20editions%2C%20presumably%20it%20will%20likewise%20be%20available%20with%20most%20Office%202019%20editions%20now%20too.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt's%20great%20to%20see%20these%20features%20available%20to%20Office%20365%20subscribers%20(or%20even%20sooner%20if%20opt-in%20for%20Insiders%20program)%20now%20being%20made%20available%20to%20others%20with%20Office%202019%2C%20and%20I%20look%20forward%20to%20the%20many%20more%20new%20advancements%20with%20Microsoft%20Access%20and%20Office%20to%20come.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId--1659602405%22%20id%3D%22toc-hId--1659602405%22%3E%3CSPAN%3ELinks%20to%20More%20Info%20about%20Office%202019%3C%2FSPAN%3E%3C%2FH2%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20find%20out%20more%20about%20Office%202019%20with%20the%20following%20articles%2C%20FAQs%20and%20product%20pages%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fproducts.office.com%2Fen-us%2Fbusiness%2Foffice-365-proplus%3Factivetab%3Dtabs%253aprimaryr4%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%3EOffice%20365%20vs.%202019%20Editions%3C%2FSPAN%3E%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fhelp%2F4133312%2Foffice-2019-commercial-for-windows-and-mac-frequently-asked-questions%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%3EOffice%202019%20Commercial%20FAQ%3C%2FSPAN%3E%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fmicrosoft-365%2Fblog%2F2018%2F09%2F24%2Foffice-2019-is-now-available-for-windows-and-mac%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%3EMicrosoft's%20Office%202019%20Announcement%3C%2FSPAN%3E%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fwww.computerworld.com%2Farticle%2F3229906%2Fsoftware-productivity%2Foffice-2019-is-coming-heres-what-you-need-to-know.html%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%3EOffice%202019%20and%20Discontinuing%20of%20Office%202016%3C%2FSPAN%3E%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fwww.theverge.com%2F2018%2F9%2F24%2F17896700%2Fmicrosoft-office-2019-release-date-features%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%3EThe%20Verge%20release%20article%3C%2FSPAN%3E%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fwww.zdnet.com%2Farticle%2Fmicrosoft-starts-rolling-out-office-2019-for-windows-and-mac%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%3EZDNet%20release%20article%3C%2FSPAN%3E%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fwww.engadget.com%2F2018%2F09%2F24%2Fmicrosoft-releases-office-2019%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%3EEndgadget%20release%20article%3C%2FSPAN%3E%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fventurebeat.com%2F2018%2F09%2F24%2Fmicrosoft-launches-office-2019-for-windows-and-mac-promises-it-wont-be-the-last%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%3EVentureBeat%20release%20article%3C%2FSPAN%3E%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fwww.techspot.com%2Fnews%2F76598-microsoft-office-2019-launches-commercial-customers.html%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3ETechSpot%20release%20article%3C%2FA%3E%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E--%3C%2FP%3E%0A%3CP%3EDan%20Moorehead%3C%2FP%3E%0A%3CP%3EFounder%20%26amp%3B%20Chief%20Software%20Architect%3C%2FP%3E%0A%3CP%3EPowerAccess%20(-ERR%3AREF-NOT-FOUND-%3CA%20href%3D%22http%3A%2F%2Fwww.PowerAccess.net%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ewww.PowerAccess.net%3C%2FA%3E)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%22Empower%20Microsoft%20Access%20%E2%80%93%20with%20new%20Tools%20%7C%20VBA%20Framework%20%7C%20PowerGit%20%7C%20Power%20Query-like%20PowerSQL%20%7C%20VSTO-like%20.NET%20API%20%7C%20CodeGen%20%7C%20Excel%20Formulas%20%26amp%3B%20Functions%20%7C%20Consulting%20%7C%20Excel%20%3C%2FSPAN%3E%3CSPAN%3E%E2%9E%9C%3C%2FSPAN%3E%3CSPAN%3E%20Access%20%3C%2FSPAN%3E%3CSPAN%3E%E2%9E%9C%3C%2FSPAN%3E%3CSPAN%3E%20SQL%20Conversion%20Tools%22%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-261677%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2016%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3E2019%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENews%20%26amp%3B%20Announcements%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Contributor

Microsoft Office 2019 is out!

 

Microsoft started the roll-out today of Microsoft Office 2019 for Windows & Mac – with major updates to Access, Excel, Word, PowerPoint, Outlook, Project, Visio, and Publisher – to commercial volume license customers.

 

Microsoft is following up with Office 2019 releases to consumers and other business customers, as well as SharePoint / Exchange / Skype / Project Server 2019 releases, in the coming weeks.

 

 Example screenshot of Microsoft Word, Excel, Powerpoint and Outlook

 

Office 2019 provides a subset of features Microsoft has added to Office 365 over the past three years. As Office 2019 is a one-time release, Office 365 is still the better choice with not only far more features (Co-Authoring, etc) unavailable in Office 2019, but also far earlier access to them than on-premises, non-subscription Office 2019, etc. editions. 

 

Speculation has been that Office 2019 may be the last perpetual license (on-premises / non-subscription) release of Office, so that Microsoft can focus in on its Office 365 subscription offerings. However, Microsoft has responded in one case that there is likely to be one more perpetual license release after this one.

 

Either way, Microsoft Office 2019 product pages even describe Office 2019 as a "one-time release" with Office 365 being needed to gain access to new features after that. It may also be that there are fewer editions available for Office 2019 than for Office 2016.

 

Whether you move to Office 2019 or 365, it's suggested you don't delay doing so, as Office 2016 cloud support will be dropped in 2020, with Office 2016 installs barred from connecting to Microsoft's cloud-based services, including hosted email (Exchange) and online storage (OneDrive for Business), after Oct. 13, 2020.

 

  Drawing a floorplan and extension on a Microsoft Surface Pro with a Microsoft Surface pen

 

New in Office 2019

 

  • Word – text-to-speech, improved inking & accessibility, focus mode, translator, Learning tools (captions & audio descriptions), @ Mentions
  • PowerPoint – Morph transitions, Zoom, SVG, 3D model, play in-click sequence, 4k video, @ Mentions
  • Excel – Power Query (Get & Transform) enhancements, Power Pivot included with all editions, new functions & connectors, publish to Power BI, AI-driven Excel Insights for chart suggestions, new charts, @ Mentions
    • Excludes Co-Authoring, new Data Types like Stocks, and some other new features only available in Office 365
  • Outlook – @ Mentions, Office 365 Groups
  • OneNote – OneNote for Windows 10 (Modern App included with Windows) has replaced OneNote desktop app (though OneNote 2016 will be available via Volume License Install tool)
  • All Office apps – Ribbon customizations and roaming pencil case
  • Microsoft Access - including the many updates we've seen recently such as:
    • Modern Charts
    • New Linked Table Manager
    • Dark theme
    • Big Int
    • Salesforce & Dynamics connectors

 

  Example of Microsoft Modern Charts in Microsoft Excel 2019

 

Example of PowerAccess in Query Design SQL

 

Other Recent Developments with Microsoft Access

 

It's especially exciting to see all the new features, growing user base and communities, new integrations, and development team responsiveness seen with Microsoft Access of late.

 

  • Inclusion on the Office templates page
    • Which I hope will become permanent soon
  • SQL Server Migration Assistant (SSMA) updates
  • ODBC and OLE DB driver updates – for optimized use and new feature support for SQL Server, Azure SQL and other back-ends databases
  • Power BI support (via On-Premises Data Gateway)
    • Considering On-Premises Data Gateway is shared with PowerApps, hopefully that means we may see PowerApps support too in the future
  • New & growing Access conferences and user communities:
    • New Access Developers' Day in Amsterdam
    • DevCon in Vienna, AEK in Germany, UKAUG in UK, PAUG in Portland, Access Day in Redmond, Access Madrid in Spain
    • Presence at Microsoft Ignite and other conferences
    • Access User Groups (AUG) webinars and local chapters (Chicago, Denver, Madrid, Hertfordshire, etc.)
  • Access now included in most Office editions
    • Included in nearly all (besides Online-only) editions
    • Access in Office 365 Home, Personal, Business, Business Premium, ProPlus, E3, and E5 editions
    • Access in Office 2016 Professional and ProPlus editions

 

With MS Access having been added to most Office editions, presumably it will likewise be available with most Office 2019 editions now too.

 

It's great to see these features available to Office 365 subscribers (or even sooner if opt-in for Insiders program) now being made available to others with Office 2019, and I look forward to the many more new advancements with Microsoft Access and Office to come.

 

Links to More Info about Office 2019

 

You can find out more about Office 2019 with the following articles, FAQs and product pages:

 

 

--

Dan Moorehead

Founder & Chief Software Architect

PowerAccess (www.PowerAccess.net)

 

"Empower Microsoft Access – with new Tools | VBA Framework | PowerGit | Power Query-like PowerSQL | VSTO-like .NET API | CodeGen | Excel Formulas & Functions | Consulting | Excel Access SQL Conversion Tools"

20 Replies