To create a query in Access 2013 or 2016:
- Click the CREATE > Query Design button on the Ribbon.
- Choose the tables to include in the query
- Choose the fields to include, and adjust the criteria
- Click the Run button (or just switch to Datasheet view)
The results of the query will be displayed.
You also have the option of saving your query. To save the query, right-click on the query tab. click Save, and name it at the prompt.
To create a relationship in Access 2013 or 2016:
- While viewing a table in Design view, and ensuring that the DESIGN tab is selected, click Relationships from the Ribbon
- A Show Table dialog will appear with a list of tables and queries. Select the tables (and/or queries) that you wish to create a relationship between, and close the dialog
- The Relationships tab will appear with the selected tables. Click and drag a field on top of a field in another table to initiate a relationship.
- The Edit Relationships dialog will pop up containing both fields. Make any adjustments and click OK
This will create the relationship. You will see the tables in the Relationship tab with lines depicting the relationship between the tables.
To add a macro to a form in Access 2013 or 2016:
- Create a macro
- Now, open the form in Design view
- Click the Button icon in the Ribbon (from the DESIGN tab)
- In the Form Detail area, click and drag the cursor so that it forms a square or rectangle (i.e. shape of a button). The Command Button Wizard will pop up. Select Miscellaneous > Run Macro and click Next
- Select the name of the macro you want to run and click Next
- Choose whether to display text or an image on the button and click Next
- Give the button a name and click Finish
To export from Access 2013 or 2016 to Excel:
- Open the table or query that contains the data you want to export
- Click the Excel download icon (from the EXTERNAL DATA tab on the Ribbon)
- Click OK to save the file at the default location. Alternatively, change the location and/or a file name. Select any other options you wish to include under Specify export options
- Click Close
To create a macro in Microsoft Access 2013 or 2016:
- Click Macro from the CREATE tab
- Add actions by selecting an action from the combo box
- Customise the actions if required
- Repeat steps 2 and 3 for each action you want to add
- Save the macro
To create a table in Microsoft Access 2013 or 2016:
- Click CREATE from the Ribbon
- Click Table
Here’s what that button looks like on the Ribbon:
Clicking the “Table” icon from the “CREATE” tab creates a new table.
Those two steps create a blank table.
Once you’ve created your table, you will need to add fields (these will contain the data). You will also need to specify the type of data that the fields will contain (eg, text, number, date, etc).
You can also add extra rules about the type of data that can be entered into each field (eg, that phone numbers should be entered this way, dates should be entered that way, etc), as well as other properties for each field.
In Microsoft Access 2013 & 2016, you can create a database straight from the Welcome screen or from the work area. You can create either a blank database, or a database from a template.
Create a Blank Database
From the Welcome Screen
When you first open Access, the Welcome screen is displayed. You can create your database straight from here.
- Click Blank desktop database
- Name the database at the prompt and click Create
Your new database will have one table called “Table1”. You can modify this table to your needs. You can also create new tables and other database objects.