Office 365

9K

Solutions

5K

Contributors

Office 365 is a group of software plus services subscriptions that provides productivity software and related services to its subscribers. Office 365 allows the use of Microsoft Office apps on Windows and OS X, provides storage space on Microsoft's cloud storage service OneDrive, and grants 60 Skype minutes per month. Office 365 includes e-mail and social networking services through hosted versions of Exchange Server, Skype for Business Server, SharePoint and Office Online, integration with Yammer, as well as access to the Office software. All of Office 365's components can be managed and configured through an online portal; users can be added manually, imported from a CSV file, or Office 365 can be set up for single sign-on with a local Active Directory using Active Directory Federation Services.

Share tech news, updates, or what's on your mind.

Sign up to Post

Shuffle - 1 - Examine Data in Access that was imported from Excel
Examine data that was imported from Excel. Filter data in Access just like you do in Excel, for just what you want to see.
Turn on a totals row to sum columns. Best-fit columns and change column widths. See how a new AutoNumber value  is automatically assigned, and totals are changed, when a new record is created. Look up a customer code using a quick query.

Here are the other videos in this series:

Shuffle - 2 - Totals Query
https://www.experts-exchange.com/videos/61035/Shuffle-2-Totals-Query.html

Shuffle - 3 - Table Design
https://www.experts-exchange.com/videos/61036/Shuffle-3-Table-Design.html

Shuffle - 4 - Append Query
https://www.experts-exchange.com/videos/61037/Shuffle-4-Append-Query.html

Here is the video that shows how to do the import:

import an Excel spreadsheet into an Access database
https://www.experts-exchange.com/videos/60914/import-an-Excel-spreadsheet-into-an-Access-database.html

1. Open a table in Datasheet view to look at information

2. Click the Filter dropdown at the top of a column to specify criteria for the rows displayed

3. Resize columns to be wider or narrower, double-click to best-fit

4. Add new records at the bottom

5. Look at each column and determine what type of object it is.


      There needs to be a table to describe each type of object.
1
Bootstrap 4: Exploring New Features
LVL 13
Bootstrap 4: Exploring New Features

Learn how to use and navigate the new features included in Bootstrap 4, the most popular HTML, CSS, and JavaScript framework for developing responsive, mobile-first websites.

Shuffle - 2 - Totals Query
Data was imported into Access from Excel. In part 1, we examined it, and learned how to do a few things in datasheet view like filtering, sizing columns, and showing totals. To get unique values, we'll make a query and then change it to a Totals query, and use an aggregate function to calculate something. We'll use Group By, Max, and Expression.

Here are the other videos in this series:

Shuffle - 1 - Examine Data (imported from Excel)
https://www.experts-exchange.com/videos/61034/Shuffle-1-Examine-Data-imported-from-Excel.html

Shuffle - 3 - Table Design
https://www.experts-exchange.com/videos/61036/Shuffle-3-Table-Design.html

Shuffle - 4 - Append Query
https://www.experts-exchange.com/videos/61037/Shuffle-4-Append-Query.html

1. To change a query to an aggregate query, click 'Totals'


in the Query Setup group of the Design ribbon tab

2. Group By the key field in the Total row

3. Change Group By to Max for other fields

4. Create an Expression with Count(ID) for the number of records

1
Shuffle - 3 - Table Design
We are going on a deep dive to the foundation of data structure -- what is in the  design view of a table? What else you can do? Use a Unique Index to prevent duplicate values from being added. We discuss Ignore Nulls, the Primary Key, AutoNumber and its properties, create a Calculated field with an Expression to combine data from other fields, tracking fields for when records were added and edited, Field Names, reserved words, and tips for naming fields, and field properties like Data Type, and Size.

Here are the other videos in this series:

Shuffle - 1 - Examine Data (imported from Excel)
https://www.experts-exchange.com/videos/61034/Shuffle-1-Examine-Data-imported-from-Excel.html

Shuffle - 2 - Totals Query
https://www.experts-exchange.com/videos/61035/Shuffle-2-Totals-Query.html

Shuffle - 4 - Append Query
https://www.experts-exchange.com/videos/61037/Shuffle-4-Append-Query.html

Look up Problem names and reserved words in Access, by Allen Browne:
http://allenbrowne.com/AppIssueBadWord.html

1. In table design, you can use an AutoNumber for the primary key


in the Query Setup group of the Design ribbon tab

2. Don't use reserved words in field names


      or spaces or special characters
      except underscore (_) is okay.

3. Start field names with a letter

4. Ensure Data Type and Size are good.

5. Put key fields at the top


      and tracking fields at the bottom.

6. Define an Expression for calculated fields.


      Make text bigger in the Zoom Box (Shift-F2) by clicking the Font button.

7. Use Now() for the Default Value of tracking fields


      for when a record was added and edited.

8. Set a Unique Index to prevent duplicate values.

1
Shuffle - 4 - Append Query
We have a Totals query, and change it to an Append Query, so we can use it to add records. Create an an expression for a calculated field. Get errors (oops!) when we run the append query, but see how to fix them :)

To Summarize, in part 1, we examined data and made a query. In part 2, we changed the query to a Totals query to get unique values and used an aggregate function in an expression. In part 3, we took a deep dive into table design. Now, we have created and run an append query. Records are now in the customers table, and we have two more tables
to put records in before the import from Excel is done. Look for those lessons in the future.

Here are other videos in this series:

Shuffle - 1 - Examine Data (imported from Excel)
https://www.experts-exchange.com/videos/61034/Shuffle-1-Examine-Data-imported-from-Excel.html

Shuffle - 2 - Totals Query
https://www.experts-exchange.com/videos/61035/Shuffle-2-Totals-Query.html

Shuffle - 3 - Table Design
https://www.experts-exchange.com/videos/61036/Shuffle-3-Table-Design.html

1. Open a table in Datasheet view to look at information

2. Click the Filter dropdown at the top of a column to specify criteria for the rows displayed

3. Resize columns to be wider or narrower, double-click to best-fit

4. Add new records at the bottom

5. Look at each column and determine what type of object it is.


      There needs to be a table to describe each type of object.
1
How to Install and Make an Add-in for Access
Learn how to install an add-in for Access. Add-ins can save time, and make your code more accessible. Where does the add-in go?

Do you want to create an add-in? What must it contain? Learn about the USysRegInfo table and what needs to be in it.

The add-ins demonstrated here can be downloaded (free) from:

Tools > Add-in > Document SQL, RecordSource, RowSource
http://msaccessgurus.com/tool/Addin_DocumentSql.htm

Tools > Add-in > Workspace Save and Restore
http://msaccessgurus.com/tool/Addin_Workspace.htm

The add-ins are just ACCDB files that have been renamed to have an ACCDA extension.

1. To install an add-in, run Access as Administrator

2. Open a database

3. Drop down the list under the Add-ins icon on the DATABASE TOOLS ribbon tab

4. Choose the Add-in Manager

5. Choose Add New...

6. Browse to the ACCDA file and click Open

7. Close the Add-in Manager

8. Your new add-in should now be on the Add-ins menu

2
Highlight the Current Record on an Access form with a Yellow background color
Make it easier to see the current record on your Microsoft Access forms! To highlight the current record with a yellow background color, use Conditional Formatting, a control to keep track of the primary key value, a control to change color, and a little VBA.  See how to do it.

While designing, I like to increase the height of the detail section, create a shorter txtHighlight control below everything else on the ruler, set all the properties, then move txt Highlight up, close the height of the detail section, and then set the Height of txtHighlight to whatever the section turns out to be.

Once the controls are created, create VBA code and set Conditional Formatting.

In the steps below, MyPrimaryKey is the name  of your primary key control such as ProductID, OrderID, ContactID, etc. The expression in a Conditional Formatting rule can refer to control names or field names.

If you are using a datasheet form instead of a continuous form, you can't have a control under all the others, so set the conditional formatting rule on every control. You can then select multiple bound controls, and then set the rule.

To specify code for an event:

1. select the object you want such as the form or a control
2. go to the Event tab of the property sheet
3. choose [Event Procedure] or pick it from the list -- or just type "[" to pick  [Event Procedure]
4. Click the builder button [...], or press Ctrl+F2, to go to the Visual Basic Editor
5. Access will automatically create …
1
Microsoft Office 365 Backup and Restore Solution - Trend You Need To Know
Microsoft Office 365 Backup and Restore Solution by SysTools to export Office 365 mailbox to PST / EML file format on Windows OS. On Mac, tool backup O365 to PST / MBOX / MSG / EML / EMLX file formats. Not only this, restore option helps to import single as well as multiple PST file back to Office 365 tenant.

Visit Official Site to Know More: https://www.systoolsgroup.com/office365-backup/

1. Download & Install.

Visit the official site to "Download & Install" Microsoft Office 365 Backup and Restore software by SysTools

2. Login Using Office 365 Credential

Enter username & password and click on "Login" button.

3. Select File Format

Select PST or EML file format to backup Office 365 mailbox in that particular format

4. Apply Date Range Filter

This option is provided to backup Microsoft O365 Mailbox within a particular date range.

5. Export Button

Click on "Export" button to start the backup process.
1
How to recover deleted emails from Office 365 portal and through MFCMAPI
Please check the video also in regards to recovery of deleted emails from office 365 admin center and through the MFCMAPI tool.

I have mentioned each and every step with the proper steps that need to be taken care of.
0
Office 365 Basics. Module 6 - Office Online
Learn how to collaborate with office 365 Office Online
1
Office 365 Basics. Module 5 - OneNote
See the Basics of Office 365's Note Taking app, OneNote
0
LVL 10

Author Comment

by:Alan Cox
I will be. I will also be adding more content to the OneNote 2016. e.g. tagging, OneNote/Outlook integration, ect.
2
LVL 4

Expert Comment

by:Kathy Jacobs
LMK if you have questions or need help. Used to be a OneNote MVP. Know you have  lots of other good sources too.
2
Become a Microsoft Certified Solutions Expert
LVL 13
Become a Microsoft Certified Solutions Expert

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Office 365 Basics. Module 4 - Skype For Business
Learn the basics of Skype For Business in office 365
1
Office 365 basics. Module 3 - Outlook 2016
Discover the basics of using Outlook 2016 from office 365.
1
Office 365 Basics. Module 2 - OneDrive
Overview of OneDrive and collaboration.
1
Office 365 Basics Module 1 - Overview of portal
Basic Overview of office 365 user portal
1
Wrapper-2, VBA.  Show result of Excel Worksheet Function in Access Query
A query can call a function, and a function can call Excel, even though we are in Access. This is Part 2, and steps you through the VBA that "wraps" Excel functionality so we can use its worksheet functions in Access.

The declaration statement defines the function name and its return data type. The values it needs to calculate are specified as parameters, or arguments.

Create an error handler that will exit without the user realizing there might have been a problem, and define a default value of zero for the function return value.

See how to open Excel and refer to it so code in Access can use it. Reuse the Excel application object to make susbsequent processing faster ... so, how do we clean that up?

Use the function in a query! Part 1 shows a query with the calculated column that calls this code:
Wrapper-1-Query-Show-result-of-Excel-Worksheet-Function-in-Access-Query.html

Even though topics may be technical, I do my best to consider that a beginner may be watching, so extra detail is added. Hopefully not so much that more advanced users turn away ... maybe you will comment and let me know your thoughts about this? Thanks!

have an awesome day,
crystal

1. Dimension oExcel as object at top of module

2. Name of function follows the "Function" keyword

3. Enclose function parameters in parentheses

4. Declare data type of return value

5. Set up error handler


For more information on the error handling, here is a short video: Basic-Error-Handling-code-for-VBA-and-Microsoft-Office.html

6. Define default return value

7. Validate parameters -- not done in this example

8. See if Excel is loaded and ready to use


if not, then open Excel in the background and use oExcel to represent it

9. Call the Excel function you want and pass parameters

10. Assign the result to the function return value

0
Wrapper-1, Query.  Show result of Excel Worksheet Function in Access Query
Wrapper-1-Query. Use an Excel function to calculate a column for an Access query. Part 1. Shows a query in Access that has a calculated column with the results of an Excel worksheet function.

See how to call a wrapper function from a query, and send the information it needs. "Wrapper Function" is a term to mean a user-defined function (UDF) that calls another program. In this case, Excel is called and one of its worksheet functions is used. This example shows  payment calculations for a number of offers from data that is stored in a table (loan amount, annual interest rate, number of years, and number of payments per year) using Excel's PMT function.

Also see how query columns can display in different colors using the format code, and learn about some of the placeholders.

Part 2 shows how the VBA code works:
Wrapper-2-VBA-Show-result-of-Excel-Worksheet-Function-in-Access-Query.html

Even though topics may be technical, I do my best to consider that a beginner may be watching, so extra detail is added. Hopefully not so much that more advanced users turn away ... maybe you will comment and let me know your thoughts about this? Thanks!

have an awesome day,
crystal

1. Create a query with the fields you want

2. Define calculated fields with intermediate calculations if desired

3. In the calculated column with results from a VBA wrapper function, specify the function name


Send fields, calculated fields, and literal values as parameters inside parentheses

4. To color data in the column, use [ColorName] in the Format property


The color name in square brackets can be Black, Blue, Green, Cyan, Red, Magenta, Yellow, or White

5. Format codes have 4 parts separated with semi-colon (;)


1. Positive, 2. Negative, 3. Zero, 4. Null (vs Text in Excel)
0
Subform to show Calculations in Microsoft Access
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data.

A Microsoft Access subform is used to show relevant calculations for data in the mainform.

A subform control is a container, like a bucket, for a form or report. Its properties specify: what it contains (Source Object), how it is linked (Link Master Fields, Link Child Fields), what it is called (Name), how big it is (Width, Height), where it is  (Top, Left), what it looks like (Border Color, Border Style, Special Effect), whether or not it shows (Visible), if the user can modify values (Locked, Enabled), and so on.

As you navigate from record to record in the mainform, data in the subform automatically changes. LinkMasterFields and LinkChildFields are used to synchronize the forms, without any more effort on your part!

On the mainform, LinkMasterFields is a combobox that stores CustomerID but shows the customer name and more. What is displayed in the combobox is influenced by Column Count, ColumnWidths, and ListWidth.

The form inside the subform control is a regular form designed to be used as a subform; and in this case, to display information only, so things like RecordSelectors and ScrollBars are turned off. The RecordSource for the subform (where it gets its data from) is a query that has 2 queries below it doing more calculations. See how queries are stacked to get …
0
How to set up a global email signature in Office 365 and add it only to new emails
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online)

The email signature template has been downloaded from:
https://www.mail-signatures.com/articles/signature-templates/?sts=6630

If you prefer a written article to the video, go to:
https://www.mail-signatures.com/articles/configuring-organization-wide-email-signatures-in-office-365/?sts=6630

For more advanced email signature features, check out CodeTwo Email Signatures for Office 365:
https://www.codetwo.com/email-signatures/?sts=6630
0
Mainform + Subforms designed for efficiency and flexibility
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. When a sale is made, it may be paid outright, carried in-house, or purchased by a finance company.

Using a mainform with subforms allows data entry into multiple tables with referential integrity. There are also calculations, and ways to find and filter information; Synchronizing subforms so they update with the record changes using LinkMasterFields and LinkChildFields; Calculating sum and total number of orders and payments, and the balance due; Displaying the company logo; and more.

Learn how to undo creating a new record, use shortcuts and quick ways to enter data, and about setting the Enter key behavior in the Access Options so pressing Enter goes down one row, just like in Excel. See how easy it can be to disburse all the is remaining on an allocated amount left to a single order.

See how Anchoring subforms and controls enables them to stretch and shrink as the display area changes.

Future lessons will go into the nuts and bolts of how this form works, address issues, fix problems (there are some), and enhance capabilities.

~~~

Did you learn something new?

Please Like, Comment, and Share with your friends. Thank you.

Through sharing, we will all get better.

have an awesome day,
crystal

1. Download sample database

0
Learn Ruby Fundamentals
LVL 13
Learn Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

How to Create Calendar Reports from Access Queries
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen.

Visualize your data!  ... really see it

To use the code to create a calendar from a query, simply import the (only) module (mod_HtmlCalendarReport_s4p) from the download (see Step 1, below)  into your working database (and then compile and save, of course). You can get the same code by choosing File, Import in the VBE (Visual Basic Editor -- Alt-F11) and choosing the BAS file.  

Importing VBA doesn't, of course, include easy-to-launch macros (even though the macros run VBA procedures) ... triggering them is a snap -- especially if you use a menu form with buttons and other controls.  

Please, as you make changes, rename the 'test' procedures to have more meaningful names depending on how you customize them and how they are used. And add your own comments ... and indent?

If you feel like sharing, your ideas are welcome, and appreciated.

Using vba:
Application.FollowHyperlink Create_HtmlCalendar(sQueryName)
  • will open a web page with the calendar created from the query specified by sQueryName
  • The Create_HtmlCalendar function creates the calendar as an HTML file (web page)
  •   it returns the path and filename when done.
  • You have a calendar file you can email and share with others.
  • you may wish to add VBA Error Handling (Basics video)

What do you need to know to use this feature?
2

Expert Comment

by:susan nichols
Thank you for your answer! Currently I'm handling travel for our division, so I'm using this to generate calendars of upcoming travel and conferences so other departments can easily see who is going where and when since they have to do things on those dates. I've got it working perfectly doing the single month, but being of the "I want my db to do the thing and then googling how to do the thing" variety of access user, I'm not sure how to start with your instructions (this is sad, I know this is sad).
0
LVL 25
hi Susan,

sorry, I did not see notification of your comment, if there was one. Several people have asked about this. I've made a note to modify the code to do multiple months

have an awesome day,
crystal

free code you can use in your projects
https://msaccessgurus.com/code.htm
0
display Triangles! and Circles! in a Microsoft Access Query -- Get Previous Record too
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased, or a down triangle if it decreased ... and stagger the markers for even greater grasp.

This lesson also covers how to handle non-American date formats, and optimize performance with a subquery.

If you like this video, please Like, Share, and Comment ~ thank you

1. Make a new query based on a table (MyData) with a date (TheDate) and a value (Price)


   - add date and value fields to the grid
   - sort in decending order by date

2. Add another copy of the table to the query


   - Access will '_1' to the end of the name of the copy at the top of the fieldlist to make it unique.
   - This table will represent the record for 'yesterday',  or whenever the previous value was recorded.
   - add date and value fields to the grid and give them aliases (for instance, PrevDate and PrevPrice) since field names have to be unique

3. Create a calculated field to show the difference


   - for instance --> Diff: CCur( MyData.Price - MyData_1.Price )
   - between a value in the reference record and the previous record
   - Wrap with function to convert to currency to ensure the result is the correct data type
   - the calculated field name (alias) is 'Diff' since it appears before the colon

4. Create a calculated field to show the Unicode symbol corresponding to a Circle or Triangle to graphically represent the difference

0

Expert Comment

by:Andy Brown
Nice work Crystal - thank you for sharing.
1
LVL 25
thank you, Andy

Unicode:

Note: Some fonts have more, and better, Unicode representations than others. For Windows standard built-in fonts, Arial Unicode MS and Lucida Sans Unicode have fair coverage.  Common fonts such as Arial, times New Roman, and Calibri can be okay too.

If you cannot show the Unicode characters used to demonstrate, try these instead:

filled circle  --> 9679

down-pointing triangle --> 9660

up-pointing triangle --> 9650
0
How to export Office 365 mailboxes to PST using eDiscovery
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on that topic here).
0
Microsoft Bookings Review
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
2

Expert Comment

by:Daniella Barion
I totally agree with you, time zone match and customers information with easy access are big things.
1
How to change email signature in Outlook on the Web (OWA)
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA).

For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651

If you want to manage email signatures and disclaimers for a whole company, visit https://www.codetwo.com/email-signatures/?sts=6651
1
The Email Laundry
A company’s greatest vulnerability is their email.

CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to reach $2 trillion by 2019.

When a company’s email is down, business is down.

To prevent your company from cyber crime, email security is the only solution.


The Email Laundry keeps you safe from the threats organisations face every day with cutting edge CEO Algorithms, Phishing Sensors, URL Scanners and Threat Intelligence.

The Email Laundry’s comprehensive service barricades your organisation from all incoming threats which allows you to focus comfortably on your company's interests.

The Email Laundry are trusted worldwide by secured multinational companies in the healthcare financial, oil and gas industries.

We are also the highest rated email security company by IT professionals on Spiceworks.

The Email Laundry guarantees to keep your company safe!
0

Office 365

9K

Solutions

5K

Contributors

Office 365 is a group of software plus services subscriptions that provides productivity software and related services to its subscribers. Office 365 allows the use of Microsoft Office apps on Windows and OS X, provides storage space on Microsoft's cloud storage service OneDrive, and grants 60 Skype minutes per month. Office 365 includes e-mail and social networking services through hosted versions of Exchange Server, Skype for Business Server, SharePoint and Office Online, integration with Yammer, as well as access to the Office software. All of Office 365's components can be managed and configured through an online portal; users can be added manually, imported from a CSV file, or Office 365 can be set up for single sign-on with a local Active Directory using Active Directory Federation Services.