Brainscape's Knowledge GenomeTM

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


See full index

VCU Fall 2017 > Access > Flashcards

Access Flashcards

1
Q

Design View

A

Greater access to properties available for each type
Change name of existing table
Add relationships

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

Relationships

A

Created in Design view using join lines

Create queries, forms & reports

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

Add Description to Table

A

Right click table and select table properties

Type description

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

Working in Storage v. RAM

A

Word, Excel & Powerpoint work in RAM

Access works in Storage

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

View Existing Relationships

A

Click Relationships in Relationships group in the Database Tools tab
Re-position tables by dragging the table’s title bar so all relationships are visible
Close

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

Prompted to Save

A

Change design of table such as font or background color.

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

Deleting Records

A

Use alternative such as adding yes/no field for active status

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

Selection Filters

A

Find exact matches
Find records containing a value
Filter by Form

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

Database Object Types

A

Standard MS Office applications interface:
*Ribbon
*Backstage View
*Home Tab
*Scroll Bars
Data objects - each has its own tab on Navigation Pane & open objects have a tab displayed beneath the ribbon.

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

Datasheet View

A

Double click table from Navigation pane
Fields/categories shown as columns
Records complete set of fields shown as rows

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

Navigation Bar

A

Bottom of Datasheet view
Shows total number of records & current record
Pencil shows record is being edited
Arrows for first, last, next, and previous
Yellow asterisk adds a blank record
Find command for single field or specific records

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

Design View

A

Detailed look at the table’s structure
Specify fields contained in the table
Data types & associated properties
Click View to toggle between data and design

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

Tables

A

Databases rely on tables to provide the framework for all the tasks and activities performed in a database.

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

Design a Table

A

Consider all the specific fields you’ll need and the type of data each field will store
Next add necessary fields.

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

Guidelines for Adding Fields to a Table

A 
Include the necessary data
Design for now and the future
Store data in their smallest parts
Determine the primary keys
Link tables using common fields
Design to accommodate calculations
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Methods of Creating a Table

A

Use a template
Import data from another database
Import data from Excel
Create field names in Design then enter data in Datasheet view
Directly enter field names and table data in Datasheet view

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

Deleting Fields

A

In either Design or Datasheet views.

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

Primary Key

A

Field that uniquely identifies each record in a table.

Use a customer ID or an Autonumber.

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

Field Properties

A

Determine how the field looks and behaves.

Often set in Design view but some can be set in Datasheet view in the Table Tools Fields tab.

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

Adding Fields

A

Data sheet View add arrow at the top of an empty column.

Design view offers more field property choices.

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

Import Wizard

A

Tables, queries, forms, reports, pages, macros, and modules from other databases.
External Data tab in Import & Link group.

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

Why Import

A

Saves typing
Prevents data entry errors
Imported tables may need editing to data types, field sizes, captions, input masks, other properties-change in design view.

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

Benefits of Relationships

A

Efficiently combine data from related tables for creating queries, forms, and reports.
Database Tools tabs, Relationships Group, Relationships
Drag the Primary Key field name from one table to the Foreign Key field of the other table.

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

Referential Integrity

A

Enforces the rules in a database that are used to preserve relationships between tables when records are changed.
You cannot enter a foreign key value in a related table unless the primary key value exists in the primary table.

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

Single Table Query

A

Simple query wizard or query design tool.

The design tool offers more flexibility.

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

Query Criteria

A 
Delimeters - " or #
Wildcards - text value
Comparison operators - =,<>
Null
AND, OR, NOT conditions
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

Query Sort Order

A

Designview

Determined from left to right.

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

Fixing Query Errors

A

Correcting immediately saves time.

Changes the original data table.

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

Multitable Queries

A

Contain 2 or more tables
Takes advantage of relationships in the database.
Easiest is to add tables to an existing query or add to a copy of an existing query.

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

Create a Multitable Query

A

Use only related tables or those with a common field.
Create Tab, query design in the queries group, then add the tables. Close the show table dialog box and drag fields to query design grid, add criteria and sort options.

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

Modify a Multitable Query

A

To add tables, use Show Table dialog box in query setup, to remove, click table and press delete.
To add fields, double click the fields to include.
To remove fields, click column selector and press delete.

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

Order of Operations

A 
Rule that controls sequence arithmetic operations are performed.
Parentheses
Exponentiation
Multiplication
Division
Addition
Subtraction
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

(OOO) 2+3*3

A 
Multiply
Add
2+3*3
2+9
11
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

(OOO) (2+3)*3

A

Add values in parentheses then multiply
(2+3)3
(5)3
15

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

(OOO) 2+2^3

A 
Evaluate Exponent
Add
2+2^3
2+(2*2*2)
2+(8)
10
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

(OOO) 10/2+3

A 
Divide then add
10/2+3
(10/2)+3
(5)+3
8
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
37
Q

(OOO) 10/(2+3)

A

Simplify parenthetical expression then divide
10/(2+3)
10/(5)
2

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

(OOO) 102-32

A 
Multiply then subtract
10*2-3*2
(10*2)-(3*2)
(20)-(6)
14
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
39
Q

To Create a Calculated Field in a Query

A

Open query in Design view
Click the Field row of blank column
Type expression
Click Run in the Results group to display in Datasheet view.

40
Q

Formatting Results of Calculated Query

A

Go to Property Sheet

41
Q

Recover from Common Errors in Calculated Fields

A

Forgetting colon, spelling, order of operations.

An error message or prompt will appear.

42
Q

Verify Calculated Results

A

Use critical thinking skills or verify by copying to excel or using a calculator.

43
Q

Expression Builder Tool

A

Helps create more complicated expressions.
Size enables you to see complex formulas and functions in their entirety.
Provides easy access to objects, operators, and functions.

44
Q

Built in Functions (Access)

A

Function is a predefined computation that performs a complex calculation.
Each input is known as an argument.
Access has about 150 functions.

45
Q

Aggregate Function (Access)

A

Performs a calculation on an entire column of data and returns a single value.
Avg, Count, Max, Min, Sum
Referred to as totals

46
Q

Two Methods of Aggregate Functions (Access)

A

The total row displays as the last row in Datasheet view.

Use a totals query.

47
Q

Totals Query (Access)

A

Additional row in the query design grid.
Used to display only aggregate data when the query is run.
Enables you to see statistics by category.

48
Q

Grouping a Query

A

Enables you to summarize data by the values of a field.
Add the field you want to group by to the query in Design view.
Verify the Total row displays Group By for the added field.
A condition can be added to this type query.

49
Q

Conditions in Totals Query

A

Perform calculations on values that meet the conditions.

50
Q

Calculated Fields

A

Can have aggregate functions applied to them.
Create the calculation to summarize the data
Select the appropriate aggregate function from the menu in the Total Row
Run the query

51
Q

Create Forms Using Form Tools

A

Automatically creates a basic form saving tedious design work.
Create a form using the form tool
Create a split form
Create a multiple items form

52
Q

Modify Forms

A 
Edit Data in Form View
Delete a Field
Add a Field
Format Controls
Add a Theme
53
Q

Work with a Form Layout

A

Tools on the Arrange tab
Add gridlines, change from stacked to tabular layout, or remove the layout.
Rows & Columns group to insert rows or columns.

54
Q

Sort Records in a Form

A

Use the Sort & Filter Group

55
Q

Create Reports using Report Tools

A

Report Tool

Report Wizard

56
Q

Use Report Views

A 
Report
Layout
Design
Print Preview
Click the View arrow in the Views Group to switch between the 4 views
57
Q

Modify a Report

A

Add a field
Remove a field
Change orientation
Apply a theme

58
Q

Sort Records in a Report

A

Defaults to record source primary key.
Open report in Layout or Design view.
Click Group & Sort in Groupings & Totals group on Design tab.
Click Add a sort and select the sort field.

59
Q

Form

A

A user friendly database object used to add data to or edit data in a table
Form group on the Create tab
Cannot use to change layout and design.
Navigation bar at bottom to move between records.
Tab key to move between fields.

60
Q

Form Tool

A

Create customized, professional looking forms.
Improve data entry and editing.
Used to create data entry forms for customers, employees, products, and other types of tables.

61
Q

Create a Multiple Items Form

A

Select a table or query in Navigation Pane.
Click More Forms.
Click Multiple Items in the Forms Group of Create Tab.

62
Q

Delete a Field in a Form

A

Display the form in Stacked/Layout View
Click the text box control of the field for text.
Click Select Row in the Rows & Columns group on the Arrange tab to delete both the text box and its label.
Press Delete

63
Q

Multiple Items Form

A

Displays multiple records in a tabular layout similar to tables Datasheet view, containing more options.
More customization options than a data sheet such as graphical elements, buttons, and other controls.

64
Q

Format Controls

A

Font size, emphasis, alignment, background color, font color, and number format.

65
Q

Edit Data in Form View

A

Form layout view allows you to adjust all controls from first field.

66
Q

Sort Order within Forms

A

Tables sort on primary key.
Queries sorted in a variety of ways.
Change using the Sort & Filter Group.

67
Q

Report Tool

A

Easiest way to create a report.
Reports Group on the Create tab.
Create a tabular report based on the selected table or query.

68
Q

Report Wizard

A 
Prompts you for input in a series of steps to generate a customized report.
Make certain customizations quickly.
* Determine sorting and summary data.
* Specify preferred layout.
In the Reports Group on the Create Tab.
69
Q

Reports

A

A document that displays information in a format that outputs meaningful information to its readers.
Easiest is to use the Report tool in the Reports group on the Create tab.

70
Q

Report View

A

Cannot make modifications

71
Q

Report Print Preview

A

Cannot make modifications.
See exactly what the printed report will look like.
Options to export and save to a different file type.

72
Q

Portable Document Files (PDF)

A

A file type that was created for exchanging documents independently of software applications or operating system environments.

73
Q

Add a Field to a Report

A

After adding fields into a table.
Open report in Layout View
Click Add Existing Fields in the Tools group on Design tab.
Click and drag the desired field to the report.

74
Q

Remove a Field from a Report

A

Open the report in Report View.
Click the Text box control of the field.
Click Select Row in the Rows & Columns group on the Arrange Tab.
Press Delete.

75
Q

Change Orientation of a Report

A

Page Setup tab
Page Size group
Page Layout group for orientation.

76
Q

Apply a theme to a Report

A

To improve appearance and readability.
Open the report in Layout or Design view.
Select Themes in the Themes Group on the Design tab.
Live Preview, click the theme to select then Apply.

77
Q

Database Objects

A

Forms

Reports

78
Q

Subform

A

To view and edit data in tables that contain related records.

79
Q

Subform

A

Access automatically creates when you have a form with related data.
To view and edit data in tables that contain related records.
When you create a form based on a table that has a related table, access automatically creates a subform that displays the related records.

80
Q

Establish Data Validation

A

Require a field.
Add a default field value.
Add a validation rule with validation text.

81
Q

Control the Format of Data Entry

A

Use an Input Mask to specify the exact format of the data entry.
Phone and SSN numbers

82
Q

Data Validation

A

A set of constraints or rules that help control data entered into a field.
Access provides data validation when the type of data is different than the field’s properties.
Can use comparison operators (=,>,,>=,<=,between, in, like.

83
Q

Control Input with a Lookup Field

A

Created using the Lookup Wizard.
Open the table in Design view.
Click the field you want to change to a lookup and select Wizard from the list.
Choose a table that contains the lookup values.
Specify the sort order, and adjust column width.

84
Q

Customize Output Based on User Input

A

Create a parameter query

Create a parameter report

85
Q

Use Advanced Functions

A 
Date function
Round function
If function
IsNull function
DatePart function
86
Q

Create an Input Mask - Input Mask Wizard

A

Open the table in Design view.
Click the field to which you will ad an input mask.
Click Input Mask in the Field Properties pane.
Click the ellipses at the end of the Input Mask Row.
Select one of the built-in masks from the menu.
Decide upon whether to store dashes (phone/ssn).
Click next and finish.

87
Q

Lookup Fields

A

You can add, delete, or edit values in the lookup field to adjust to changing data by changing the table containing the field options.

88
Q

Data Validation Rule

A

Open the table in Design view.
Click the field to which you will add a validation rule.
Click Validation Rule in the Field Properties pane.
Enter the validation rule.
Enter a meaningful error message in the Validation text.
Use to minimize data entry errors.

89
Q

Create an Input Mask - Input Mask Wizard

A

Open the table in Design view.
Click the field to which you will ad an input mask.
Click Input Mask in the Field Properties pane.
Click the ellipses at the end of the Input Mask Row.
Select one of the built-in masks from the menu.
Decide upon whether to store dashes (phone/ssn/zip).
Click next and finish.
The input mask now appears in Input Mask property box.

90
Q

Create a Parameter Query

A

Select Parameter query in the Navigation pane.
Click Report in the Reports group of the Create tab.
The Enter Parameter Value dialog box appears asking for the criterion.
Enter a value and click OK.
The report opes in Layout view, then save the report.

91
Q

Date Function

A

Calculates the current date.
Doesn’t require any parameters.
Type it in field row of an existing query or use the Expression builder.

92
Q

Expression Builder

A

Open a query in Design view or create a new query.
Click the Field row of a blank column.
Click Builder in the Query Setup group of the Design tab
Double click Functions in the Expression Elements section,
Double click Date in the Expression Values section, OK

93
Q

Round Function

A

Displays a number rounded to a specific number of decimal places, and requires a number and optional parameter specifying the number of decimal places.
Use same procedure as entering Date function.
IIf(Round([age])>24,”Approved”,”Not Approved”))

94
Q

Create If Function

A

In the Expression Builder, click Program Flow in the Expression Categories section.
Double click If in the Expression Values section.
Replace the placeholder text for the expression, true part, and false part with the desired values you want.

95
Q

Create IsNull Function

A

Checks whether a field has no value.
In the Expression Builder, click Inspection in the Expression Categories section, double click IsNull in the Expression Values section.
Replace the placeholder text for the expression you want to check, then OK.

96
Q

Create the DatePart Function

A

Examines a date and displays a portion of the date. Used to determine the year, month, or day and a number of other intervals as well.
In Expression Builder, click Date/Time in the Expression Categories section.
Double click DatePart in the Expression Values section and replace the placeholder text for the interval, date, first day of week, and first week of year, then OK.

97
Q

Create the DatePart Function

A

Examines a date and displays a portion of the date. Used to determine the year, month, or day and a number of other intervals as well.
In Expression Builder, click Date/Time in the Expression Categories section.
Double click DatePart in the Expression Values section and replace the placeholder text for the interval, date, first day of week, and first week of year, then OK.
DatePart(“yyyy”,FieldName)

VCU Fall 2017 (4 decks)

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