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
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
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
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.
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
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
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
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