Access 2013 Course E-learning Expert

Content: Access 2013 Course E-learning Expert

Datasheet view
Restructuring a table in
Design view
Restricting what can be entered in a field Input masks
Lookup lists
Indexing a table
Relationships between tables
Form properties
Preventing access to form fields
Changing the order of access to fields
Subforms
Using a form to enter data in several tables at once
Collecting and sharing data
If you ar report, position them to simplify reading.
Creating a text box to represent a field Selecting and deleting controls
Creating a check box/button
Creating an option group
Creating a label
Creating a calculated control
Calculating statistics in forms and reports
Creating a set list of values
Creating a list of values from an existing table/query
Moving and copying controls
Aligning and spacing controls
Changing the height of a section
Creating a rectangle/line control
Resizing controls
Formatting text in a control
Aligning text in a control
Formatting controls
Conditional formatting
Copying a format from one control to another
Grouping/ungrouping controls
Numbering pages in a report or form
Inserting a picture
Themes
Sorting information in a report
Grouping records in a report
Printing groups on separate pages of a report
Mailing labels
Calculated fields in a query
Statistics without grouping
Statistics on groups
Statistics on groups of pre-selected records
Parameter queries
Find Unmatched query
Find Duplicates query
Crosstab query
Creating a pivot table
Grouping records in a pivot table
Adding a totals field to a pivot table
Pivot charts