How to Program Microsoft Access
Microsoft Access is a relational database system that is fully integrated with the Microsoft Office application suite. Although Microsoft Access stores information in a Microsoft proprietary format, it is able to import and export data in various other database formats such as text, XML, dBase, and Paradox. Microsoft Access is designed to fully support SQL queries as well as integration of Visual Basic scripting to create stand-alone applications. One of the common SQL programming queries conducted in Microsoft Access is the SQL aggregate function.
Other People Are Reading
Instructions
-
-
1
Open Microsoft Access and create a new database table by selecting "File," then "New Table."
-
2
Create four data columns in the table by entering "Employee_ID" in the top of column one, "Employee_Name" at the top of column two, "Employee_Salary" at the top of column three, and "Employee_Age" at the top of column four.
-
-
3
Enter notional data records in the table by left-clicking the blank square just below the Employee_ID data field label, and enter values for Employee_ID, Employee_Name, Employee_Salary, and Employee_Age. Complete nine record entries, choosing different values for notional employee names, salaries, ages and IDs.
-
4
Open the SQL editor from the Microsoft Access "File" menu.
-
5
Enter the following SQL query in the blank query field:
"Select Avg(Employee_Salary) From M_Employees Where Employee_Age < 100."
This command will calculate the average employee salary from your database table for employees who's age is less than 100 years old and output the result.
-
1
