Databases are storage areas for data, small bits of information that are collected all around us. Organizations typically have production systems, which run and store the transactions necessary for the organization itself, and analytical systems, which store historical data that can be analyzed and used for business intelligence.
Databases consist of objects, including tables, queries, forms, and reports. These objects can be used for data manipulation and for applications within a business.
Queries can return data from one or more tables and can sort, limit, or calculate values from tables. SQL is a universal language used for queries; however, it is not necessary in Access.
Access queries can be set up using either the Query Wizard or the QBE grid.
Joins, representing relationships between fields across tables, can be created, changed, or removed.
Reports compile and summarize data in actionable, useful formats that can be used for business decision-making. Reports update with current information each time we open them and can be modified to show only the information most useful to a reader.
We can use the Report Wizard to create new reports that we can later customize.
Reports can be customized to include images and custom text, like logos.