Click: clip from Mastering Microsoft Access Made Easy: how to use indexes. Get a FREE demo of our training for. Microsoft Access 2013. MS 2013 You can collect data. Microsoft Access 2013 also manages data management as before. However, Microsoft Access 2013 is designed just like any other Access. For example, Microsoft Access 2013 has been updated. Today, Microsoft Access 2013 includes a variety of features. Microsoft Office 2013. Microsoft Office 2013 follows the Fixed Lifecycle Policy. This applies to the following editions: Home and Business, Home and Student, Multi Language Pack, Professional, Professional Plus, Professional Plus Home Use Program, Standard, Web Apps Server. Access for Microsoft 365 Access 2019 Access 2016 Access 2013 Access 2010 Access 2007 More. Less In Access desktop databases you can use the DLookup function to get the value of a particular field from a specified set of records (a domain). In this video playlist, you’ll get to know the functions and features of Access 2013. Visit for our text-based tutor.
Google uses cookies and data to:- Deliver and maintain services, like tracking outages and protecting against spam, fraud, and abuse
- Measure audience engagement and site statistics to understand how our services are used
- Improve the quality of our services and develop new ones
- Deliver and measure the effectiveness of ads
- Show personalized content, depending on your settings
- Show personalized or generic ads, depending on your settings, on Google and across the web
Click “Customize” to review options, including controls to reject the use of cookies for personalization and information about browser-level controls to reject some or all cookies for other uses. You can also visit g.co/privacytools anytime.
There's not much difference between Microsoft Access 2013 and Microsoft Access 2016. If you've been using Access 2013 you might be struggling to find any difference between that version and the 2016 version.
Below are new features added in 2016. Actually, it could be argued that most of them aren't even 'features' and simply 'differences' but in any case, here's what's new in MS Access 2016.
Look and Feel... Slightly Different
Access 2016 has the same look and feel as 2013. There are only two minor differences between the two versions.
- In Access 2016, the top menu has a background color applied to it. This helps the top menu stand out a bit more. In Access 2013, there was no difference between the color of this menu and rest of the screen.
- In Access 2016, there are two Microsoft Office themes that can be used with Access; 'Colorful' and 'White'.
To change the theme:
- Select File > Options > General
- Select your desired theme from the Office Theme drop down menu
New 'Tell Me' Box
Possibly the most useful feature introduced in Access 2016 is the 'Tell Me' box.
The Tell Me box allows you to tell Access what you want to do. It looks like a search input field with a little light-bulb icon next to the text 'Tell me what you want to do...'.
When you type anything in the Tell Me box, a dropdown list will appear with features or actions related to what you're typing — similar to a autosuggest dropdowns on search engines.
For example, typing 'print' will result in a list of printing-related menu items (such as Print, Print Preview, Get Help on 'print') dynamically appearing as you type. Selecting an item from the Tell Me box does the same thing as selecting that same item from its normal menu (eg, clicking Print Preview opens the Print Preview screen).
One of the great things about the Tell Me box is that it remembers what you typed in previously. So whenever you click on the Tell Me box you can see a list under the heading Recently Used that you can select from if you wish. This has the potential to save a lot of time, especially if you need to perform the same actions over and over again.
Exporting Data to Excel
Access 2016 allows you to easily export all your linked data to Microsoft Excel 2016 from a single dialog. This is available from the Linked Table Manager dialog.
To open this dialog:
- Select External Data > Linked Table Manager.
- A dialog will appear showing you all linked data sources. Select the data sources you want to list and click Export to Excel
- At the prompt, select a location to save the Excel workbook
Once you've saved the Excel workbook, Access will display the workbook with the linked data sources.
Redesigned Database Templates
In Access 2016, the five most popular database templates have been redesigned with a fresh, modern look and feel.
The redesigned templates are:
- Asset tracking
- Contacts
- Event management
- Students
- Task management
These templates are available whenever you go File > New
Larger 'Show Table' dialog
Microsoft Access 2013 Tutorial For Beginners
The height of the 'Show Table' dialog has been increased in Access 2016. This allows for more tables and queries to be shown in the dialog without the need for scrolling or tabbing through the list.
Microsoft Access 2013 Free Download
The Show Table dialog can be opened in queries (using either Create > Query Design or Design > Show Table) and in the Relationships window (using either Database Tools > Relationships or Design > Show Table).