Microsoft Access 2013 New Features Overview
Applies to: Microsoft Access 2013 for Windows
If you’re considering upgrading to Microsoft Access 2013 before attending a training course or arranging custom training, check out this list of some of the new features in Access 2013.
Interested in another version? Check out the following:
Looking for Microsoft Access training courses?
The following are some of the key new features available in Microsoft Access 2013.
New Look and Feel
In Access 2013, the interface has a new look and feel, particularly related to animated actions of the mouse and interactions with the Ribbon.
Navigating using the Action Bar
There are now new navigation tools including an Action Bar and you can can customize the Action Bar.
Built-in Searching and Filtering
Access provides a list view which always shows the search box with a list of records. You don’t need to write code to make it easy for users to search. Users can simply click on a record to view the details. You don’t need to create a search form with code behind it.
Easily Hide Tables
In Access 2013, when you add a table, a new tab appears and you have the option to hide it.
Create Lookups Easily
The lookup interface has been improved and makes it easy to build foreign keys. In older versions, lookup fields required several steps in the lookup wizard to set up the lookup. This wizard is now a single step and the descriptions are easier to follow so that a user who never has heard of things like “foreign key constraint” and “normal form” can create lookups.
Related Lookup Behaviour
If a record has a lookup field on it, it can be displayed as a hyperlink which can be used to pop open a form showing the details of the related record. There are also related item controls which makes it every easy to drill through information. No programming is required.
Pop-up Properties Window
In Access 2013, you can now enter properties in a pop-up window rather than searching for properties.
Enhanced Theme Options
There are new theme options in Access 2013 to improve formatting and get a consistent look and feel.
Several new templates have been added in 2013 including templates for tables.
Deploy Databases on the Web with Web Apps
Access 2013 now allows you to build a web app database. You can add and edit data in a web app database, share it and publish a desktop database to the web.
If you set up a subscription account, it’s fairly simple and inexpensive to deploy a web application (rather than setting up your own web server).
SQL Server Backend
SQL (Structured Query Language) is in the background. SQL Server is now on the backend which will allow for easy upsizing of databases. Both desktop Access applications and web applications use the same SQL Server backend and achieve consistency this way. You can also use SQL Server Reporting Services, Excel or any other tools that supports connecting to SQL.
Our instructor-led courses are delivered in virtual classroom format or at our downtown Toronto location at 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada (some in-person classroom courses may also be delivered at an alternate downtown Toronto location). Contact us at firstname.lastname@example.org if you'd like to arrange custom onsite training or an online course on a date that's convenient for you.
LIve or virtual classroom training
Related Access courses
You may like
You can highlight values in fields or records in Microsoft Access reports using conditional formatting. Certain conditions must be met in order for the formatting to be applied …
You can create calculated fields in select queries in Microsoft Access in the QBE (Query by Example) grid. You’ll need to learn a few syntax rules and then you can create simple to more complex calculations.
You may also like
Starting in Microsoft PowerPoint 2013, you can use the Merge Shapes tool to crop an image to a circle. You can use either Intersect or Subtract to cut out a circle (or other shape) from a picture.
You can quickly replace blank cells in Excel with zeros, dashes or other number or text values (0, -, N/A, Null or other text). It’s useful to fill blank cells with a number, symbol or value if you want to use the data set as the source for a pivot table or use other data analysis tools.
The outline has been an integral part of Microsoft PowerPoint for many years. It is dynamically linked to slide placeholders and is organized in a hierarchical way.
Microsoft, the Microsoft logo, Microsoft Office and related Microsoft applications and logos are registered trademarks of Microsoft Corporation in Canada, US and other countries. All other trademarks are the property of the registered owners.
Avantix Learning | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | email@example.com