Mist Practical Number 1

Front 1

Microsoft Access

Back 1

a relational database application that is part of the Microsoft Office suite of applications

Front 2

database

Back 2

an organized way to store data

Front 3

tables

Back 3

store data

Front 4

rows

Back 4

records

Front 5

columns

Back 5

fields

Front 6

entity

Back 6

customer or product, etc.

Front 7

primary key

Back 7

in a table is a field that contains a unique value for each and every record in the table

if a field is a primary key, you can't use a specific value more than once in that column

Front 8

foreign key

Back 8

a field in one table that contains values that are stored in a primary key in another table

if we look at the foreign key for a specific record, we can use the value to look up more data in the table where that field is used as a primary key

Front 9

reference

Back 9

a foreign key provides a REFERENCE to a record in another table

Front 10

access file extension

Back 10

.accdb

Front 11

Access interface includes:

Back 11

context tab ("external data")
ribbon (below all the context tabs)
navigation pane (left column)
object window (excel-looking layout)
status bar (at the bottom "search")

Front 12

context tab

Back 12

tabs above the ribbon that allow you to display different commands based on the category that you choose

Front 13

status bar

Back 13

part of the window that provides information about the progress of any ongoing process

Front 14

navigation pane

Back 14

the area that displays the objects included in your current database. you can use this to navigate to the object that you want to work on

i.e. it includes the different tables you created and queries, etc.

Front 15

ribbon

Back 15

a strip across the upper part of the window that contains commands that reflect the active context tab and the object that you are currently working on

Front 16

object window

Back 16

the area of the window that displays any open database objects