To export from Access 2013 or 2016 to Excel:
To add a macro to a form in Access 2013 or 2016:
To create a relationship in Access 2013 or 2016:
This will create the relationship. You will see the tables in the Relationship tab with lines depicting the relationship between the tables.
To create a form in Access 2013 or 2016:
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.
To create a query in Access 2013 or 2016:
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.
A stored procedure is a series of SQL statements compiled and saved to the database.
Stored procedures can be as simple or as complex as you like. However, one of the benefits of stored procedures is that they allow you to store complex scripts on the server.
Stored procedures often contain conditional programming such as IF... ELSE statements for example. Stored procedures can also accept parameters.
In the world of databases, a view is a query that’s stored on a database.
The term can also be used to refer to the result set of a stored query.
To create a view, you write a query, then save it as a view.
To run a view, you query it, just like you’d query a table. The difference is that, the view itself is a query. So when you query the view, you’re effectively querying a query. This enables you to save complex queries as views, then run simple queries against those views.
SQL Server Management Studio (SSMS) is a graphical user interface (GUI) that can be used to administer SQL Server.
SQL Server Management Studio allows you to create and manage your databases as well as administer your SQL Server configuration.
A foreign key is a field that is linked to another table‘s primary key field in a relationship between two tables.
In relational database management systems, a relationship defines a relationship between two or more tables. That is, the data in one table is related to the data in the other. One table contains the primary key and the other table contains the foreign key.
When we establish a relationship between the tables, we link the foreign key with the primary key. From that point on, any value in the foreign key field should match a value from the primary key field in the other table.
A primary key is one or more columns that have been configured as the unique identifier field for the table.
Most primary keys are comprised of a single column, but they can also be comprised of multiple columns.
Any value stored in a primary key field is unique to that record. No other record contains that value. The value is a unique identifier.
