Laurie Ulrich Fuller

Articles & Books From Laurie Ulrich Fuller

Cheat Sheet / Updated 03-10-2022
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.
Step by Step / Updated 03-27-2016
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.
Step by Step / Updated 03-27-2016
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.
Step by Step / Updated 03-27-2016
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.
Article / Updated 03-26-2016
Every Access 2016 object can be exported; the most common export tasks are exporting data in a table or query to another program (such as a spreadsheet) and exporting a report as a Portable Document Format (commonly known as a PDF). Exporting a table or query involves reorganizing the data it contains into a different format.
Article / Updated 03-26-2016
If you want to build a table relationship in Access 2016, you must first open the Relationships window. You do that by following these steps: Click the Database Tools tab on the Ribbon. The Relationships group appears on the Ribbon. From the Relationships group, click the Relationships button. The Relationships window appears along with the Show Table dialog box.
Article / Updated 03-26-2016
Access 2016 provides a handy list of table designs for you to choose from if you’re starting your web app from scratch. Here are the simple steps for adding a table: Click Table from the Create group on the Home tab of the Ribbon if necessary (you’ll be here by default after creating a new web app). Type a keyword in the search box that represents the type of data to go into your table.
Article / Updated 03-26-2016
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.
Article / Updated 03-26-2016
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.
Article / Updated 03-26-2016
Access has some great wizards that make the importing process easy. Here are the steps for importing or linking data sources to your Access database: Open the Access database that will hold the imported data and click the External Data tab on the Ribbon. The Import & Link group of buttons appears on the Ribbon.