Laurie Ulrich Fuller

Access 2016 makes managing data easy, enabling you to set up a database quickly, enter records into that database, and then use the data however you like. With Access 2016, you can organize data into tables, design forms for editing and reports for presenting, and create queries for finding information!Navigating the Access 2016 Ribbon with Key TipsIf you like keyboard shortcuts when you’re working with software, Access 2016 has a Key Tips feature that can help make entering data move more quickly.

With Access' Query Wizard, you enter table and field information, and the Simple Query Wizard takes care of the rest. Here's how you create a query: On a piece of paper, lay out the data you want in your query results. A query returns a datasheet (column headings followed by rows of data), so make your layout in that format.

If you want the database in which you’re placing the data to replace the source in Access 2016, then import. This is the option for you if you’re creating an Access database to replace an old spreadsheet that no longer meets your needs. Also import if the source data is supplied by an outside vendor in a format other than an Access format.

Adding a forgotten field to your table in Access 2016 is as easy as stopping by the store to pick up forgotten milk. No need for angry words. With the field-challenged table open, calmly follow these steps to add the field you’re missing:In Datasheet view, find the field heading aptly called Click to Add.The column is typically placed at the end of your existing fields — so be prepared to scroll all the way to the end to see it.

When you open Access 2016, the workspace offers you a list of recently opened databases, along with templates you can use to start a new database. To open a database from the Recent Databases list, just point to it and click once. If you remember where your database is stored, but it isn’t in the Recent list, use either of the following options to use the Open view:Click the File tab to the left of the Home tab, and choose Open Other Files from the list of commands.

So you want to dive in and start building a database in Access 2016? Keep in mind that it’s a good idea to take it slowly. In the following procedure, you set up a new database and then use the Table Wizard to build the first table in the database. If Access is not already running, take a moment to start it. In the Access workspace, a series of large template icons appears, below a Search for Online Templates box, accompanied by links to likely searches for templates that store Assets, Business, Contacts, Employee, and so on.

You can create a web app in Access 2016. So what is a web app anyway? Well, web means it’s online, and app is just shorthand for “application.” A Custom Web App is an online database application accessed from the cloud using a browser. You build and maintain the web app in the desktop version of Access but use it in a browser.

If you like keyboard shortcuts when you're working with software, Access 2016 has a Key Tips feature that can help make entering data move more quickly. The following section describes how to use it: Press the Alt key. When you want to switch tabs and issue commands with the keyboard in Access 2016 (rather than with the mouse), press the Alt key.

The following keyboard shortcuts are especially useful in Access 2016. Some keystrokes work anywhere in Access 2016, whereas others work only in specific views, as noted below. Keystroke Function F1 Opens the Help window. Alt+F Opens the File tab. Ctrl+N Creates a new blank database. Ctrl+O Opens an existing database.