Module#1: Getting Started With Sage 300 Flashcards

1
Q

What is ERP?

A: Enterprise Resource Planning
B: Enter Recycling Plan
C: Engineered Resource Plan

A

A: Enterprise Resource Planning

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

What kind of Business does Sage 300 use?

A: Small to Medium
B: Medium to Large
C: Large to Massive

A

A: Small to Medium

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

What business operations are there?

A: Accounting
B: Inventory and Warehouse Management
C: Order Entry and Purchasing
D: All of the Above
E: A and B
F: C and D
A

D: All of the Above

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

What are some of the different modules?

A: General Ledger
B: Accounts Payable
C: Accounts Receivable
D: Inventory Control
E: Order Entry
F: All of the Above
G: A and B
H: C and E
A

F: All of the Above

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

What is the System Manager?

A: It controls Sage 300 and all that is involved
B: It controls access to all modules and provides tools to manage the company
C: It’s how you create Admin and Common Services

A

B: It controls access to all modules and provides tools to manage the company

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

What is the main component for System manager

A: Administrative Services
B: Common Services
C: Both

A

C: Both

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

What are the Administrative Services used for?

A: Activating Data
B: Checking Data Integrity
C: Maintaining user info
D: Dumping and Loading Databases
E: All of the Above
F: None of the Above
A

E: All of the Above

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

What are the Common Services used for?

A: Maintaining company information
B: Scheduling recurring transactions
C: Maintaining the fiscal calendar
D: Maintaining tax and bank info
E: All of the Above
F: None of the Above
A

E: All of the Above

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

Who uses the System Manager?

A: The One who opens Sage 300
B: The System Administrator
C: The G/L Manager

A

B: The System Administrator

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

What is the System Administrator responsible for?

A: Creating Different Ledgers and Accounts
B: Making Sure there are no Errors
C: Managing a Company’s Accounting System

A

C: Managing a Company’s Accounting System

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

What does the System Administrator use the system manager for?

A: To Create Databases
B: To set user groups
C: To specify what groups is authorized to do
D: All of the Above
E: None of the Above
A

D: All of the Above

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

What is a Database

A: Collection of info related to a subject or purpose
B: A way to monitor all information
C: A filing System like a telephone book

A

A: Collection of info related to a subject or purpose

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

What Structure does databases follow?

A: Columns and Rows
B: Fields and Records
C: Boxes and Checkmarks
D: All 
E: A and B
A

E: A and B

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

How can a database be stored?

A: Paper Form
B: Files
C: Cards
D: Digital 
E: Electronic form on computer accessible media
F: All of the Above
A

F: All of the Above

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

What are some examples of Databases?

A: Telephone book
B: Filing Cabinet
C: Cookbook
D: Store Catalog
E: All of the Above
A

E: All of the Above

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

There are 2 types of Databases, what are they?

A: System and Company
B: A/P and A/R
C: Administrative and Common

A

A: System and Company

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

What does the System databases store?

A: User information
B: Security Settings
C: Passwords
D: Currency Information
E: All of the Above
A

E: All of the Above

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

What is Created First:

A: System Database
B: Company Database?

A

A: System Database

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

Why must a System Database be created first?

A: Because it’s how Sage 300 Works
B: The Company Database connects to it
C: It’s Random and Doesn’t Matter

A

B: The Company Database connects to it

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

A Company Database is always connected to a system database?

A: True
B: False

A

A: True

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

What is Microsoft SQL Server?

A: Software that must be installed to run Sage modules
B: A different form of Sage 300 that you can
C: A way to manage all your ledgers and accounts

A

A: Software that must be installed to run Sage modules

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

What Editions of Microsoft SQL server can you use with Sage 300

A: Enterprise
B: Standard
C: Express
D: All
E: A and B
A

D: All

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

What Does database management systems such as Microsoft SQL Server enable users to do?

A: Create
B: View
C: Update
D: Delete Data
E: All
A

E: All

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

What does SQL stand for?

A: Standard Query Language
B: Structured Query Language
C: Stupid Query Language

A

B: Structured Query Language

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

True or False: You need to know how to use SQL in order to use Sage 300?

A: True
B: False

A

B: False, however it helps to understand that when you use sage it passes your commands to Microsoft SQL Server

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

In order to manage system and company databases you need to set them up twice, where do you set them up?

A: First in SQL then in Sage
B: First in Sage then SQL
C: it’s Automatic

A

A: First in SQL then in Sage

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

in what order do you set up databases in Microsoft SQL?

A: Connect to the Server
B: Open Microsoft SSMS (SQL Server Management Studio)
C: Create a New Company
D: Create a New System Database
E: Close Microsoft SSMS
A

1: Open Microsoft SSMS (SQL Server Management Studio)
2: Connect to the Server
3: Create a New System Database
4: Create a New Company
5: Close Microsoft SSMS

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

What are Authentication modes?

A: Windows
B: SQL Server
C: Both

A

C: Both

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

What does Windows Authentication mode do?

A: Connects to Sage 300 Live Chat
B: Connects through a windows user account
C: Makes you System Administrator

A

B: Connects through a windows user account

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

What does SQL Server Authentication mode do?

A: Allows SQL Server to Perform Authentication
B: Runs Diagnostic on Sage 300
C: Starts the General Ledger

A

A: Allows SQL Server to Perform Authentication

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

How do you create a new SQL Database?

A: Right Click Database folder and select new Database
B: Click the New Database Icon
C: You can’t create a new SQL Database

A

A: Right Click Database folder and select new Database

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

How many characters can a database name be?

A: 3 
B: 4
C: 5
D: 6
E: 7
A

D: 6

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

Define Collation

A: It’s rules that determine how data is sorted and compared
B: It’s when files and folders get merged together in one big folder
C: A collection of files and folders

A

A: It’s rules that determine how data is sorted and compared

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

What is A Recovery Model?

A: It’s when Sage 300 crashes and restart in the same place where you left
B: it defines about the database is logged and backed up
C: It’s a way to start Sage 300 in a recovery mode

A

B: it defines about the database is logged and backed up

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

In What Order do you set up databases in Sage

A: Create a new System Databas
B: Open the Database setup utility
C: Available options for the Databases Created in Sage
D: Close the Database setup utility

A

1: Open the Database setup utility
2: Create a new System Database
3: Available options for the Databases Created in Sage
4: Close the Database setup utility

36
Q

True or False: the Database ID must be the same name as the SQL System Database

A: True
B: False

A

A: True

37
Q

True or False: You have to change the description in the description field?

A: True
B: False

A

B: False, however it is recommended if you use multiple databases

38
Q

What is the Company colors feature?

A: A way to change Sage 300 colors and borders
B: A way to assign different colors to each company
C: A way to change Sage 300 Logo

A

B: A way to assign different colors to each company

39
Q

What happens when the Assign colors automatically box is selected?

A: A different color is automatically assigned to each of the company databases
B: A color that was selected is used for all Company Databases
C: Borders and lines are changed to a different color

A

A: A different color is automatically assigned to each of the company databases

40
Q

How do you remove colors?

A: Delete the Databases
B: Click Clear all Colors
C: Restart Sage 300

A

B: Click Clear all Colors

41
Q

Beside assigning colors what other changes can be made in Database setup window?

A: Modify Database Properties
B: Create a Custom Color
C: Both

A

C: Both

42
Q

What does the Delete Option do?

A: Deletes Profiles of Databases
B: Deletes Databases
C: Deletes Colors on Databases

A

A: Deletes Profiles of Databases

43
Q

What does the verify option do?

A: Checks for Errors
B: Checks the G/L
C: Verify all Financial postings

A

A: Checks for Errors

44
Q

What is the Security option?

A: To turn on the anti-virus for Sage 300
B: To run a scan for sage 300
C: Define advanced security settings for company and databases

A

C: Define advanced security settings for company and databases

45
Q

what is the set interval to create complex passwords?

A: 1 to 999 days
B: 1 to 100 Days
C: 1 to 10 Days
D: 1 to 1000 Days

A

A: 1 to 999 days

46
Q

How many characters can a password be between?

A: Between 1 and 10
B: Between 2 and 600
C: Between 4 and 64

A

C: Between 4 and 64

47
Q

Users can be locked out after incorrect login attempts. How many numbers can be set in between?

A: 1 to 999
B: 2 to 800
C: 3 to 700

A

A: 1 to 999

48
Q

How many minutes can be set?

A: 2 to 20,000
B: 1 to 30,000
C: 3 to 40,000

A

B: 1 to 30,000

49
Q

True or False: You always have to use the Run as administrator option when starting sage 300

A: True
B: False

A

True

50
Q

What is the Session Date?

A: The Date of your working session which defaults to the current day
B: The Date of your latest working session
C: The Date of the last working session

A

A: The Date of your working session which defaults to the current day

51
Q

Whats the first thing to do before you start working with a company?

A: Activate Administrative Services
B: Activate Common Services
C: Activate Both Services

A

A: Activate Administrative Services

52
Q

What happens if Administrative Services have not been activated?

A: Sage will say nothing
B: Sage will prompt you to do so
C: Sage will start will re-start Sage 300

A

B: Sage will prompt you to do so

53
Q

What day does the Fiscal year starting date default to?

A: The Date that Sage 300 was opened
B: The Date that was entered in the Open Company Window
C: The Date when you accessed G/L

A

B: The Date that was entered in the Open Company Window

54
Q

True or False: You cannot change the Fiscal starting date?

A: True
B: False

A

B: False you can change it if necessary

55
Q

What is Functional Currency?

A: Currency being used at the moment
B: Currency that a company uses to keep it’s books
C: Currency that is the most popular in the Country

A

B: Currency that a company uses to keep it’s books

56
Q

True or False: If you enter an incorrect currency you can change it, even if the company profile has been saved?

A: True
B: False

A

B: False, once the company profile has been saved you cannot change it

57
Q

What is the Multi-currency?

A: It’s when a company uses multiple currencies
B: It’s when a country has multiple currencies
C: It’s when different companies use different currencies

A

A: It’s when a company uses multiple currencies

58
Q

True or False: If you select multi-currency and save the company profile, you cannot change the option?

A: True
B: False

A

A: True.

59
Q

At the far bottom right on the status bar what does it display?

A: The Time
B: Current Session Date
C: Print Destination
D: All 3
E: B and C
A

E: B and C

60
Q

What is the pane on the left side of the window called?

A: The General Ledger Window
B: Modules and Services Pane
C: The Window Pane

A

B: Modules and Services Pane

61
Q

What does the Module and Service pane display?

A: Company Name
B: Modules that are activated
C: Services that are activated
D: All of the Above

A

D: All of the Above

62
Q

What is the default view?

A: Icon
B: Text
C: Photo

A

A: Icon

63
Q

What is Web Screens?

A: A way to look at data on your mobile device
B: Views data via Web Browser
C: another way to run sage 300

A

B: Views data via Web Browser

64
Q

What are other Database utilities?

A: Database Dump
B: Database Load
C: Database Copy
D: All of the Above

A

D: All of the Above

65
Q

True or False: You can use those other Database utilities while Sage 300 is active?

A: True
B: False

A

B: False

66
Q

What is Database Dump?

A: A way to extract data from a database to create a backup
B: A way to delete extra data from databases
C: A way to load Data onto Sage 300

A

A: A way to extract data from a database to create a backup

67
Q

What is Database Load?

A: A way to load deleted databases that were accidentally deleted
B: a way to load data sets that were extracted or dumped from a database
c: A way to start sage 300

A

B: a way to load data sets that were extracted or dumped from a database

68
Q

What is Database Copy?

A: A way to copy the contents of one database to another
B: A way to copy a database that was originally deleted
C: A way to copy some files to another database

A

A: A way to copy the contents of one database to another

69
Q

Out of the 3 Database utilities only 2 can be used inside sage 300…what are they?

A: Database Dump
B: Database Load
C: Database Copy
D: A and B
E: B and C
F: A and C
A

D: A and B

70
Q

What are Users Icon?

A: Allows System Administrator to Add users
B: Assign users to Security Groups
C: Control the operations users can perform
D: All of the Above

A

D: All of the Above

71
Q

To type a user ID what must it begin with?

A: A Letter
B: A number
C: A symbol

A

A: A letter

72
Q

What is Security Groups Icon

A: Where Security groups can be added
B: Where Security groups can be edited
C: Where Security groups can be deleted
D: All of the Above

A

D: All of the Above

73
Q

What is Customization Directories icon?

A: Used to store customized reports for users and security groups
B: A way to create new locations
C: Let’s you merge destinations

A

A: Used to store customized reports for users and security groups

74
Q

True or False: only the Admin can create customization directories?

A: True
B: False

A

True

75
Q

What are SAP Crystal Reports?

A: A Required way to customize or create new reports
B: Gives you specific reports
C: Let’s you print out Crystal Reports

A

A: A Required way to customize or create new reports

76
Q

What does UI stand for?

A: United Interface
B: User Intelligence
C: User Interface

A

C: User Interface

77
Q

True or False: Multiple UI profiles cannot be created?

A: True
B: False

A

B: False, they can be created

78
Q

Whose the only one who can add UI profiles to UI profile Maintenance?

A: User
B: Admin
C: Owner

A

B: Admin

79
Q

True or False: Multiple Users can be assigned to each UI Profile

A: True
B: False

A

A: True

80
Q

What is Visual Process flow?

A: Allows users to view Sage 300 differently
B: Aids users that shows them steps to complete a task or process
C: A Way to use both Sage 300 and Web Browser

A

B: Aids users that shows them steps to complete a task or process

81
Q

What is Data Integrity?

A: Way to check the integrity of all Data
B: Used to check Errors
C: A way to start scanning

A

B: Used to check Errors

82
Q

True or False: On the Data Integrity form you can choose to let sage fix minor errors?

A: True
B: False

A

True

83
Q

What is Restart Maintenance?

A: When you have to restart sage 300
B: Used to restart processing after an interruption
C: A way to choose different options for restarting Sage 300

A

B: Used to restart processing after an interruption

84
Q

What is Administrative Reports

A: Reports that are stored that will help with administration
B: Reports written by the Administrator
C: Reports that will be sent to the Administrator

A

A: Reports that are stored that will help with administration

85
Q

What is in the Common Services?

A: Company Profile
B: Fiscal Calendar
C: Scheduling
D: Currency
E: Tax Services
F: Bank Services
G: All of the Above
A

G: All of the Above

86
Q

Whats the max of length that a user ID be?

A: 8 Characters
B: 6 Characters
C: 10 Characters

A

A: 8 Characters