Excel Adrian Fulladolsa

Mer som dette

Organizing and Representing Data: Visual Representations

Ved Katie Morrison

access: database

Ved Jamie Kong

access: database

Ved Jamie Kong

Ariel Erazo's BMHS Research Cloud

Ved Ariel Erazo

Used For

Microsoft Access

Primary Key

A field or combination of fields that make every row unique and avvoid duplicating data.

Access can be used to record inputed information into databases that can be used to analyze the data and use it.

This is an example table with names and information

Used to create records and analyze data

Data Types

OLE object

A Microsoft binary data that links and embeds data

Hyperlink

Hyperlinks that when click can open an internet page, or a file.

Attatchment

Files that do not have values, like images and a binary files

Yes/No

Yes or No; True or False; On or Off

Autonumber

A value that is automatically inputed into a record

Currency

Monetary values that

Date/Time

Number

Numbers that are used in calculations

Memo

Text longer than 255 characters

Text

Letters and numbers that aren't used in calculation. Can be up to 255 characters

This is a way to input the data into a database

Tables

Access depends heavily on tables

Databases

Modules

Reports

Macros

Pages

Queries

Forms