MS-Access-urdu-thumbnail

Ms Access 2013 (Advance Course)

Instructor By. Ali Hyder
lesson. 90 lectures
Video Format. .MP4
DVDs. One
Home Delivery. All Over Pakistan
Availability. Yes



Course Outline…!!!

 01  Basic concepts 02  Lunching Access & the Backstage View
03  Creating a Database 04  Understanding Trust Center
05  Digging into Ribbon Tabs 06  Purpose of Access Title Bar
07  Using the Navigation Pane 08  Signing into a Microsoft Live
09  Access Help Guide 10  Taking Database Backup
11  Relational and Table 12  Creating a Table & Setting Data type
13  Entering Data as Records 14  Understanding Primary & Foreign Keys
15  Importing Data from Excel to Access 16  Establishing relationship & Maintain referential

 Integrity

17  Toggle between Different Views 18  Introduction of Field Property
19  Format Field Property 20  Controlling Input through Masks
21  Setting the Default Values 22  Establishing Validation Rule
23  Creating a Drop Down List 24  Format Data In a Table
25  Sorting Data in a Table 26  Filtering Data in Table
27  Searching and Replacing Values 28  Adjusting Table Layout
29  Introduction to Queries 30  Create Queries with the simple Query wizard
31  Creating Queries in Design view 32  Establishing constraints with Criteria
33  Using Wild Cards in Queries 34  Levering AND or OR Statements
35  Creating Flexible Queries with Parameters 36  Calculated Field with Aggregate Formula
37  Calculated Field Part 2 38  Create Statistical Query
39  Using Update Queries 40  Saving Query Result in new Table
41  Using Delete Queries 42  Using Append Queries
43  Getting a different look with Cross tab Queries 44  Creating a Union Query in SQL view Crosstab 

 Queries

45  Sorting records Using SQL view 46  Understanding the Role of Forms
47  Generating Forms from Tables 48  Adjusting Form element in Layout view
49  Using the Form Wizard 50  Creating Forms in Design View
51  Exploring the form property Sheet 52  Setting Data Source
53  Adding components with form Controls Part 1 54  Adding Components with form Controls Part 2
55  Understanding Input Boxes 56  Recording Navigation
57  Adding Button 58  Assigning Tab Order
59  Checking out the forms Options Part 1 60  Checking out the Forms Options Part 2
61  Insert image in a foam 62  Creating a Navigation forms
63  Introducing Report & Creating 64  Using Report Wizard for Creating
65  Formatting Report 66  Creating Report in Design View
67  Editing Report in design View 68  Grouping & Sorting Report’s records
69  Creating calculated Total in Report 70  Applying Conditional Formatting Rules
71  Creating Mailing Labels Report 72  Adjusting Print Settings
73  Creating Macros 74  Embedding Macros into Buttons
75  Embedding Macros with Table 76  Launching Macros at Startup
77  Exporting Tables to Excel Sheet 78  Linking Data in an Outlook Database
79  Emailing with Macros 80  Using Mail-Merge with Access DataBase
81  Organizing the Navigation Pane with Custom 

 Groups

82  Compacting & Repairing the Database
83  Examining Database Object Relationship 84  Documenting your work
85  Blueprinting Database (Database Documentar) 86  Splitting Database into Front & back End
87  Apply Piracy in your Database 88  Creating Custom Ribbon Tabs
89  Setting Startup Option & Custom Icon 90  Disable Startup Option -END