Microsoft Office 2013 - Access

199 USD 9.01 USD 95%
Test scorm

Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications, included in the Professional and higher editions or sold separately.

read more

Section 1-1 - Creating Databases

  • Creating New Databases
  • Create Databases Using Templates
  • Create Databases In Older Formats

Section 1-2 - Creating Tables

  • Create New Tables
  • Import External Data Into Tables
  • Create Linked Tables From External Sources
  • Import Tables From Other Database
  • Create Tables From Templates And Application Parts

Section 1-3 - Format A Table

  • Hide Fields In Tables
  • Change Data Formats
  • Add Total Rows
  • Add Table Descriptions
  • Rename Tables

Section 1-4 - Manage Records

  • Update Records
  • Add New Records
  • Delete Records
  • Append Records From External Data
  • Find And Replace Data
  • Sort Records
  • Filter Records

Section 1-5 - Create And Modify Fields

  • Add Fields To Tables
  • Add A Validation Rules To Fields
  • Change Field Captions
  • Change Field Sizes
  • Change Field Data Types
  • Configure Fields To Auto-Increment
  • Set Default Values
  • Use Input Masks
  • Delete Fields

Section 2-1 - Create A Query

  • Run Queries
  • Create Crosstab Queries
  • Create Parameter Queries
  • Create Action Queries
  • Create Multi Table Queries
  • Save Queries And Delete Queries

Section 2-2 - Modify A Query

  • Rename Queries
  • Add New Fields
  • Remove Fields
  • Hide Fields
  • Sort Data Within Queries
  • Format Fields Within Queries

Section 2-3 - Utilize Calculated Fields And Grouping Within A Query

  • Add Calculated Fields
  • Add Conditional Logic
  • Group And Summarize Data
  • Use Comparison Operators
  • Use Basic Operators

Section 3-1 - Create A Form

  • Create New Forms
  • Create Forms With Application Parts
  • Save And Delete Forms

Section 3-2 - Set Form Controls

  • Move Form Controls
  • Add Form Controls
  • Modify Data Sources
  • Remove Form Controls
  • Set Form Control Properties
  • Manage Labels

Section 3-3 - Format A Form

  • Modify Tab Order In Forms And Auto-Order Forms
  • Format Print Layouts
  • Sort Records
  • Apply Themes
  • Change Margins
  • Insert Backgrounds
  • Insert Headers And Footers
  • Insert Images
  • Modify Existing Forms

Section 4-1 - Create A Report

  • Create New Reports
  • Create Reports With Application Parts
  • Delete Reports

Section 4-2 - Set Report Controls

  • Group Data By Fields
  • Sort Data
  • Add Sub-Forms
  • Modify Data Sources
  • Add Report Controls
  • Manage Labels

Section 4-3 - Format A Report

  • Format Reports Into Multiple Columns
  • Add Calculated Fields
  • Set Margins
  • Add Backgrounds
  • Change Report Orientation
  • Change Sort Order
  • Insert Headers And Footers
  • Insert Images & Insert Page Numbers
  • Apply Themes
  • Modify Existing Reports

Section 5-1 - Manage Relationships And Keys

  • Create And Modify Relationships & View Relationships
  • Set Primary Key Fields
  • Set Foreign Keys
  • Enforce Referential Integrity

Section 5-2 - Navigate Through A Database

  • Navigate To Specific Records
  • Set A Form As The Startup Option
  • Use Navigation Forms
  • Set Navigation Options
  • Change Views

Section 5-3 - Protect And Maintain A Database

  • Compact Databases & Repair Databases
  • Back Up Databases
  • Split Databases
  • Encrypt Databases With A Password
  • Merge Databases
  • Recover Data From Backups

Section 5-4 - Print And Export A Database

  • Print Reports
  • Print Records
  • Maintain Backward Compatibility
  • Save Databases As Templates
  • Save Databases To External Locations
  • Export To Alternate Formats
  • Program Close
  1. Access 2013 Module 1
6
Start
Section 1-2 - Creating Tables
7
Start
Create New Tables
8
Start
Import External Data Into Tables
9
Start
Create Linked Tables From External Sources
10
Start
Import Tables From Other Database
11
Start
Create Tables From Templates And Application Parts
12
Start
Section 1-3 - Format A Table
13
Start
Hide Fields In Tables
14
Start
Change Data Formats
15
Start
Add Total Rows
16
Start
Add Table Descriptions
17
Start
Rename Tables
18
Start
Section 1-4 - Manage Records
19
Start
Update Records
20
Start
Add New Records
21
Start
Delete Records
22
Start
Append Records From External Data
23
Start
Find And Replace Data
24
Start
Sort Records
25
Start
Filter Records
26
Start
Section 1-5 - Create And Modify Fields
27
Start
Add Fields To Tables
28
Start
Add A Validation Rules To Fields
29
Start
Change Field Captions
30
Start
Change Field Sizes
31
Start
Change Field Data Types
32
Start
Configure Fields To Auto-Increment
33
Start
Set Default Values
34
Start
Use Input Masks
35
Start
Delete Fields

No reviews for this course !

Add New Discussion

How do you rate this product?
5 + 6 =

Select currency