Microsoft Access Subforms: The Key to Displaying Access Data from More than One Table Want to take a deep dive into Microsoft Access? Consider enrolling in one of our in-person, full-day Access 2013 training classes presented in Austin, Texas. All classes are instructor-led, encourage interaction and questions, and provide hands-on exercises and learning aids. A frequent question asked in our Access classes concerns how to display the data in a form when[…]
READ MORE about Access 2013 Tip: Creating a SubformMicrosoft Access
Add an Access Date/Time Stamp to a Table
Adding an Access Date/Time Stamp In some Microsoft Office Access tables, it’s important to keep track of the date or the date and time when a new record is added. This is often referred to as a date or time stamp. If you find yourself constantly entering whatever today’s date is in your Access forms or tables, you are wasting valuable time. Access can do that for you, and you don’t[…]
READ MORE about Add an Access Date/Time Stamp to a TableAccess 2010 – Printing Labels
Labels are necessary for every office whether it’s for labeling file folders or creating mailing labels fordirect mail campaigns. However, it can be tedious and time-consuming to re-type labels every time you need them. Microsoft Access provides a label creator that can be used to design labels for any use in an easy and efficient manner. Open the Access database containing the information you wish to include on your labels.[…]
READ MORE about Access 2010 – Printing LabelsAccess Tip – Include Attachments in a Database
There are times when it can be beneficial to add a file to your database such as documents, presentations and images. With Access, you can use attachments to store several files of various types in a single field. For example, if you manage a vendor database, you can attach the vendor’s logo as well as their pricing sheet. Add an attachment field in Design View To use attachments in Access,[…]
READ MORE about Access Tip – Include Attachments in a DatabaseAccess Tip: Create Shortcut Keys for Aligning Controls on an Access Form
One of the most time consuming activities in Access involves positioning and aligning controls on a form. Try the following example to create a Macro that provides simple shortcut keys for aligning controls. Create a new Macro and save it with the name AutoKeys. Make the Macro Name column visible by clicking View > Macro Names on the menu. In the first row of the Macro Name column, enter ^L[…]
READ MORE about Access Tip: Create Shortcut Keys for Aligning Controls on an Access FormAccess Tip: Display Blank Cells instead of Zeros
Interested in Access Training? Check out our Course List to view course outlines! For more information about Access training, please call (512) 794-8440 or please fill out our Pricing Request Form and we will contact you with more information. Mention this ad on your registration for $20 off! When you use the Number data type for a field in a table, Access automatically assigns zero ( 0 ) to the[…]
READ MORE about Access Tip: Display Blank Cells instead of ZerosAccess Tip: Using the AutoNumber Data Type in Access
The AutoNumber data type automatically generates a unique number for each record that’s added to a table, and is commonly used for primary key fields. Seldom, if ever, should the value of the AutoNumber field be shown to your database users. If the value of the AutoNumber field is relevant to your Access forms and reports, then it may be that you shouldn’t be using the AutoNumber type, since there[…]
READ MORE about Access Tip: Using the AutoNumber Data Type in Access