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.

1. Microsoft Access 2013 Tutorial For Beginners
2. Microsoft Access 2013 Free Download

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

If you agree, we’ll also use cookies and data to:

• 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

For non-personalized content and ads, what you see may be influenced by things like the content you’re currently viewing and your location (ad serving is based on general location). Personalized content and ads can be based on those things and your activity like Google searches and videos you watch on YouTube. Personalized content and ads include things like more relevant results and recommendations, a customized YouTube homepage, and ads that are tailored to your interests.

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:

  1. Select File > Options > General
  2. 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:

1. Select External Data > Linked Table Manager.
2. A dialog will appear showing you all linked data sources. Select the data sources you want to list and click Export to Excel
3. 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).