Tag: ms access

How to Create a Query in Access

Posted on by Ian

To create a query in Access 2013 or 2016:

  1. Click the CREATE > Query Design button on the Ribbon.
  2. Choose the tables to include in the query
  3. Choose the fields to include, and adjust the criteria
  4. 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.

Continue reading →

How to Create a Relationship in Access

Posted on by Ian

To create a relationship in Access 2013 or 2016:

  1. While viewing a table in Design view, and ensuring that the DESIGN tab is selected, click Relationships from the Ribbon
  2. 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
  3. 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.
  4. 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.

Continue reading →

How to Add a Macro Button to a Form in Access

Posted on by Ian

To add a macro to a form in Access 2013 or 2016:

  1. Create a macro
  2. Now, open the form in Design view
  3. Click the Button icon in the Ribbon (from the DESIGN tab)
  4. 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
  5. Select the name of the macro you want to run and click Next
  6. Choose whether to display text or an image on the button and click Next
  7. Give the button a name and click Finish

Continue reading →

How to Export from Access to Excel

Posted on by Ian

To export from Access 2013 or 2016 to Excel:

  1. Open the table or query that contains the data you want to export
  2. Click the Excel download icon (from the EXTERNAL DATA tab on the Ribbon)
  3. 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
  4. Click Close

Continue reading →

How to Create a Table in Access

Posted on by Ian

To create a table in Microsoft Access 2013 or 2016:

  1. Click CREATE from the Ribbon
  2. Click Table

Here’s what that button looks like on the Ribbon:

Screenshot of the CREATE tab of the Ribbon in Microsoft Access 2013
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.

Continue reading →

How to Create a Database in Access

Posted on by Ian

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.

  1. Click Blank desktop database
  2. 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.

Continue reading →