Data Visualizations in Power View in Excel – Instructions

Data Visualizations in Power View in Excel - Instructions: A picture of the “Design” tab within Power View in Excel.
Data Visualizations in Power View in Excel: Overview             You can visualize report data in a Power View worksheet by adding data visualizations in Power View in Excel. To add data visualizations in Power View in Excel, drag a data field from the “Power View Field” task pane into the “Fields” section of the task
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

Report Tables in Project 2013 – Tutorial

Report Tables in Project 2013 – Tutorial: A picture of a report table and its associated Field List pane in Microsoft Project 2013.
Report Tables in Project 2013: Overview             Report tables in Project 2013 differ from tables in other Office applications, like Word, in that you cannot manually add information to them. Report tables in Project 2013 simply display selected information about the project. Report tables in Project 2013 use a data source for their display of
Read more
No Comments

Access or Excel DAO in Crystal Reports 2013- Tutorial

Access or Excel DAO in Crystal Reports 2013- Tutorial: A picture of the
Access or Excel DAO in Crystal Reports 2013: Overview             You can use Access or Excel DAO in Crystal Reports 2013 to connect an Access database or Excel workbook to a report. If you click the small plus sign next to the “Access/Excel (DAO)” folder in the “Create New Connection” section of the “Database Expert,”
Read more
No Comments

Connect to Database Files in Crystal Reports 2013- Tutorial

Connect to Database Files in Crystal Reports 2013- Tutorial: A picture of a user connecting to a database file in Crystal Reports 2013.
Connect to Database Files in Crystal Reports 2013: Overview             If you click the small plus sign next to the “Database Files” folder in the “Create New Connection” section of the “Database Expert,” you will be presented with the “Open” dialog box. You use this dialog box to create a data connection to one of
Read more
No Comments

Microsoft Access 2013: The Flat File Method of Data Storage

Access is a relational database application. So what does the term relational mean, and how is this important? The term relational describes the method used for storing data within the database tables. However, it may be easier to understand the relational model of data storage by contrasting it with another method of storage that you
Read more
No Comments

Using Flash Fill in Microsoft Excel 2013

Click here for the complete Excel training             Starting in Excel 2013, you can use the “Flash Fill” feature to automatically fill-in values within a column with information entered into an adjacent column. This feature is most useful when dealing with data that has a consistent data entry pattern in
Read more
No Comments