--- title: 5 Tips and Tricks to Take Advantage of When Using Microsoft Access description: 5 Tips and Tricks to Take Advantage of When Using Microsoft Access image: https://ontimetech.valeonetworks.com/hubfs/Blog%20Images/Imported_Blog_Media/Microsoft-Access-1.jpg --- [Skip to the main content.](https://ontimetech.valeonetworks.com/blog/tech-tips/5-tips-and-tricks-to-take-advantage-of-when-using-microsoft-access#main-content) [![OTT powerd by VN big](https://ontimetech.valeonetworks.com/hs-fs/hubfs/OTT%20powerd%20by%20VN%20big.png?width=500&height=175&name=OTT%20powerd%20by%20VN%20big.png "OTT powerd by VN big")](https://ontimetech.valeonetworks.com) [![OTT powerd by VN big](https://ontimetech.valeonetworks.com/hs-fs/hubfs/OTT%20powerd%20by%20VN%20big.png?width=500&height=175&name=OTT%20powerd%20by%20VN%20big.png "OTT powerd by VN big")](https://ontimetech.valeonetworks.com) - [Services](https://ontimetech.valeonetworks.com/our-services/) - [Managed It Services](https://ontimetech.valeonetworks.com/our-services/managed-it/) - [Cybersecurity](https://ontimetech.valeonetworks.com/our-services/cybersecurity/) - [Cloud Solutions](https://ontimetech.valeonetworks.com/our-services/cloud-solutions/) - [Compliance](https://ontimetech.valeonetworks.com/our-services/compliance/) - [Industries](https://ontimetech.valeonetworks.com/industries/) - [Resources](https://ontimetech.valeonetworks.com/resources/) - [Blog](https://ontimetech.valeonetworks.com/blog) - [About](https://ontimetech.valeonetworks.com/about/) - [Client Testimonials](https://ontimetech.valeonetworks.com/testimonials/) [415-294-5250](tel:4152945250) [Client Portal](https://portal.Valeonetworks.com) Toggle Menu Toggle Menu [415-294-5250](tel:4152945250) [Client Portal](https://portal.Valeonetworks.com) - [Services *Toggle Menu*](https://ontimetech.valeonetworks.com/our-services/) - [Managed It Services](https://ontimetech.valeonetworks.com/our-services/managed-it/) - [Cybersecurity](https://ontimetech.valeonetworks.com/our-services/cybersecurity/) - [Cloud Solutions](https://ontimetech.valeonetworks.com/our-services/cloud-solutions/) - [Compliance](https://ontimetech.valeonetworks.com/our-services/compliance/) - [Industries](https://ontimetech.valeonetworks.com/industries/) - [Resources *Toggle Menu*](https://ontimetech.valeonetworks.com/resources/) - [Blog](https://ontimetech.valeonetworks.com/blog) - [About *Toggle Menu*](https://ontimetech.valeonetworks.com/about/) - [Client Testimonials](https://ontimetech.valeonetworks.com/testimonials/) - Example Link - Example Link - Example Link [*Facebook*](https://ontimetech.valeonetworks.com/blog/tech-tips/5-tips-and-tricks-to-take-advantage-of-when-using-microsoft-access#0) [*Instagram*](https://ontimetech.valeonetworks.com/blog/tech-tips/5-tips-and-tricks-to-take-advantage-of-when-using-microsoft-access#0) [*LinkedIn*](https://ontimetech.valeonetworks.com/blog/tech-tips/5-tips-and-tricks-to-take-advantage-of-when-using-microsoft-access#0) [*Twitter*](https://ontimetech.valeonetworks.com/blog/tech-tips/5-tips-and-tricks-to-take-advantage-of-when-using-microsoft-access#0) [*Youtube*](https://ontimetech.valeonetworks.com/blog/tech-tips/5-tips-and-tricks-to-take-advantage-of-when-using-microsoft-access#0) [*Medium*](https://ontimetech.valeonetworks.com/blog/tech-tips/5-tips-and-tricks-to-take-advantage-of-when-using-microsoft-access#0) 2 min read # 5 Tips and Tricks to Take Advantage of When Using Microsoft Access [Lance Stone](https://ontimetech.valeonetworks.com/blog/author/ulisticadmin) : Apr 13, 2015, 6:18:16 AM [Managed IT Services](https://ontimetech.valeonetworks.com/blog/tag/managed-it-services) ## We’ve said it before – if your technology isn’t helping you to streamline work, it’s not doing its job. ![Microsoft Access](https://ontimetech.valeonetworks.com/hs-fs/hubfs/Blog%20Images/Imported_Blog_Media/Microsoft-Access-1.jpg?width=488&height=350&name=Microsoft-Access-1.jpg) Tools and solutions provided by your IT company should not only be improving the quality of your output, but also making your day-to-day workload a bit easier. When you’re using Microsoft Access to complete tasks, there are more than a few tips and tricks you can take advantage of to get work done faster and with even better results. - **Get Your App Online** A fantastic feature present in Access is how easily you can release databases for others to view on the web. That process is made even easier by Microsoft’s SharePoint Online – it’s part of the Office 365 suite. Even more beneficial? The people you’re sharing the app with can use any web browser to access it. You can use the templates in office to create a database, then click into Access’ Backstage View and select “Publish to Access Services”. Under Server URL enter the full address of your online SharePoint server. Once you enter the info for the SharePoint site, Access will sync the app and display the URL. - **Hide the Ribbon** Many users find the “Ribbon” in Access to be a bit irritating. Luckily, it’s relatively easy to hide it and it doesn’t involve a whole lot of steps. You can minimize the ribbon by double-clicking on one of the tabs – it’s as simple as that, and Access remembers your preference for future sessions. - **Three Tabs for All Your Needs** There are three tabs that hold almost all the power in Access – Home, Create and Design. The Create tab holds all the options for creating new tables, queries, forms and so one. The Design tab lets you work with newly-created objects, turns a SELECT query into an UPDATE query and drops controls onto your form. Once you’ve set controls, the Home tab allows you to apply formatting. You’ll find the usual run-time options there such as form filtering and sorting a datasheet. -  **Convert Reports to PDFs** No need to seek out third parties to help you convert documents or reports to PDFs – Access now incorporates PDF support meaning you can easily save a file as a PDF with just a few easy clicks. Go to File, Save and Publish, Save Object As, PDF or XPS and Save As. It’s that simple! - **Customize Your Quick Access Toolbar** It can be a bit confusing navigating through all your options (there are plenty) – that is, unless you add tasks to the Quick Access Toolbar. You can add printing, print preview and tons of other options to the toolbar so that everything is doable in one click rather than 3 or 4. **To learn more helpful IT tips and tricks, get in touch with the best technology team in {city} – contact {company} at {email} or by phone at {phone}.** - [Tweet](https://twitter.com/share) #### ![BusinessOwnerGuidetoM&A-1](https://ontimetech.valeonetworks.com/hs-fs/hubfs/BusinessOwnerGuidetoM%26A-1.png?width=303&height=209&name=BusinessOwnerGuidetoM%26A-1.png) #### Download our eBook*THE ULTIMATE ROADMAP TO CMMC COMPLIANCE* by filling out the form below! [![The Top 6 Twitter Tips and Tricks to Help You Increase Your Followers](https://ontimetech.valeonetworks.com/hubfs/Blog%20Images/Imported_Blog_Media/twitter-3.jpg)](https://ontimetech.valeonetworks.com/blog/uncategorized/the-top-6-twitter-tips-and-tricks-to-help-you-increase-your-followers) #### [The Top 6 Twitter Tips and Tricks to Help You Increase Your Followers](https://ontimetech.valeonetworks.com/blog/uncategorized/the-top-6-twitter-tips-and-tricks-to-help-you-increase-your-followers) [Lance Stone](https://ontimetech.valeonetworks.com/blog/author/ulisticadmin) : Apr 14, 2014, 3:16:15 PM Twitter can help you connect with customers, prospects, and other businesses. Twitter also enables you to track industry news, product introductions,... [Managed IT Services](https://ontimetech.valeonetworks.com/blog/tag/managed-it-services) [Read More](https://ontimetech.valeonetworks.com/blog/uncategorized/the-top-6-twitter-tips-and-tricks-to-help-you-increase-your-followers) [![On Time Tech Proud to Be Featured on Global List of Top Technology Companies](https://ontimetech.valeonetworks.com/hubfs/Blog%20Images/Imported_Blog_Media/San-Francisco-IT-Support-1024x537-1.png)](https://ontimetech.valeonetworks.com/blog/top-technology-companies) #### [On Time Tech Proud to Be Featured on Global List of Top Technology Companies](https://ontimetech.valeonetworks.com/blog/top-technology-companies) [Lance Stone](https://ontimetech.valeonetworks.com/blog/author/ulisticadmin) : Jul 11, 2017, 8:02:03 AM The team of IT experts at On Time Tech is thrilled to announce that they have been named to Penton Technology’s 2017 MSPmentor 501 Global Editionat... [Managed IT Services](https://ontimetech.valeonetworks.com/blog/tag/managed-it-services) [Read More](https://ontimetech.valeonetworks.com/blog/top-technology-companies) [![This CEO Has The Coolest Tech Toys – Take a Look!](https://ontimetech.valeonetworks.com/hubfs/Blog%20Images/Imported_Blog_Media/ThinkstockPhotos-508137942.jpg)](https://ontimetech.valeonetworks.com/blog/this-ceo-has-the-coolest-tech-toys-take-a-look) #### [This CEO Has The Coolest Tech Toys – Take a Look!](https://ontimetech.valeonetworks.com/blog/this-ceo-has-the-coolest-tech-toys-take-a-look) [Lance Stone](https://ontimetech.valeonetworks.com/blog/author/ulisticadmin) : Mar 28, 2018, 12:18:00 PM It happens to all of us at some point – you’re sitting by someone who whips out this über cool gadget, and you can’t take your eyes off of it. You... [Managed IT Services](https://ontimetech.valeonetworks.com/blog/tag/managed-it-services) [Read More](https://ontimetech.valeonetworks.com/blog/this-ceo-has-the-coolest-tech-toys-take-a-look) ![OTT White logo](https://ontimetech.valeonetworks.com/hs-fs/hubfs/VN%20-%20Division%20Logos/OTT%20Logo/OTT%20White%20logo.png?width=524&height=140&name=OTT%20White%20logo.png)   ##### About About On Time Tech is an IT Support and Computer Services company serving California. We provide services to the areas in and around We know businesses like yours need technology support in order to run highly-effective organizations. Leverage pro-growth technology services for your company now. ##### Explore On Time Time Explore On Time Time - [Our Services](https://ontimetech.valeonetworks.com/our-services/) - [Industries](https://ontimetech.valeonetworks.com/industries/) - [Resources](https://ontimetech.valeonetworks.com/resources/) - [About](https://ontimetech.valeonetworks.com/about/) - [Contact](https://ontimetech.valeonetworks.com/contact/) ##### Contact Contact **San Francisco:** 1717 Fifth Ave San Rafael, CA 94901 [415-294-5250](tel:4152945250) Business Hours: M-F: 8AM-9PM - [Privacy Policy](https://ontimetech.valeonetworks.com/privacy-policy/) © 2026 On Time Tech [*Facebook*](https://www.facebook.com/ontimetechsf/)[*Twitter*](https://twitter.com/on_time_tech?lang=en)[*LinkedIn*](https://www.linkedin.com/company/ontimetech/)[*YouTube*](https://www.youtube.com/channel/UCubqs9PU_WWF-RFhfK9xNpw) [![Alura White logo](https://ontimetech.valeonetworks.com/hs-fs/hubfs/VN%20-%20Division%20Logos/Alura%20White%20logo.png?width=295&height=115&name=Alura%20White%20logo.png)](https://alura.valeonetworks.com/) [![Next.I.T._White-Logo](https://ontimetech.valeonetworks.com/hs-fs/hubfs/Next.I.T._White-Logo.png?width=328&height=136&name=Next.I.T._White-Logo.png)](https://next-it.net/) [![White-OTT-Logo-1-768x253](https://ontimetech.valeonetworks.com/hs-fs/hubfs/White-OTT-Logo-1-768x253.png?width=313&height=103&name=White-OTT-Logo-1-768x253.png)](https://www.ontimetech.com/) [![Valeo-Logo-White (1)](https://ontimetech.valeonetworks.com/hs-fs/hubfs/Valeo-Logo-White%20(1).png?width=288&height=123&name=Valeo-Logo-White%20(1).png)](https://valeonetworks.com/) *Return to Top* ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Lance Stone", "url" : "https://ontimetech.valeonetworks.com/blog/author/ulisticadmin" }, "dateModified" : "2024-01-10T16:23:18.996Z", "datePublished" : "2015-04-13T10:18:16.000Z", "headline" : "5 Tips and Tricks to Take Advantage of When Using Microsoft Access", "image" : [ "https://ontimetech.valeonetworks.com/hubfs/Blog%20Images/Imported_Blog_Media/Microsoft-Access-1.jpg" ], "mainEntityOfPage" : { "@id" : "https://ontimetech.valeonetworks.com/blog/tech-tips/5-tips-and-tricks-to-take-advantage-of-when-using-microsoft-access", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://ontimetech.valeonetworks.com/hubfs/OTT%20-%20Color%20Logo.png" }, "name" : "Valeo Networks" } } ```