Introducing New Connectors In Microsoft Access 2013

new connectors in access

 setup, /  

New Connectors:

Last November, we shared our arrangement to include an arrangement of present day information connectors that will empower Office ProPlus clients to extend what is conceivable in their associations.

  • Today, we are satisfied to declare the expansion of two new connectors in our portfolio: Microsoft Dynamics and Salesforce. These two connectors are taking off to clients with Office 365 ProPlus, E3, or E5 designs.


  • Access incorporates a rich arrangement of outside information connectors, among which you can discover SQL Server, Azure SQL, Excel, SharePoint, Oracle, and that’s only the tip of the iceberg.
  • The new MS Dynamics and Salesforce information connectors in Access can be utilized as a part of an assortment of situations, supporting bringing in from, or connecting to outside information sources.


Expanding the arrangement of outer information connectors empowers new situations for Access clients who wish to coordinate line of business information from various information sources into one intelligible arrangement in Access, and we will keep on releasing connectors to associate current information sources to Access.

Blogs :  Install office key

Introducing New and Modern Chart Types In Microsoft Access


       Tags:- setup, /     

When chatting with Access clients, we regularly find out about the key part that Access reports play for chiefs hoping to draw effective bits of knowledge out of their business’ information. The want for Access to give a fresher, more current information representations – and additionally a streamlined procedure for making those perceptions – has been conspicuous in these discussions and also in different channels, for example, User Voice.

  • Today, the Access group is eager to uncover our reaction to these worries: another arrangement of cleaner, more spellbinding Access outlines that give more approaches to imagine your information and present it in another and current way.
  • Make proper acquaintance with the as good as ever Column, Line, Bar, Pie, and Combo diagrams! Every one of these outline writes can without much of a stretch be added to a frame or answer to imagine your information and enable you to settle on more educated choices.


Section Chart


Line Chart


Bar Chart


Pie Chart


Combo Chart

Each outline can be redone to fit your particular needs utilizing the new and natural Chart Settings sheet and the well-known Property Sheet. Utilize these highlights to change the style and design of the diagram, include graph components like legends and information marks, and tweak the textual styles and hues.

These updates are accessible as a component of an Office 365 membership. On the off chance that you are an Office 365 endorser, discover how to get these most recent updates.

            Present day and Classic Side By Side

We understand that numerous current client arrangements depend on the current (otherwise known as exemplary) graphs, and those arrangements will keep on working – you’ll simply have more alternatives to browse. Access designers can utilize the new graphs close by the exemplary diagrams inside a similar arrangement, and progress to the new outlines at the pace they want.


We trust you’ll try the new graphs – we’d love your input! We’re continually searching for more approaches to make strides.

Blogs : setup


How To Create Reports In Microsoft Access 2016


Tags:- setup, /                                     


On the off chance that you have to impart data from your database to somebody yet don’t need that individual really working with your database, consider making a report. Reports enable you to arrange and display your information in a peruser well disposed, outwardly engaging configuration. Access makes it simple to make and alter a report utilizing information from any question or table in your database.

  • All through this instructional exercise, we will utilize an example database. In the event that you might want to take after along, you’ll have to download our Access 2016 example database. You should approach 2016 introduced on your PC keeping in mind the end goal to open the case.

                         To make a report:

Reports enable you to show parts of your database in a simple to-peruse, printable organization. Access gives you a chance to make reports from the two tables and questions.

1. Open the table or question you need to use in your report. We need to print a rundown of treats we’ve sold, so we’ll open the Cookies Sold inquiry.

The Cookies Sold query

 2. Select the Create tab on the Ribbon. Find the Reports gathering, at that point tap the Report order.

Clicking the Report command

3.  Access will make another report in light of your protest.

4.  It’s imaginable that a portion of your information will be situated on the opposite side of the page break. To settle this, resize your fields. Just select a field, at that point snap and drag its edge until the point that the field is the coveted size. Rehash with extra fields until the point when the greater part of your fields fit.

Resizing fields in the report

5. To spare your report, tap the Save summon on the Quick Access Toolbar. Whenever provoked, type a name for your report, at that point click OK.

Saving and naming the report

Much the same as tables and inquiries, reports can be arranged and separated. Just right-tap the field you need to sort or channel, at that point select the coveted choice from the menu.

                       Erasing fields

You may find that your report contains a few fields you don’t generally need to see. For example, our report contains the Zip Code field, which isn’t essential in a rundown of requests. Luckily, you can erase fields in reports without influencing the table or inquiry where you snatched your information.

                        To erase a field in a report:

1.  Snap any cell in the field you need to erase, at that point press the Delete key on your console.

Deleting a field

2. The field will be erased.

When you erase a field, make sure to erase its header too. Just select the header and press the Delete key.

Deleting a field header after deleting the related field

Blogs : office com setup

How To Work with Tables In Microsoft Access

Microsoft Access -Tables

Tags: , ,  


While there are four types of database objects in Access, tables are arguably the most important. Even when you’re using forms, queries, and reports, you’re still working with tables because that’s where all of your data is stored. Tables are at the heart of any database, so it’s important to understand how to use them.

In this lesson, you will learn how to open tables, create and edit records, and modify the appearance of your table to make it easier to view and work with.

Throughout this tutorial, we will be using a sample database. If you would like to follow along, you’ll need to download our Access 2013 sample database. You will need to have Access 2013 installed on your computer in order to open the example.

                                                                 Table basics
    To open an existing table:
1. Open your database, and locate the Navigation pane.
2. In the Navigation pane, locate the table you want to open. Tables are marked with the icon.
3. Double-click the desired table. It will open and appear as a tab in the Document Tabs bar.
Screenshot of Access 2013
        Understanding tables
All tables are composed of horizontal rows and vertical columns, with small rectangles called cells in the places where rows and columns intersect. In Access, rows and columns are referred to as records and fields.

Screenshot of Access 2013

A field is a way of organizing information by type. Think of the field name as a question and every cell within that field as a response to that question.

Screenshot of Access 2013

A record is one unit of information. Every cell on a given row is part of that row’s record. Each record has its own ID number. Within a table, each ID number is unique to its record and refers to all of the information within that record. The ID number for a record cannot be changed.

Screenshot of Access 2013
Each cell of data in your table is part of both a field and a record. For instance, if you had a table of names and contact information, each person would be represented by a record, and each piece of information about each person—name, phone number, address, and so on—would be contained within a distinct field on that record’s row.

  • Click the buttons in the interactive below to learn how to navigate a table.

labeled graphic
     Navigating within tables
To navigate through records in a table, you can use the up and down arrow keys, scroll up and down, or use the arrows in the Record Navigation bar located at the bottom of your table. You can also find any record in the currently open table by searching for it using the record search box. Simply place your cursor in the search box, type any word that appears in the record you want to find, and press the Enter key. To view additional records that match your search, press Enter again.

Screenshot of Access 2013

To navigate between fields, you can use the left and right arrow keys or scroll left and right.

           Adding records and entering data
Entering data into tables in Access is similar to entering data in Excel. To work with records, you’ll have to enter data into cells. If you need help entering data into records, you might want to review our Cell Basics lesson from our Excel 2013 tutorial.

To add a new record:
There are three ways to add a new record to a table:

1. In the Records group on the Home tab, click the New command.
Screenshot of Access 2013
2. On the Record Navigation bar at the bottom of the window, click the New record button.
Screenshot of Access 2013
3. Begin typing in the row below your last added record.
Screenshot of Access 2013
Sometimes when you enter information into a record, a window will pop up to tell you that the information you’ve entered is invalid. This means the field you’re working with has a validation rule, which is a rule about the type of data that can appear in that field. Click OK, then follow the instructions in the pop-up window to re-enter your data.

Screenshot of Access 2013
To save a record:
Access is designed to save records automatically. After you enter a record, you can either select a different record or close the object, and Access will save the record. However, in certain situations you may want to save a record manually. For example, if you needed to edit an existing record, you could save the record to ensure your changes are saved.

Select the Home tab, and locate the Records group.
Click the Save command. The record will be saved.

Screenshot of Access 2013

Blogsoffice setup

Office 365 and Microsoft 365 Training for your Business

office 365 business purpose

Tags:- , ,  

We released new Office 365 training last year. Since then we’ve heard positive feedback and requests for more!

So now we’ve made it easy to find the latest training direct from the Office 365 or Microsoft 365 admin center – choose the training option that interests you.

Admin Center.png


New training way-finder

Choose “Train yourself” to get training for business owners, admins, or IT Pros.  You’ll also find new training for Teams and Yammer plus Microsoft 365.


Office 365 training for small businesses

For small business owners or admins, learn how to set up Office 365 for your business, use communications tools for email and meetings, store and share files in the cloud, and manage your employees and the service in the Admin center.

Small_biz_train.pngShort videos help you get started with Office 365.

For routine admin tasks like reassigning licenses, you’ll find a series of short videos under Management tasks.

Management tasks.pngTraining options

Office 365 training for IT pros

For enterprise admins or IT pros, ramp up on critical skills for Office 365 deployment, administration, and internal help desk support. Choose the LinkedIn Learning option in the admin center to view over 7 hours of premium video training for free in partnership with LinkedIn Learning. There you will find the option to get a LinkedIn Learning trial or paid subscription if you like.

LIL.pngVideo training brought to you by LinkedIn Learning

Office 365 training for end users

For everyone else, including employees and end users, get the most out of Office 365 with training, Quick Start guides, templates, infographics, cheat sheets, and more. Choose Train your people in the Admin center .Training_Center.pngOffice 365 Training Center

Let us know what you or your customers think. What did we miss? What could be better?

Thank you! Susan Potter & Tom Werner, Office 365 Content. : Blogs

Creating an Access Database

Tags:- , ,  

01. Beginning

Numerous individuals make their first database utilizing one of the numerous free Access 2013 database layouts. Lamentably, this isn’t generally an alternative, as you now and then need to make a database with business necessities that aren’t met by one of the accessible layouts. In this article, we walk you through the way toward outlining your own Access database without the utilization of a layout.

To start, open Microsoft Access. The directions and pictures in this article are for Microsoft Access 2013. In case you’re utilizing a prior adaptation of Access, see Creating an Access 2007 Database from Scratch or Creating an Access 2010 Database from Scratch.

02. Make a Blank Access Database


Numerous individuals make their first database utilizing one of the numerous free Access 2013 database formats. Tragically, this isn’t generally a choice, as you in some cases need to make a database with business necessities that aren’t met by one of the accessible layouts. In this article, we walk you through the way toward outlining your own Access database without the utilization of a layout.

To start, open Microsoft Access. The guidelines and pictures in this article are for Microsoft Access 2013. In case you’re

utilizing a prior variant of Access, see Creating an Access 2007 Database from Scratch or Creating an Access 2010 Database from Scratch.

Once you’ve opened Access 2013, you will see the Getting Started screen appeared previously. This exhibits the capacity to look through the numerous formats accessible for Microsoft Access databases, and additionally peruse the databases that you’ve as of late opened. We won’t utilize a layout in this case, be that as it may, so you should look through the rundown and find the “Clear work area database” section. Single-tick on this passage once you find it.

03. Name Your Access 2013 Database

When you tap on “Clear work area database”, you’ll see the fly up appeared in the outline above. This window prompts you to give a name to your new database. It’s best to pick an unmistakable name, (for example, “Representative Records” or “Deals History”) that enables you to effectively distinguish the motivation behind the database when you later peruse the rundown. On the off chance that you would prefer not to spare the database in the default organizer (appeared beneath the textbox), you may transform it by tapping on the envelope symbol. Once you’ve indicated the database document’s name and area, tap the Create catch to make your database.

04. Add Tables To Your Access Database

Access will now give you a spreadsheet-style interface, appeared in the picture over, that encourages you make your database tables.

The main spreadsheet will enable you to make your first table. As should be obvious in the picture above, Access starts by making an AutoNumber field named ID that you can use as your essential key. To make extra fields, just double tap on the best cell in a section (the line with a dim shading) and select the information compose you might want to utilize. You may then write the name of the field into that cell. You would then be able to utilize the controls in the Ribbon to tweak the field.

Keep including fields in this same way until you’ve made your whole table. Once you’ve wrapped up the table, tap the Save symbol on the Quick Access toolbar. Access will then approach you to give a name to your table. You can likewise make extra tables by choosing the Table symbol in the Create tab of the Access Ribbon.

In the event that you require help gathering your data into suitable tables, you may wish to peruse our article What is a Database? that clarifies the structure of database tables. In case you’re experiencing issues exploring in Access 2013 or utilizing the Access Ribbon or Quick Access toolbar, read our article Access 2013 User Interface Tour.

05. Keep Building Your Access Database

Once you’ve made the greater part of your tables, you’ll need to keep dealing with your Access database by including connections, structures, reports and different highlights. Visit our Microsoft Access Tutorials segment to get help with these Access highlights.

Blogs: setup


Mastercard disrupts payment industry with innovation driven by Microsoft 365

Mastercard disrupt

Tags:- , ,

Disruption in the payment industry is all about simplification, expedience, and secure global connections. Master card is leading the charge to a “world beyond cash,” creating products and services such as the company’s new digital wallet, Master pass, and tokenization solutions that improve the security of digital payments. These advances continue the company’s long history of innovation, rooted firmly in its culture and people. That’s why it’s so exciting that Master card uses Microsoft 365 to incentivize and engage its employees through highly secure, modern workplaces—where creative collaboration happens as quickly and seamlessly as any Master card payment.

Here’s what Ed McLaughlin, president of Mastercard Operations and Technology, has to say about the company’s adoption of Microsoft Cloud solutions:

“Mastercard connects people, financial institutions, merchants, and businesses across the globe. As one of the largest technology companies in the payments space, we give our employees the tools they need to deliver continual innovation to our customers and do it securely. We selected Microsoft 365 to support a modern workplace for our 11,900 employees, giving them the capability to collaborate on the fly and deliver their best work.”

I like to think of how we are amplifying the ingenuity and creative thinking that goes on every day at Master card through continuous improvements to the Office 365 platform. For example, we are weaving Microsoft machine learning and AI capabilities throughout Office 365 apps. One new feature, Insights in Excel, automatically highlights patterns, outliers, and trends in data, so employees see different perspectives on their business information to spark new ideas.

Source :

[MVP Blog] Provisioning an Office 365 group with an approval flow and Azure functions-part 1


Tags:- , ,

Office 365 groups span over various Office 365 services and provide a great way for collaborating. By default, every user can create an Office 365 group. While self-service is a good thing and many businesses adopted into that direction, some companies still prefer the controlled approach.

In real world environments, organizations usually want to restrict the group provisioning so that IT can control the wild growth of groups. This article series shows how to create an Office 365 group with an attached approval process with SharePoint Online, Flow and Azure functions. See how this works here!

This is part 1 of a 3 part series. This article series was written by Martina Grom and Toni Pohl.

For showing all the technics behind that requirement we developed a demo scenario showing all necessary steps. You need to have a SharePoint Administrator, a Flow license and an Azure subscription and some basic knowledge about web technologies. There are some steps required, but the process is simple. Follow these steps to get your solution up and running.

The scenario

The following graphics delivers the planned steps for the approval workflow. The blue steps require a user interaction, the orange ones are automatic processes. Green and red show an accept or deny decision.



If a user requests to create an Office 365 group (which can be requested f.e. in a PowerApp or in a SharePoint list) and it gets accepted, the function provisions the group and the initiator gets a notification email. In this sample, we start with the base part that does the work: provisioning the Office 365 group, first as a demo, then in part two the code follows.

First, see how group operations work with Microsoft Graph Explorer

Open, sign in and accept the consent for the Microsoft Graph App.




Now, try to access the Microsoft groups with a GET request of this URL:

If you get an error as here, your account (even if it’s the global administrator) does not have the necessary permissions.


The error says “Authorization_RequestDenied”, and “Insufficient privileges to complete the operation.”

You need to modify the permissions. Open the link in the red message box (or on the left below your account). In the Modify Permissions dialog, click “access to your entire organization” and confirm the “Modify Permissions” button. Alternatively, you can add the required permissions “Read and write all groups” manually.


Then, sign in again (which happens automatically that you get redirected to the login page again). Now, you get a new consent with all possible permissions. Accept the new consent for your organization.


Another box informs about the newly granted permissions, and yes, it can take some minutes before the consent takes effect, but mostly it works instantly.


We’re done with the permissions for our administrator user.

Update December 2017: All App permissions

Since we got some feedback on the required permissions for the app, see the following screenshots for all activated permissions of that app:

For AAD, the following app permissions were used:


For Graph, these permissions have been set.



We hope, this clarifies the permissions.

Acessing groups through the Microsoft Graph API

Ok, now we should be able to use the API for Office 365 groups. For our demo, we are using Microsoft Graph API version 1.0 (which is the current version). The next attempt against works as expected: We get all groups of the tenant – which is one single existing Office 365 group in our sample.


Since the API represents an OData interface, we can use expressions as filtering, paging and more. Here we reduce the output to the relevant properties with $select as parameter:$select=displayName,description,groupname,groupTypes,


For a list of more OData options, see Use query parameters to customize responses and Supported queries, filters, and paging options | Graph API concepts.

Create a new Office 365 group with the Microsoft Graph API

We can create a new Office 365 group with a POST operation and the necessary data as follows. First, we simply copy the JSON output from above and adapt it as needed. We create a new group “My Demo 1” with some description and the necessary properties as here:

"displayName": "My Demo 1",
"description": "This is a demo group",
"groupTypes": ["Unified"],
"mailEnabled": true,
"mailNickname": "mydemo1",
"securityEnabled": false

An Office 365 group is defined by the group type “Unified”. This JSON-description must be pasted into the “Request Body”. So, let’ s execute this operation against with a POST as here:


You should get a HTTP status code 201 (which means Ok, the request has been fulfilled and has resulted in one or more new resources being created.) and the runtime of the operation and some output.

To see, what properties can be used for a POST operation and what properties are read only check out the list at group resource type.

Set the owner of a group

When we create a new group with the Global Administrator with Graph Explorer, that user is automatically owner of the new group which is fine. If we do it (in part 2) with an app, there is no owner set. This means, that the user who requested the new group will not be able to access or to manage it. So, it’s essential, that we are able to set the owner of a group programmatically as well.

The good story is that we are able to do this with the Microsoft Graph API. See how this works. Basically, we need to get the User Id of the owner first. We can get it by asking for the user by his UPN:


In our sample, the User ID is be2cab0f…

Also, we need the Group ID. To get a quick list of all groups, use this GET query:$select=displayName,id

…and copy the Group ID from the output as we did before with the User ID. Here it’s 79744859…

Now we can add that User Id to the list of owners. Create a POST operation in Graph Explorer wit the address of the desired group as follows:$ref

The Request body needs to contain the JSON data of our new owner (the user’s address endpoint):

{"": ""}

This sets the owner of the new group to a specific user. We also need to add the owner as a member of the group. This is exactly the same method (the same JSON body with the same user), just the endpoint is members instead of owners:$ref

The owner now can fully manage the group container object.

Create a new Office 365 group with PowerShell

Of course, we can use PowerShell as well. First, we connect to Exchange Online.

Connect-MsolService -Credential $cred
$session = New-PSSession -ConfigurationName Microsoft.Exchange `
-ConnectionUri `
-Credential $cred -Authentication Basic -AllowRedirection
Import-PSSession $Session -AllowClobber

To see a list of all existing Office 365 groups, use Get-UnifiedGroup.

Now we can create a new group as described in… . There are a bunch of possible options, but this basic syntax is sufficient for the new group:

New-UnifiedGroup -DisplayName "My Demo 2" -Alias "mydemo2" `
-PrimarySmtpAddress "" `
-Owner ""

The group gets provisioned in the same way as before with the Microsoft Graph API.

Check it in Outlook

Open and discover the modern groups. “My Demo 1” should show up in the list of Office 365 groups.




It worked! The mail nickname is the email address with the primary domain defined in that Office 365 tenant. The email address can be changed later with PowerShell. To do that, see the details at Why we moved away from Exchange distribution groups to Office 365 groups and “Setting custom email addresses for the Office 365 group”.



Get an Office 365 group with Microsoft Graph

To access one specific group, we can filter that easily: To identify one group, the ID is added to the request. So you can get the ID from the Graph Explorer Request above.


So, in our case that’s an operation as here:

…and we get just this group.


Delete an Office 365 group

Now, deleting that specific group is easy. The HTTP operation is changed to DELETE.

When the query is executed, it delivers HTTP status code 204 (The server has successfully fulfilled the request and that there is no additional content to send in the response payload body).


The group has been deleted and should no longer be present in Outlook.



Deleted Office 365 groups are (nowadays) soft deleted. This means, you can undelete a group with the Active Directory Module and the PowerShell Cmdlet
Restore-AzureADMSDeletedDirectoryObject -Id <objectId>
as described in Restore a deleted Office 365 Group.

Source :

New features in Microsoft Forms for educators at BETT 2018


Tags:- , ,

Teachers use Microsoft Forms to create quizzes, polls, or surveys. They can quickly create a survey or quiz in just a few minutes, send to students to fill out on any device, and see the results in real time. Listening to millions of users’ voices, and leveraging latest Microsoft technology, we improved Microsoft Forms to be more collaborative and productive, by adding the following top-requested capabilities:

  • New question types: Teachers can ask students to correctly order items in a list, ask students to self-report, or develop and iterate through a grading rubric using our new ranking and Likert controls.
  • Education Resources (preview) in Microsoft Forms allows teachers to use professionally-created, standards-aligned assessments in their classes.
  • New collaboration features allow easier viewing and sharing of the Forms created in through Microsoft Teams or SharePoint Office 365groups.
  • Integration with PowerPoint (under development): Forms’ integration in PowerPoint will allow teacher to easily insert a quiz to a Power Point deck, adding to Forms’ integration with Excel, One Note and Sway.
  • Administrator control: Administrators will have clear controls over sharing Microsoft Forms outside the organization.
  • All.png

    Source :

Introducing New Connectors in Access Microsoft Dynamics and Salesforce


Tags:- , ,

we shared our plan to add a set of modern data connectors that will enable Office ProPlus customers to expand what is possible in their organizations.

Today, we are pleased to announce the addition of two new connectors in our portfolio: Microsoft Dynamics and Salesforce. These two connectors are rolling out to customers with Office 365 ProPlus, E3, or E5 plans.


Access includes a rich portfolio of external data connectors, among which you can find SQL Server, Azure SQL, Excel, SharePoint, Oracle, and more.

The new MS Dynamics and Salesforce data connectors in Access can be used in a variety of scenarios, supporting importing from, or linking to external data sources.



Extending the portfolio of external data connectors enables new scenarios for Access customers who wish to integrate line of business data from multiple data sources into one coherent solution in Access, and we will continue to release connectors to connect modern data sources to Access.

Keep the ideas coming
If you have other suggestions and ideas for the next version of Access

Source : : Blogs