Access 2013 Intermediate
Features:
-
Interactive bite-sized lessons
-
Get Certified
-
Accurate skill assessments
-
Customizable, LMS-ready content
Access 2013 Intermediate
Try this course with a Free Trial
|
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Create Relational Databases |
Verified Learning
|
|||
Table Relationships and Relationship Types Click to start | Not Started | Not Started | Not Started | |
Create Relationships Between Tables | Not Started | Not Started | Not Started | |
Enforce Referential Integrity | Not Started | Not Started | Not Started | |
Print and Delete Relationships | Not Started | Not Started | Not Started |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Work with Queries |
Verified Learning
|
|||
Create a Query | Account Required | |||
Hide, Remove and Sort Fields | ||||
Use AND and OR operators in a Query | ||||
Create a Multiple Table Query | ||||
Create a Calculated Field | ||||
Work with Expressions and the Expression Builder | ||||
Format Fields within Queries | ||||
Use an IIF Function | ||||
Summarize Groups of Records | ||||
Display Top or Bottom Values | ||||
Parameter Queries | ||||
Find Duplicate Records | ||||
Find Unmatched Records | ||||
Crosstab Queries | ||||
Delete Queries | ||||
Append Queries | ||||
Make-Table Queries | ||||
Update Queries |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Work with Forms |
Verified Learning
|
|||
Create a Form with the Form Wizard | ||||
Create and Use a Form | ||||
Modify a Form in Layout View | ||||
Form Design View Basics | ||||
Change the Tab Order | ||||
Work with Control Properties | ||||
Work with Form Properties | ||||
Change a Controls Data Source | ||||
Create a Calculated Control | ||||
Change a Controls Default Value | ||||
Create a Subform | ||||
Work with and Modify Subforms | ||||
Create and Modify a Navigation Form |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Work with Reports |
Verified Learning
|
|||
Create a Report | ||||
Use the Report Wizard | ||||
Use the Label Wizard | ||||
Work in Layout View | ||||
Format Fonts | ||||
Copy Formatting | ||||
Change Text Alignment | ||||
Insert a Logo and Background Image | ||||
Adjust Page Margin and Orientation | ||||
Add Page Numbers and Dates | ||||
Group and Sort | ||||
Summarize Data using Totals | ||||
Understand Report Sections |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Advanced Topics |
Verified Learning
|
|||
Use Conditional Formatting | ||||
Work with Number Formatting | ||||
Use Themes | ||||
Import Information | ||||
Export Information | ||||
Link External Information | ||||
Mail Merge Records to Word | ||||
Use Hyperlink Fields | ||||
Database Object Dependencies | ||||
Compact and Repair a Database | ||||
Convert an Access Database | ||||
Back Up and Restore a Database | ||||
Password Protect a Database | ||||
Split a Database |
Quick Answer: