Module#1: Exploring Access Flashcards Preview

Microsoft Access Level 1 > Module#1: Exploring Access > Flashcards

Flashcards in Module#1: Exploring Access Deck (22)
Loading flashcards...
1
Q

What is a Database?

A

it’s an organized collection data files or tables

2
Q

What is the Purpose of a Database?

A

it is for many reasons, such as doctors using them to track patient visits.

3
Q

What is Database Management Software?

A

it allows users to store, manipulate and retrieve database information

4
Q

What is SQL?

A

it’s Structured Query Language

5
Q

What is MySQL?

A

it’s the most popular open source database management system.

6
Q

What are other successful data management software systems?

A

DB2 and Oracle

7
Q

What are Microsoft Access and FileMaker Pro examples of?

A

Graphical user interface (GUI) database applications

8
Q

What is the Work Area?

A

its where you work with your main database objects

9
Q

What is the Navigation pane?

A

also called Objects Panel, Lists existing database objects, specifically, tables, queries, forms and reports.

10
Q

Define a Table

A

A file or collection of related records

11
Q

Define Form

A

a Database screen used to enter, edit or view the data for an individual record

12
Q

Define Query

A

A database object or module used to request, search, select and sort data contained in tables based on specific criteria and conditions

13
Q

Define Report

A

a database page that presents processed and summarized data from tables and queries as info

14
Q

What can you do with Tables?

A

Enter, Edit, Delete or view the data in a row and column layout.

15
Q

What is a Record?

A

it’s a collection of details about an individual person, place or thing

16
Q

How are Records displayed?

A

in a Row

17
Q

What can Forms do?

A

They provide a quick, accuarate and user-friendly way to display individual records and enter data into tables

18
Q

in What views can forms be opened?

A

Design, Layout and Form

19
Q

True or False: Deleted Record numbers auto renumber in the records?

A

False. Access will not renumber.

20
Q

What do Queries Do?

A

they allow you to extract data from database tables based on criteria

21
Q

What do Reports do?

A

Reports display info retrieved from a table or query in an organized and formatted layout

22
Q

in what Views can Reports be opened?

A

Design, Layout, Report and Print Preview