Create Input Masks in Access – Instructions

A picture of the “Input Mask Wizard” in Access you use to create input masks in Access.
Overview of Creating Input Masks in Access             You can create input masks in Access for table fields to dictate a pattern to use for data entry in the fields. You can manually create input masks for most text, date, and number data type fields in Access, except the “Long Text” data type. Access also
Read more
No Comments

Select Controls in Access- Instructions

Select Controls in Access: A picture of a user selecting multiple controls in Access.
Overview of Selecting Controls in Access             When placing controls into forms and reports in design view, you often need to select the controls. In this lesson, you will look at the ways that you can select controls in Access.             To select a control in Access, click the control you want to select. When
Read more
No Comments

Export Data from Access – Instructions

A picture that shows how to export data from Access for Microsoft 365 to Excel.
Overview of Exporting Data from Access             You can easily export data from Access to a wide variety of formats that are available. You can also export other database objects, like forms and reports. However, there are more limitations on the formats to which these types of objects can be exported.             To export data
Read more
No Comments

Aggregate Function Queries in Access – Instructions

A picture of a user creating an aggregate function query in Access.
Overview of Aggregate Function Queries in Access             Aggregate function queries in Access let you create summary queries that perform a mathematical function, called an “aggregate function,” on a field, based on groups of values found in another grouped query field or grouped query fields. These are usually shorter queries, often used for reporting.            
Read more
No Comments

Create a Data Model from External Relational Data in Excel – Instructions

Create a Data Model from External Relational Data in Excel - Instructions: A picture of a user selecting the external relational data tables to add to the data model in an Excel workbook by using the “Select Table” dialog box.
Create a Data Model from External Relational Data in Excel: Overview             You can create a data model from external relational data in Excel. Data models in Excel let you store multiple tables of information. They can then be used a data source for PivotTables, PivotCharts, and Power View reports.             The choice to add
Read more
No Comments

Use Data Entry Forms in Access- Instructions

Use Data Entry Forms in Access- Instructions: A picture of the “New (blank) record” button within a data entry form in Access.
Use Data Entry Forms in Access: Overview             After creating data entry forms, you can use data entry forms in Access to edit, create, and navigate table records. Navigating within a data entry form is exactly like navigating through records in the datasheet view of a table.             You can use the “Tab” key on
Read more
No Comments

Use the Field List in Access – Instructions

Use the Field List in Access - Instructions: A picture of the Field List in Access.
Use the Field List in Access: Overview             You can use the Field List in Access to easily add data fields to a data entry form. Most forms are connected to an underlying table or query from which they display and/or update the table data. In form design view, you can access the list of
Read more
No Comments

Microsoft Office 2016 Released 9-22-15- News

Microsoft Office 2016 Released 9-22-15- News: A picture of the Office 2016 product page. Source: Microsoft.
Microsoft Office 2016 Released 9-22-15: Product Information             Microsoft Office 2016 has been released to the public as of 9/22/15. This means that Office 2016 is now available for both Windows and OSX operating systems. It is also available for all Office 365 subscribers.             Users of Office 365 can install the latest Office 2016
Read more
No Comments