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

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

Rename a Field in a Table in Access – Instructions and Video Lesson

Rename a Field in a Table in Access - Instructions: A picture of a user renaming a table field in Access.
Rename a Field in a Table in Access: Overview             You can rename a field in a table in Access that you have already created. You should be extremely careful when you do this! This is because any changes you make to field names are not necessarily updated in all the previously created objects. This
Read more
No Comments

Create a Navigation Form in Access – Instructions

Create a Navigation Form in Access - Instructions: A picture of a user creating a Navigation form in Access.
Create a Navigation Form in Access: Overview             You have the ability to quickly and easily create a Navigation form in Access. A navigation form performs the same function as a switchboard form does within your database. A navigation form contains buttons you click to open other database objects, like reports and forms.             To
Read more
No Comments

Hide a Query Field in Access – Instructions

Hide a Query Field in Access - Instructions: A picture of a hidden field in a query, shown within the query design view in Access.
Hide a Query Field in Access: Overview             You can easily hide a query field in Access. Sometimes when you create queries, you need to add a field to the QBE grid for criteria purposes only. In this case, you don’t want the field itself to appear in the result set. Having additional fields appear
Read more
No Comments

Sort a Query in Access – Tutorial

Sort a Query in Access - Tutorial: A picture of a user sorting a query result set using the buttons in the “Sort & Filter” button group on the “Home” tab in the Ribbon.
Sort a Query in Access: Overview             You can sort a query in Access by any field within the QBE grid when viewing the query in design view. To sort a query in Access when in design view, select the field in the QBE Grid by which to sort the result set. Then click into
Read more
No Comments