Week 4 – MS Access

Question 1

How do you import data

Answer 1

Import from other files or systems.
- Excel, Microsoft Access, text files, XML data, etc.
Databases can read and import data stored in other systems.

Question 2

What are Access tables?

Answer 2

• Collection of groups of data similar to an Excel workbook

Question 3

What are Access relationships?

Answer 3

Relationships
- Determine how data is used when retrieving data from multiple tables
- Do not typically exist when data tables are imported into database
Must be manually identified/created
- Created by finding common field(s) between two tables

Question 4

What are Access queries?

Answer 4

• Grouping
• Criteria
• Calculations