Acess 2016 Training ( 80 ) 01.03 Challenges Explained0 views 02-03 Creating the Database File0 views 02-06 Understanding the Trust Centre0 views 02-07 Using the Tell Me feature0 views 02-08 Using the Quick Access Tool Bar0 views 02-09 Signing-in to a Microsoft account0 views 02-10 Making Backups0 views 02.01 Key Concepts0 views 02.02 Launching Access and the Backstage Screen0 views 03-01 Understanding Table Structure and Relationships0 views 03-02 Creating a Table and setting Data Types0 views 03-03 Entering Data0 views 03-04 Understanding Primary and Foreign Keys0 views 03-05 Importing Tables0 views 04-01 Relationships & Referential Integrity0 views 04-02 Editing Table structure in Design View0 views 04-03 Controlling Input with Masks0 views 04-04 Setting the Default Value0 views 04-05 Establishing Validation Rules0 views 04-07 Setting Additional Field Properties0 views 04-08 Challenge : Creating Tables0 views 04-09 Solution to Creating Tables Challenge0 views 05-01 Formatting Columns0 views 05-02 Sorting Tables0 views 05-03 Filtering Table Data0 views 05-04 Searching and Replacing Values0 views 06-01 Understanding Queries0 views 06-02 Creating Queries with the simple Query Wizard0 views 06-03 Building Queries in Design View0 views 06-04 Establishing Constraints with Criteria0 views 06-05 Specifying Criteria with Wildcards0 views 06-06 Leveraging Multiple Criteria with AND and OR statements0 views 06-07 Filtering with mathematical comparisons0 views 06-08 Flexible queries with parameter requests0 views 06-09 Building expressions0 views 06-10 Obtaining Summary Statistics0 views 06-11 Challenge : Creating Queries0 views 06-12 Solution to Creating Queries Challenge0 views 07-01 Using Update Queries0 views 07-02 Using Make Table Queries0 views 07-03 Finding unmatched records0 views 07-04 Using Delete Queries0 views 07-05 Using Append Queries0 views 07-06 Creating a Union query in SQL View0 views 07-07 Getting a different look with crosstab queries0 views 08-01 Understanding the role of forms0 views 08-02 Generating Forms from Tables0 views 08-03 Adjusting Form Elements0 views 08-04 Using the Form Wizard0 views 09-01 Creating forms in Design View0 views 09-02 Exploring the forms property sheet0 views 09-03 Setting Data Sources0 views 09-04 Adding Components with Form Controls0 views 09-05 Understanding Input Boxes0 views 09-06 Record Navigation0 views 09-07 Adding Buttons0 views 09-08 Assigning a tab order0 views 09-09 Checking out the more forms options0 views 09-10 Creating a navigation form0 views 09-11 Challenge : Creating Forms0 views 09-12 Solution to Creating Forms challenge0 views 10-01 Introducing Reports0 views 10-02 Using the report wizard0 views 10-03 Creating a report in design view0 views 10-04 Editing a report in layout view0 views 10-05 Grouping and Sorting records0 views 10-06 Creating calculated totals0 views 10-07 Applying conditional formatting rules0 views 10-08 Creating labels0 views 10-09 Adjusting print settings0 views 10-10 Challenge : Creating Reports0 views 10-11 Solution to Creating reports Challenge0 views 11-1 Creating Macros0 views 11-2 Embedding Macros in Buttons0 views 11-3 Attaching data macros to tables0 views 11-4 Launching Macros at Startup0 views 12-03 Linking to data in an Outlook database0 views 12-04 Setting up labels and mail merge in Word0 views 12-1 Exporting tables to Excel0 views 12-2 Emailing with macros0 views