MS Access Flashcards
Is a repository of data.
Database
It can be a text, image, video or even logs.
Data
Is used to organize data so that it can be easily accessed, managed, and updated.
Database
DBMS stands for?
Database management system
What are the two basic building blocks of database?
Entity and Attribute
Is a thing or object that has meaning and relevance in your domain. For example, a customer, a product, or an order.
Entity
They are properties or characteristics that describe the entity. For example, a customer can have __________ such as name, email, and address.
Attributes
Converting the Entities and attributes to tables refers to the process of what?
Mapping
In mapping, the entities translates ______.
Tables
All the attributes translates into _______ in a table.
Columns
Alphanumeric data. Formerly known as text. Up to 255 characters.
Short text
Large amounts of alphanumeric data. Up to 1gb data.
Long text
Numeric data. 1, 2, 4, 8, or 16 bytes.
Number
Numeric data. 8 bytes.
Large number
Date and times. 8 bytes.
Date/Time
Date and times. Encoded string of 42 bytes.
Date/Time Extended
Monetary data, stored with 4 decimal places of precision. 8 bytes.
Currency
Unique value generated by Access for each new record. 4 bytes (16 bytes for replicationID).
AutoNumber
Boolean (true/false) data; Access stores the numeric value (0) for false, and -1 for true. 1 byte.
Yes/No
Picture, graphs, or other ActiveX objects from another Windows-based application. Up to about 2 gb.
OLE Object
What are the four database objects?
Tables, Forms, Queries, Reports
In Access, all data is stored in ______.
Tables
It is the heart of any database.
Tables
In Access, rows and columns are referred to as _______ and ______.
Records and Fields
Is a tool that guides you through the process of creating complex reports.
Report Wizard
Allow you to pull information from one or more tables based on a set of search conditions you define.
Queries
This lets you access common commands no matter which tab is selected.
Quick Access Toolbar
It contains all of the commands you will need to perform common tasks in Access. It has multiple tabs, each with several groups of commands.
Ribbon
It box works like a search bar to help you quickly find tools or commands you want to use.
Tell Me
Displays all of the objects contained in your database.
Navigation Pane
All open objects are displayed in tabs on the ________ Tabs bar. To view an object, click its tab.
Document Tabs bar
It allows you to navigate records one at a time.
Record Navigation Bar
You can use this to search for any term in the current object. The first result will be selected automatically.
Record Search box
Gives you various options for saving, opening, and printing your database.
Backstage View
Each record has its own __ ______.
ID Number
This command allows you to search for any term in your table.
Find
This command allows you to search for any term in your table and replace it with a new one.
Replace
The ______ __________ bar allows you to navigate through records one at a time.
Record Navigation bar
