Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

istm > Access > Flashcards

Access Flashcards

1
Q

What is DBMS

A

database management system

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What will DBMS allow you to do

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

what’s a database

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

what does a database allow a user to do

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

a database maintains information about various types of:

A
  1. Objects (inventory, products selling)
  2. Events (transactions and sales)
  3. People (employees, customers, suppliers, etc)
  4. Places (distributor, warehouses, etc.)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What are Microsoft’s access advantages

A
  • cannot be accessed without password
  • tablet friendly
  • easy to install
  • easy to use
  • import data
  • create validation rules
  • helps decrease redundancy
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

disadvantages of Microsoft access

A
  • not made for mac
  • multi user
  • changes can be made by other users
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

what are the 5 primary functions of DBMS

A
  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)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is backstage view?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Navigation Pane

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Whats another name for a table?

A

entity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

what’s stored on a table

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

whats a field

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

datasheet view

A

shows front side of it and the data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

design view

A

you can modify, setup and design tables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

description

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

field names

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Simple

A

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)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Composite

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Multivalue

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Stored vs. derived

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Null

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

What is a record

A

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

24
Q

what is a primary key

A

HAS to be unique to only the table can change it

25
Q

What is a foreign key?

A

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

26
Q

What are the primary key rules?

A
27
Q

what is a field description?

A

should identify field name and attribute

28
Q

field size

A

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

29
Q

input mask

A

makes sure the formatting is all the same throughout

30
Q

default value

A

inputting a value that will automatically start at a certain value

31
Q

validation rule/ validation text

A

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

32
Q

forms

A

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

33
Q

how to design a form

A

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

34
Q

where does information go when entered

A

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

35
Q

form view

A

allows you to view the form

36
Q

layout view

A

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

37
Q

design view

A

background view of it without data in it

38
Q

what is a form wizard?

A

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

39
Q

what does ### mean?

A

means too much data in the cell

40
Q

what happens when a record is deleted?

A
41
Q

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

A

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

42
Q

what are the different views?

A

design view

43
Q

design view

A

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

44
Q

queries

A

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

45
Q

query wizard

A

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

46
Q

query design

A

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

47
Q

what is criteria and how is it used?

A

to limit search

48
Q

when are numbers signs used?

A

when using data, number signs are automatically used

49
Q

run icon

A

allows you to view the data

50
Q

comparison operators

A

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

51
Q

logical operators

A

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

52
Q

Like

A

matches text values by using wildcards

53
Q

between

A

determines if a number or data is within a range

54
Q

In

A

determines if a value is found within a set of values

55
Q

what is a wild card character

A

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

56
Q

making queries

A

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

57
Q

criteria

A

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

istm (20 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions