To export from
Access 2013 or 2016 to Excel:
table or query that contains the data you want to export Click the
download icon (from the Excel EXTERNAL DATA tab on the Ribbon) Click
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 OK Specify export options Click
Continue reading “How to Export from Access to Excel”
To create a query in
Access 2013 or 2016:
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.
Continue reading “How to Create a Query in Access”
To create a form in
Access 2013 or 2016:
On the left navigation pane, click the
table or query that contains the data for your form From the
Create tab on the Ribbon, click Form
This creates a form based on the table or query that you selected from the navigation pane. You can modify the form as required.
You can also create a blank form (using the
Blank Form button) or you can use the Form Wizard to create a form.
Continue reading “How to Create a Form in Access”
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 from the Ribbon Relationships 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.
Continue reading “How to Create a Relationship in Access”
To create a macro in
Microsoft Access 2013 or 2016:
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
Continue reading “How to Create a Macro in Access”
To create a
table in Microsoft Access 2013 or 2016:
CREATE from the Ribbon Click
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.
Continue reading “How to Create a Table in Access”
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.
Blank desktop database Name the database at the prompt and click
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 “How to Create a Database in Access”