Create a Calculated Field in Access – Instructions

Create a Calculated Field in Access - Instructions: A picture of a calculated field in an Access query.
Create a Calculated Field in Access: Overview             You can easily create a calculated field in Access queries. A calculated field is a field that derives its value by performing a function on values from other table fields. It can also calculate values entered by hand. The field’s data only appears for the duration of
Read more
No Comments

Charts in Access – Instructions and Video Lesson

Charts in Access - Instructions and Video Lesson: A picture of a chart shown in the “Layout View” within Access.
Charts in Access: Overview             You can create charts in Access by using the “Chart Wizard” to add charts to reports. The “Chart Wizard” creates charts that represent data from your queries or tables. There are many chart types available. Charts appear as controls in reports. To add charts in Access to reports, click the
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