Module#1: Getting Started With Sage 300 Flashcards
What is ERP?
A: Enterprise Resource Planning
B: Enter Recycling Plan
C: Engineered Resource Plan
A: Enterprise Resource Planning
What kind of Business does Sage 300 use?
A: Small to Medium
B: Medium to Large
C: Large to Massive
A: Small to Medium
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
D: All of the Above
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
F: All of the Above
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
B: It controls access to all modules and provides tools to manage the company
What is the main component for System manager
A: Administrative Services
B: Common Services
C: Both
C: Both
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
E: All of the Above
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
E: All of the Above
Who uses the System Manager?
A: The One who opens Sage 300
B: The System Administrator
C: The G/L Manager
B: The System Administrator
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
C: Managing a Company’s Accounting System
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
D: All of the Above
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: Collection of info related to a subject or purpose
What Structure does databases follow?
A: Columns and Rows B: Fields and Records C: Boxes and Checkmarks D: All E: A and B
E: A and B
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
F: All of the Above
What are some examples of Databases?
A: Telephone book B: Filing Cabinet C: Cookbook D: Store Catalog E: All of the Above
E: All of the Above
There are 2 types of Databases, what are they?
A: System and Company
B: A/P and A/R
C: Administrative and Common
A: System and Company
What does the System databases store?
A: User information B: Security Settings C: Passwords D: Currency Information E: All of the Above
E: All of the Above
What is Created First:
A: System Database
B: Company Database?
A: System Database
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
B: The Company Database connects to it
A Company Database is always connected to a system database?
A: True
B: False
A: True
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: Software that must be installed to run Sage modules
What Editions of Microsoft SQL server can you use with Sage 300
A: Enterprise B: Standard C: Express D: All E: A and B
D: All
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
E: All
What does SQL stand for?
A: Standard Query Language
B: Structured Query Language
C: Stupid Query Language
B: Structured Query Language
True or False: You need to know how to use SQL in order to use Sage 300?
A: True
B: False
B: False, however it helps to understand that when you use sage it passes your commands to Microsoft SQL Server
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: First in SQL then in Sage
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
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
What are Authentication modes?
A: Windows
B: SQL Server
C: Both
C: Both
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
B: Connects through a windows user account
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: Allows SQL Server to Perform Authentication
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: Right Click Database folder and select new Database
How many characters can a database name be?
A: 3 B: 4 C: 5 D: 6 E: 7
D: 6
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: It’s rules that determine how data is sorted and compared
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
B: it defines about the database is logged and backed up
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
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
True or False: the Database ID must be the same name as the SQL System Database
A: True
B: False
A: True
True or False: You have to change the description in the description field?
A: True
B: False
B: False, however it is recommended if you use multiple databases
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
B: A way to assign different colors to each company
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 different color is automatically assigned to each of the company databases
How do you remove colors?
A: Delete the Databases
B: Click Clear all Colors
C: Restart Sage 300
B: Click Clear all Colors
Beside assigning colors what other changes can be made in Database setup window?
A: Modify Database Properties
B: Create a Custom Color
C: Both
C: Both
What does the Delete Option do?
A: Deletes Profiles of Databases
B: Deletes Databases
C: Deletes Colors on Databases
A: Deletes Profiles of Databases
What does the verify option do?
A: Checks for Errors
B: Checks the G/L
C: Verify all Financial postings
A: Checks for Errors
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
C: Define advanced security settings for company and databases
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: 1 to 999 days
How many characters can a password be between?
A: Between 1 and 10
B: Between 2 and 600
C: Between 4 and 64
C: Between 4 and 64
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: 1 to 999
How many minutes can be set?
A: 2 to 20,000
B: 1 to 30,000
C: 3 to 40,000
B: 1 to 30,000
True or False: You always have to use the Run as administrator option when starting sage 300
A: True
B: False
True
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: The Date of your working session which defaults to the current day
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: Activate Administrative Services
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
B: Sage will prompt you to do so
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
B: The Date that was entered in the Open Company Window
True or False: You cannot change the Fiscal starting date?
A: True
B: False
B: False you can change it if necessary
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
B: Currency that a company uses to keep it’s books
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
B: False, once the company profile has been saved you cannot change it
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: It’s when a company uses multiple currencies
True or False: If you select multi-currency and save the company profile, you cannot change the option?
A: True
B: False
A: True.
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
E: B and C
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
B: Modules and Services Pane
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
D: All of the Above
What is the default view?
A: Icon
B: Text
C: Photo
A: Icon
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
B: Views data via Web Browser
What are other Database utilities?
A: Database Dump
B: Database Load
C: Database Copy
D: All of the Above
D: All of the Above
True or False: You can use those other Database utilities while Sage 300 is active?
A: True
B: False
B: False
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 way to extract data from a database to create a backup
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
B: a way to load data sets that were extracted or dumped from a database
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 way to copy the contents of one database to another
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
D: A and B
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
D: All of the Above
To type a user ID what must it begin with?
A: A Letter
B: A number
C: A symbol
A: A letter
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
D: All of the Above
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: Used to store customized reports for users and security groups
True or False: only the Admin can create customization directories?
A: True
B: False
True
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 Required way to customize or create new reports
What does UI stand for?
A: United Interface
B: User Intelligence
C: User Interface
C: User Interface
True or False: Multiple UI profiles cannot be created?
A: True
B: False
B: False, they can be created
Whose the only one who can add UI profiles to UI profile Maintenance?
A: User
B: Admin
C: Owner
B: Admin
True or False: Multiple Users can be assigned to each UI Profile
A: True
B: False
A: True
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
B: Aids users that shows them steps to complete a task or process
What is Data Integrity?
A: Way to check the integrity of all Data
B: Used to check Errors
C: A way to start scanning
B: Used to check Errors
True or False: On the Data Integrity form you can choose to let sage fix minor errors?
A: True
B: False
True
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
B: Used to restart processing after an interruption
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: Reports that are stored that will help with administration
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
G: All of the Above
Whats the max of length that a user ID be?
A: 8 Characters
B: 6 Characters
C: 10 Characters
A: 8 Characters
