Microsoft Office 2019 Now Available – Comparing 2019 vs 2016 vs 365, New Features in Access & Excel
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. 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. 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 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: https://products.office.com/en-us/business/office-365-proplus?activetab=tabs%3aprimaryr4 https://support.microsoft.com/en-us/help/4133312/office-2019-commercial-for-windows-and-mac-frequently-asked-questions https://www.microsoft.com/en-us/microsoft-365/blog/2018/09/24/office-2019-is-now-available-for-windows-and-mac/ https://www.computerworld.com/article/3229906/software-productivity/office-2019-is-coming-heres-what-you-need-to-know.html https://www.theverge.com/2018/9/24/17896700/microsoft-office-2019-release-date-features https://www.zdnet.com/article/microsoft-starts-rolling-out-office-2019-for-windows-and-mac/ https://www.engadget.com/2018/09/24/microsoft-releases-office-2019/ https://venturebeat.com/2018/09/24/microsoft-launches-office-2019-for-windows-and-mac-promises-it-wont-be-the-last/ https://www.techspot.com/news/76598-microsoft-office-2019-launches-commercial-customers.html -- Dan Moorehead Founder & Chief Software Architect PowerAccess (https://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"
Need help creating a template
Hello everyone, I'm new here, but not to Word. Hoping I can get some help with a problem I haven't found a solution for yet. I have some 4" x 6" C-Line photo pages that include some tearable cardstock inserts that you can write on or type on and then insert into the page (this is their product # 52564 if you are interested in seeing yourself). The inserts are on a perforated sheet 7" wide by 10" tall and there are 10 inserts per sheet, only 1 insert wide. I figured I could create a custom label template as follows and use that: When I start a new document using this label template, on screen it looks exactly like the insert sheets: The problem is that I would like to center the text vertically on each "label" before centering it horizontally. Unfortunately, every attempt I have made has been unsuccessful. All text is started at the very top of each insert/"label". I've tried typing out my text and then using Layout>Page Setup>Layout>Page Alignment to center the text, but it simply shifts everything down and prevents the use of the bottom/10th insert: Are my settings correct for the "label" template? Is there a way to set the label template as vertically centered versus top alignment? Should I be looking elsewhere to vertically center any text I type in? Any other advice on how to solve this problem? Greatly appreciated in advance.
Word 2019 for Mac searching in Word document for stray fonts
I am working on a book length document which is intended to use only two fonts, Calisto MT 11pt and Perpetua 12pt the latter very much less than the former. The pdf from this file when analysed by Adobe Acrobat revealed fonts other than these. I have by checking certain parts of the document found two lines in Cambria, which I changed to Calisto MT. I need to be able to search for the fonts which Adobe identified and correct them. It is almost impossible to do this visually especially with Cambria and Calisto being so alike. I recall being able to do this several years ago for another book in Word 2011 for Mac by using the Advanced Find and Replace. I just can't do it now in Word 2019 for Mac. I realise that select all, change font etc is possibility but with two fonts both needed it becomes less attractive as I don't wish to disturb pagination as will happen due to global point size changes, I am in very late stages before printing. I should be most grateful for a simple guide as to how to do it in Find and Replace; I only need Find a Font actually' Many thanks SpencerAccess Europe meeting on Wed 6 Sept - Database Analyzer and other tools
The next Access Europe meeting will be on Wednesday 6 Sept 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central Europe and 10AM in Seattle / PST Please note that the UK is now on Summer Time (UTC+1). For local times, please check https://www.worldtimebuddy.com/ In this month's session, I will be demonstrating my new Database Analyzer Pro application. The free evaluation version is now available for download from the above link on my website If time permits, I will also be discussing a number of related Access examples and code samples such as: • the use of progress bars • creating a table of contents in Access reports • the undocumented SaveAsText/LoadFromText features • changing query views using command bars code For more details about this session, see: https://accessusergroups.org/europe/event/access-europe-2023-09-06/ or https://isladogs.co.uk/aeu-19/ The meeting will again be held on Zoom. When the time comes, you can connect using: Join Zoom Meeting. If you are asked, use: Meeting ID: 924 3129 5683 ; Passcode: 661210 For more connection options, please see the AccessUserGroups.org web page for this event All sessions are recorded and later uploaded to the Access User Groups channel on YouTube I hope you will join us for this month's session. As always, the session will be recorded and the video uploaded to YouTube after the event NOTE: I regret that the planned presentation on Better Access Charts by Thomas Moller originally scheduled for Wed 6 Sept has been postponed until further notice.Headings Ignored For cross Reference Selection
Running Word 2019 Office Professional. I'm trying to insert a cross reference from one part of my document to another using a heading type. I highlighted the "destination" text and under the HOME tab selected the Intense Emphasis style from the Styles section (as per help "Add a heading). I then went to where I wanted to insert the cross reference, and added the text I want to use to launch the cross reference. I then highlighted the "source" text and from the INSERT tab selected Cross Reference. When the cross reference interface opens there are no headings displayed in the "For Which heading" box. I have multiple numbered lists in my document that do show up if I change the reference type to numbered list.
Table Of Contents Formatting Not Matching Heading Style Formatting
In my word document (Microsoft Office Professional 2019 / .docx) all of the headings are setup using the Heading 1 style which is set for font= Arial, Size= 12, and BOLD is turned on. My table of contents is setup to use the Heading 1 style as shown: {TOC \h \z \t "Heading 1,1,Heading 2,2,Heading 3,3" } The table of contents works to capture all of the correct pages, however, where all of the headings in the document are done in all caps, the entries in the table of contents vary from all caps, all caps for the first word or two, to all lowercase as shown below. I've tried to update the Heading 1 style and then doing the "Update Field / Update Entire Table", but the text in the TOC stays the same.
Access 2019 #Deleted Table status (Field NVARCHAR)
Hi, There has been an issue regarding Access 2019 displaying #Deleted status on certain table, for only certain windows user profile. Based on my analysis: 1. This happen to only certain user profile. If I login into the windows using another profile and open the table, the data will be normally displayed. 2. This table are linked table with SQL server 2016, so I have check and find that the table have NVARCHAR field. I try to change the field type to VARCHAR, refresh the table link, then the data can be viewed again. Current Solution: 1. Delete the user profile and login again. Solve the problems but not sure if it will happen again in the future. 2. Installing Access Runtime. Solve the problems but at the same time i can't debug the program if there something wrong with it. Does anyone have any idea what happen because i am really lost right now.
