Microsoft® Access 2013 Intermediate - TED Learning

This Microsoft Access 2013 Intermediate training course is aimed at those who have a good understanding of Access 2013 at an introductory level. This course allows the delegate to experience the power of Access 2013 and provide knowledge and techniques necessary for the successful creation and manipulation of databases and reports.

Upon completion of this Microsoft Access training, participants should be able to:

• Retrieve Data from Access 2013 Database
• Work with Forms to allow for add / edit / deletion of data from Access databases
• Design Reports for Easier analysis in Microsoft Access 2013.
• Design a simple database from scratch
• Create and understand table relationships
• Create filters and queries
• Use expressions in the Query Designer

USING APP VIEWS

1. Understanding Views
2. Adding a New View
3. Editing a View
4. Deleting a View
5. Adding a Popup View

CUSTOMIZING APPS (I)

1. Checking Your Database Name or Server Location
2. Modifying the Action Bar
3. Opening a Table for Editing
4. Moving, Resizing, or Deleting Controls

CUSTOMIZING APPS (II)

1. Adding Controls from the Ribbon
2. Adding Controls from the Field List
3. Changing Control Properties

ADVANCED RECORD TASKS

1. Showing Totals
2. Adding from Outlook
3. Saving a Record as an Outlook Contact
4. Adjust Row Height
5. Hiding and Un-hiding Fields
6. Freezing and Unfreezing Fields
7. Formatting Text

ADDING OTHER TYPES OF FIELDS

1. Adding Rich Text and Long Text Fields
2. Adding Attachment Fields
3. Adding Hyperlink Fields
4. Adding Lookup & Relationship Fields
5. Adding Calculated Fields

ADVANCED FIELD TASKS

1. Adjusting the Field Size/Width
2. Setting Field Default Value
3. Working with More Fields
4. Working with Field Validation Options
5. Using the Field List

WORKING IN TABLE DESIGN VIEW

1. Opening Design View
2. Working with Field Properties
3. Setting the Primary Key
4. Using the Properties Sheet
5. Working with Table Properties
6. Viewing Table Relationships
7. Using Relationship Tools
8. Viewing Object Dependencies

WORKING WITH EXTERNAL DATA

1. Linking Data
2. Importing Data
3. Using the Table Analyzer
4. Refreshing Data
5. Exporting Data

CREATING QUERIES

1. Creating a Select Query
2. Creating a Make Table Query
3. Creating an Append Query
4. Creating a Cross tab Query
5. Showing and Removing Tables

CREATING FORMS AND REPORTS

1. Creating a Form with the Form Wizard
2. Creating a Report with the Report Wizard
3. Modifying Form Layout
4. Navigating the Field List
5. Key Features on the Form Tools Tabs
6. Key Features on the Report Tools Tabs