{"id":1397,"date":"2016-11-06T10:00:15","date_gmt":"2016-11-06T10:00:15","guid":{"rendered":"http:\/\/www.quartzbd.com\/?post_type=product&p=1397"},"modified":"2016-11-06T10:00:15","modified_gmt":"2016-11-06T10:00:15","slug":"lynda-access-2016-essential-training-dvd","status":"publish","type":"product","link":"http:\/\/www.quartzbd.com\/?product=lynda-access-2016-essential-training-dvd","title":{"rendered":"Lynda Access 2016 Essential Training DVD"},"content":{"rendered":"

\"access-2016-essential-training-500x554\"<\/a><\/p>\n

Introduction<\/strong>
\nWelcome
\nUsing the exercise files
\nChallenges explained
\n1. Getting Started<\/strong>
\nKey database concepts
\nLaunching Access and the backstage screen
\nCreating the database file
\nUnderstanding the Trust Center
\nDigging into Ribbon tabs
\nUsing the Navigation pane
\nUsing the Tell Me feature
\nUsing the Quick Access Toolbar
\nSigning in to a Microsoft account
\nMaking backups
\nAccessing Access help
\n2. Creating Tables<\/strong>
\nUnderstanding table structure and relationships
\nCreating a table and setting data types
\nEntering data
\nUnderstanding primary and foreign keys
\nImporting tables
\n3. Setting Field Properties<\/strong>
\nEstablishing relationships and maintaining referential integrity
\nEditing table structure in Design view
\nControlling input with masks
\nSetting the default value
\nEstablishing validation rules
\nCreating lookup fields
\nSetting additional field properties
\nChallenge: Creating tables
\nSolution: Creating tables
\n4. Organizing Records<\/strong>
\nFormatting columns
\nSorting table data
\nFiltering table data
\nSearching and replacing values
\n5. Using Queries<\/strong>
\nUnderstanding queries
\nCreating queries with the Simple Query Wizard
\nBuilding queries in Design view
\nEstablishing constraints with criteria
\nSpecifying criteria with wildcards
\nLeveraging multiple criteria with AND and OR statements
\nFiltering with mathematical comparisons
\nCreating flexible queries with parameter requests
\nBuilding expressions
\nObtaining summary statistics
\nChallenge: Creating queries
\nSolution: Creating queries
\n6. Working with Specialty Queries<\/strong>
\nUsing update queries
\nUsing make table queries
\nFinding unmatched records
\nUsing delete queries
\nUsing append queries
\nCreating a union query in SQL view
\nGetting a different look with crosstab queries
\n7. Creating Forms<\/strong>
\nUnderstanding the role of forms
\nGenerating forms from tables
\nAdjusting form elements in Layout view
\nUsing the Form Wizard
\n8. Designing Forms<\/strong>
\nCreating forms in Design view
\nExploring the form property sheet
\nSetting data sources
\nAdding components with form controls
\nUnderstanding input boxes
\nRecord navigation
\nAdding buttons
\nAssigning a tab order
\nChecking out the More Forms options
\nCreating a navigation form
\nChallenge: Creating forms
\nSolution: Creating forms
\n9. Creating Reports<\/strong>
\nIntroducing reports
\nUsing the Report Wizard
\nCreating a report in Design view
\nEditing a report in Layout view
\nGrouping and sorting records
\nCreating calculated totals
\nApplying conditional formatting rules
\nCreating labels
\nAdjusting print settings
\nChallenge: Creating reports
\nSolution: Creating reports
\n10. Working with Macros<\/strong>
\nCreating macros
\nEmbedding macros into buttons
\nAttaching data macros to tables
\nLaunching macros at startup
\n11. Integrating Access with Office Suite<\/strong>
\nExporting tables to Excel
\nEmailing with macros
\nLinking to data in an Outlook database
\nSetting up labels and mail merge documents in Word
\n12. Maintaining the Database<\/strong>
\nOrganizing the Navigation pane with custom groups
\nCompacting and repairing the database
\nExamining database object dependencies
\nDocumenting your work
\nPrinting the blueprint of your database with the Database Documenter
\nSplitting a database into front and back ends
\nProtecting the database with a password
\nCreating custom Ribbon tabs
\nSetting startup options and custom icons<\/p>\n","protected":false},"excerpt":{"rendered":"

Delivery system
\n===============
\nFace to face from our office
\nDownload from Dropbox link
\nCourier Service<\/p>\n

Payment system
\n==============
\nFace to Face
\nbkash-01716197088 ( Personal )<\/p>\n

Contact
\n========
\n01919197088
\n01716197088-bkash ( Personal )
\n01552551768-office
\nqrtzcom@gmail.com
\nFreelancer.com profile page: https:\/\/www.freelancer.com.bd\/u\/qrtzcom.html
\nwww.quartzbd.com
\nwww.facebook.com\/quartz.bd
\nskype: quartzcom<\/p>\n","protected":false},"featured_media":1398,"comment_status":"open","ping_status":"closed","template":"","meta":[],"product_cat":[227,54,55],"product_tag":[],"class_list":{"0":"post-1397","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-june-2016","7":"product_cat-all-video-tutorials","8":"product_cat-lynda-com","10":"first","11":"instock","12":"shipping-taxable","13":"purchasable","14":"product-type-simple"},"_links":{"self":[{"href":"http:\/\/www.quartzbd.com\/index.php?rest_route=\/wp\/v2\/product\/1397"}],"collection":[{"href":"http:\/\/www.quartzbd.com\/index.php?rest_route=\/wp\/v2\/product"}],"about":[{"href":"http:\/\/www.quartzbd.com\/index.php?rest_route=\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"http:\/\/www.quartzbd.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1397"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.quartzbd.com\/index.php?rest_route=\/wp\/v2\/media\/1398"}],"wp:attachment":[{"href":"http:\/\/www.quartzbd.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1397"}],"wp:term":[{"taxonomy":"product_cat","embeddable":true,"href":"http:\/\/www.quartzbd.com\/index.php?rest_route=%2Fwp%2Fv2%2Fproduct_cat&post=1397"},{"taxonomy":"product_tag","embeddable":true,"href":"http:\/\/www.quartzbd.com\/index.php?rest_route=%2Fwp%2Fv2%2Fproduct_tag&post=1397"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}