Access

Question 1

What is DBMS

Answer 1

database management system

Question 2

What will DBMS allow you to do

Answer 2

allows you to create different tables within that database allows you to manipulate and control data and reduce redundant information

Question 3

what’s a database

Answer 3

collection of data information collected for business purposes or personal uses like file folders

Question 4

what does a database allow a user to do

Answer 4

enter information, analyze data, access data, then inspect data

Question 5

a database maintains information about various types of:

Answer 5

1. Objects (inventory, products selling)
2. Events (transactions and sales)
3. People (employees, customers, suppliers, etc)
4. Places (distributor, warehouses, etc.)

Question 6

What are Microsoft’s access advantages

Answer 6

• cannot be accessed without password
• tablet friendly
• easy to install
• easy to use
• import data
• create validation rules
• helps decrease redundancy

Question 7

disadvantages of Microsoft access

Answer 7

• not made for mac
• multi user
• changes can be made by other users

Question 8

what are the 5 primary functions of DBMS

Answer 8

1. creating a database and fields creating tables, and creating relationships between table
2. easy to ass records and easy to delete and change the viewing of records
3. query allows you to pull out information if needed
4. built in reports can create reports for viewing
5. security (protection and lock features, like password protection)

Question 9

What is backstage view?

Answer 9

allows you to open new databases, create, save and save as databases

Question 10

Navigation Pane

Answer 10

stores all of the objects you create and save (tables, forms, queries, and reports)

Question 11

Whats another name for a table?

Answer 11

entity

Question 12

what’s stored on a table

Answer 12

a table has a person, place, or things, transactions and events

table consists of rows called data separated by fields that are stored in columns

Question 13

whats a field

Answer 13

considered a characteristic of a table, field and attribute are the same thing

Question 14

datasheet view

Answer 14

shows front side of it and the data

Question 15

design view

Answer 15

you can modify, setup and design tables

Question 16

description

Answer 16

is optional and should be added when its not clear what you’re trying to describe

Question 17

field names

Answer 17

broken down into simple, composite, single, multi-value, stored vs. derived, Null

Question 18

Simple

Answer 18

cannot be broken down any further (like names phone numbers)
can only have one of it (like social security numbers, drivers license numbers, UIN, mac address)

Question 19

Composite

Answer 19

can be broken dow into smaller field names (like addresses)

Question 20

Multivalue

Answer 20

can have more than one (bank account, degree, car)

Question 21

Stored vs. derived

Answer 21

take one fixed value by using another value to find the answer

Question 22

Null

Answer 22

something that is not valid or doesn’t have NA (something not everyone has like a phone number)

Question 23

What is a record

Answer 23

a unit of information each record needs to be unique, shouldn’t have duplicates, blue means its highlighted

Question 24

what is a primary key

Answer 24

HAS to be unique to only the table can change it

Question 25

What is a foreign key?

Answer 25

ID that is in another table but is not a primary key for that table meant to create relationship between 2 tables

Question 26

What are the primary key rules?

Question 27

what is a field description?

Answer 27

should identify field name and attribute

Question 28

field size

Answer 28

limit letters, numbers, signs, etc. to have your data all the same size

Question 29

input mask

Answer 29

makes sure the formatting is all the same throughout

Question 30

default value

Answer 30

inputting a value that will automatically start at a certain value

Question 31

validation rule/ validation text

Answer 31

allows you to set rules and text to make sure the criteria is met and can be inputted into the table

Question 32

forms

Answer 32

used to enter information, modify information, and used for viewing the records, need to use a meaningful title

Question 33

how to design a form

Answer 33

needs to meet the needs of the people that are going to be using it, simple concise visually appealing needs to be user friendly and readable and consistent through out

Question 34

where does information go when entered

Answer 34

goes into the table its based off of automatically stored in the table and goes as last record

Question 35

form view

Answer 35

allows you to view the form

Question 36

layout view

Answer 36

allows you to view the form with the information in it , make changes with the text data in it

Question 37

design view

Answer 37

background view of it without data in it

Question 38

what is a form wizard?

Answer 38

Allows you to go through and add the fields that you want.

Question 39

what does ### mean?

Answer 39

means too much data in the cell

Question 40

what happens when a record is deleted?

Question 41

what is a report used for and how is it created?

Answer 41

for managerial reasons can be generated from queries and tables, can be in paper form

Question 42

what are the different views?

Answer 42

design view

Question 43

design view

Answer 43

shows you the text box label, time and date is always on the right side of the page, and

Question 44

queries

Answer 44

allows you to select data allows you to find information ad extract it allows you to ask questions is a way of compiling the data

Question 45

query wizard

Answer 45

allows you to go through and add fields you want and edit

Question 46

query design

Answer 46

go into backstage view then add tables and make changes is the preferred method

Question 47

what is criteria and how is it used?

Answer 47

to limit search

Question 48

when are numbers signs used?

Answer 48

when using data, number signs are automatically used

Question 49

run icon

Answer 49

allows you to view the data

Question 50

comparison operators

Answer 50

typically used with numbers and dates they are: <,>,=

Question 51

logical operators

Answer 51

allow you to meet conditions of combining 2 more comparison operators by using and or

Question 52

Like

Answer 52

matches text values by using wildcards

Question 53

between

Answer 53

determines if a number or data is within a range

Question 54

In

Answer 54

determines if a value is found within a set of values

Question 55

what is a wild card character

Answer 55

means it will go and find all the numbers that start with ex. 75 ? means it will find all words that start and end with the letters entered

Question 56

making queries

Answer 56

make sure you spell everything correctly make sure to use whats being asked third only use fields that need to be showed make sure the data is up to data and correct

Question 57

criteria

Answer 57

used for returning specific information from the query that is being created to get a result