Categories: All - databases - data - forms

by Adrian Fulladolsa 7 years ago

286

Excel Adrian Fulladolsa

Microsoft Access is a versatile database management tool designed to store, manage, and analyze data effectively. It primarily relies on tables to organize information and employs various data types such as numbers, text, and dates to ensure accurate data entry and storage.

Excel Adrian Fulladolsa

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