-
Adding Charts to Reports
In Microsoft Access 2010; you can include charts in reports to display table data in a visual format; such as on a graph. In this video; Steve English adds a pie chart to a report to display the proportion and total sales for each product category in a query.
-
Apply Conditional Formatting to a Report
Conditional Formatting in Microsoft Access 2010 changes the way report elements look when they meet certain criteria or conditions. In this video; Steve English shows you how to instantly draw your reader’s attention to the text you want noticed by configuring and doing conditional formatting on your report.
-
Compact and Repair a Database
You can use the Compact and Repair feature in Microsoft Access 2010 to reduce the file size of a database. In this video; Steve English uses the Compact and Repair feature to compress a database so that it has a smaller file size.
-
Create a Crosstab Query
In Access 2010 you can create a Crosstab query that looks and behaves like a spreadsheet. In this video; Steve English will demonstrate how to get data into the spreadsheet format so you can manipulate the data and perform calculations.
-
Create a Data Macro
You can create data macros in Access 2010 that are triggered by specific events in the database. In this video; Steve English will demonstrate how to create data macros in Access 2010.
-
Create a Find Duplicates Query
In Microsoft Access 2010; you can use queries to find particular records or types of records in a database. In this video; Steve English creates a Find Duplicates query that counts records that appear more than once in a Sales table to find out how many items have been sold for each product.
-
Create a Find Unmatched Query
You can use a Find Unmatched query in Microsoft Access 2010 to find records in one table that do not appear in another table. In this video; Steve English uses the Query Wizard to create a Find Unmatched query that finds records in a product table that do not appear in a sales table.
-
Create a Primary Key
Access 2010 will automatically create a key in a primary table; but you can create your own primary key instead. In this video; Steve English will demonstrate how to create a primary key in Access 2010.
-
Create a Subreport
The Subreport tool in Microsoft Access 2010 allows you to combine information from several different reports into one. In this video; Steve English shows you how to create a contextual subreport using the Subreport Wizard.
-
Create a Table in Datasheet View
The Datasheet View in Microsoft Access 2010 makes creating a table quicker and easier. In this video; Steve English explains how to do it all—add fields; select data type; and set field properties—without ever switching to the Design View.
-
Create a Table Index
Microsoft Access 2010 allows you to create a table index to speed up your sorts and searches; such as an index on the phone field in an employee list. In this video; Steve English shows you how to create an index and discusses what data types and index properties to select.
-
Create a UI Macro
In Access 2010 you can create a user interface macro that responds to an action taken by a user; such as clicking a button. In this video; Steve English will demonstrate how to create a user interface macro in Access 2010.
-
Create and Edit Joins
You can use joins in Microsoft Access 2010 to define the relationship between fields in different tables. In this video; Steve English creates and modifies a join between fields in two tables; and explores the effect of different join types on a query.
-
Create and Modify a Select Query
You can use queries in Microsoft Access 2010 to return related fields from different tables. In this video; Steve English uses the Query Wizard to create and modify a SELECT query to show related human resources fields from three tables.
-
Create Validation Rules
Validation Rules in Microsoft Access 2010 allows you to set specific formats or ranges for your data fields and guide users when entering data. In this video; Steve English shows you how to create rules to restrict and permit the data entered.
-
Creating Pivot Tables
A Pivot Table in Microsoft Access 2010 can be used to calculate and display multiple dimensions of query data in an interactive chart. In this video; Steve English creates a Pivot Table and performs operations on it to show a graph of products and calculated sales figures over time; with the results filtered by product category.
-
Customizing Lookup Fields
In Microsoft Access 2010; you can use lookup fields in a table to allow users to select from any of several values. In this video; Steve English creates a lookup field that allows you to select a computer manufacturer from a list.
-
Filter Records
The Filter function in Microsoft Access 2010 makes it easy to find specific values; such as products in a database within a cost range. In this video; Steve English shows you how to filter and display only those records that meet your criteria.
-
Find and Replace Data
Find and Replace is a useful function in Microsoft Access 2010 for searching and replacing data. In this video; Steve English shows you how to restrict your search and keep your data safe from unwanted changes when doing a Replace All.
-
Importing Data from Office
You can easily import data into Microsoft Access 2010 from a number of different data sources; such as Office documents. In this video; Steve English demonstrates how to import table data from a Microsoft Excel spreadsheet.
-
Link to Data in Another Database
You can link an Access 2010 database to another Access database so that they share information in tables. In this video; Steve English will demonstrate how to link two Access 2010 databases.
-
Optimize a Database with Table Analyzer
You can use the Access 2010 Table Analyzer to examine your database for inefficiencies and it will recommend how to restructure the database so that it runs as fast as possible. In this video; Steve English will demonstrate how to use the Access 2010 Table Analyzer to make your databases run more efficiently.
-
Refine a Query Using Groupings
In Microsoft Access 2010 you can arrange data in a report into groups to make it more meaningful and to provide summary information. In this video; Steve English uses the Grouping feature to group and sort products in a report into their categories; and to provide a calculated total field for each group.
-
Secure a Database
You can secure an Access 2010 database so that only the people you want to have access to the data have access. In this video; Steve English will demonstrate how to secure an Access 2010 database.
-
Secure an Access Database
By default; when you open a database in Microsoft Access 2010; you get a security warning to prevent VBA macros from being activated. To avoid this; you can create trusted locations. In this video; Steve English configures a folder on his hard disk as a trusted location to prevent Windows from blocking active content in files that are stored there.
-
Sort Records
The Sort function in Microsoft Access 2010 allows you to arrange and rearrange table and query records anyway you like. In this video; Steve English demonstrates how to sort a table by single and multiple fields.
-
Use a Predefined Input Mask for a Table Field
You can create an input mask for table fields in Access 2010 so that users are faced to enter data in a specific format. In this video; Steve English will demonstrate how to create an input mask for table fields in Access 2010.
-
Use Object Prefixes
In Microsoft Access 2010; following a good naming convention will be useful for those who inherit the task of maintaining your database and for you when you resume work on it after a while. In this video; Steve English explains how using appropriate prefixes makes the database object type obvious.
-
Create a Subform
In Access 2010 subforms can be nested within another form. In this video; Steve English will demonstrate how to create subforms in Access.